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();
}
}
}
