private static XmlDocument LoadConfig(SiteConfigurationItems configType) { SiteConfigurationEntity config = Instance.Get(configType); XmlDocument XmlDoc = new XmlDocument(); XmlDoc.PreserveWhitespace = true; XmlDoc.LoadXml(config.ModulesConfiguration); return(XmlDoc); }
//------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Converts the Items object properties to SQL paramters and executes the update Items procedure. /// <example>[Example]bool status=ItemsSqlDataPrvider.Instance.Update(itemsObject);.</example> /// </summary> /// <param name="itemsObject">The Items object.</param> /// <returns>The status of update query.</returns> public void Update(SiteConfigurationEntity config) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("dbo.SiteConfiguration_Update", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ConfigID", SqlDbType.SmallInt, 2).Value = config.ConfigID; myCommand.Parameters.Add("@ModulesConfiguration", SqlDbType.NVarChar).Value = config.ModulesConfiguration; //---------------------------------------------------------------------------------- // Execute the command myConnection.Open(); myCommand.ExecuteNonQuery(); myConnection.Close(); //return status; } }
//------------------------------------------ #endregion #region --------------Get-------------- public SiteConfigurationEntity Get(SiteConfigurationItems configID) { using (SqlConnection myConnection = GetSqlConnection()) { SiteConfigurationEntity config = new SiteConfigurationEntity(); SqlCommand myCommand = new SqlCommand("dbo.SiteConfiguration_Get", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //--------------------------------------------------------------------- myCommand.Parameters.Add("@ConfigID", SqlDbType.SmallInt, 2).Value = (int)configID; //--------------------------------------------------------------------- // Execute the command SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { config = (SiteConfigurationEntity)GetEntity(dr, typeof(SiteConfigurationEntity)); } dr.Close(); myConnection.Close(); return(config); } }