private void SaveSettings(int userId, string settingName, int settingValue, bool IsChecked) { Business.Settings.UserSettings objUserSettings = new Business.Settings.UserSettings(); Entity.Settings.UserSettings userSettings = new Entity.Settings.UserSettings() { IsActive = IsChecked, SettingName = settingName, SettingValue = settingValue, UserId = userId }; objUserSettings.Save(userSettings); }
public static void Save(Entity.Settings.UserSettings userSettings) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["addonsConstr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Appn_UserSettings_Save"; cmd.Parameters.AddWithValue("@UserId", userSettings.UserId); cmd.Parameters.AddWithValue("@SettingsName", userSettings.SettingName); cmd.Parameters.AddWithValue("@SettingValue", userSettings.SettingValue); cmd.Parameters.AddWithValue("@IsActive", userSettings.IsActive); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); con.Close(); } } }