HYTOS

        public static string GetDirectiveValue(string name)

        {

            string result = null;

            using (SqlConnection connection = new SqlConnection())

            {

                connection.ConnectionString = GetAvevaConnectionString_Admin();

                connection.Open();

                using (SqlCommand cmd = connection.CreateCommand())

                {

                    cmd.CommandText = string.Format("select DirectiveValue from ProjectDirectives where DirectiveName = '{0}'", name);

                    using (SqlDataReader dr = cmd.ExecuteReader())

                    {

                        if (dr.Read())

                            result = dr.GetString(0);

                    }

                }

                connection.Close();

            }

            return result;

        }

        public static DataTable GetDrawingTemplate()

        {

            DataTable dt = new DataTable();

            using (SqlConnection connection = new SqlConnection())

            {

                connection.ConnectionString = GetAvevaConnectionString_Reports();

                connection.Open();

                using (SqlCommand cmd = connection.CreateCommand())

                {

                    cmd.CommandText = "select ID, Name,IsDWG,DateCreation,MachineName,FutureUse1,FutureUse2 from DrawingTemplates where IsDWG=0";

                    using (SqlDataReader dr = cmd.ExecuteReader())

                        dt.Load(dr);

                }

                connection.Close();

            }

            return dt;

        }