protected void createButton_Click(object sender, EventArgs e)
{
int lastIdentityValue = 0;
UserSettingNameModel userSettingNameModel = new UserSettingNameModel();
userSettingNameModel.SettingName = settingTextBox.Text;
userSettingNameModel.DealerId = Convert.ToInt32(dealerDropDownList.SelectedValue);
if (settingTextBox.Text =="")
{
statusLabel.Text = "Please enter the setting name.";
}
else
{
if (IsSettingNameExist(settingTextBox.Text,Convert.ToInt32(dealerDropDownList.SelectedValue)))
{
statusLabel.Text = "This setting name already exist.";
}
else
{
if (SaveSettingName(userSettingNameModel)< 1)
{
statusLabel.Text = "Setting name not saved.";
}
else
{
lastIdentityValue = GetLastIdentityValue();
List<UserSettingModel> userSettingModels = new List<UserSettingModel>();
foreach (var ctrl in Panel1.Controls)
{
UserSettingModel userSettingModel = new UserSettingModel();
if (ctrl is CheckBox)
{
if ((((CheckBox)ctrl).Checked))
{
CheckBox chk = ctrl as CheckBox;
userSettingModel.UserControlId = chk.ID;
userSettingModel.Status = "True";
userSettingModel.settingNameId = lastIdentityValue;
}
else
{
CheckBox chk = ctrl as CheckBox;
userSettingModel.UserControlId = chk.ID;
userSettingModel.Status = "False";
userSettingModel.settingNameId = lastIdentityValue; ;
}
userSettingModels.Add(userSettingModel);
}
}
foreach (var ctrl in Panel2.Controls)
{
string selectedValueText = "";
UserSettingModel userSettingModel = new UserSettingModel();
if (ctrl is DropDownList)
{
DropDownList ddl = ctrl as DropDownList;
userSettingModel.UserControlId = ddl.ID;
selectedValueText += ddl.SelectedValue +"|"+ ddl.SelectedItem.Text;
userSettingModel.Status = selectedValueText;
userSettingModel.settingNameId = lastIdentityValue;
userSettingModels.Add(userSettingModel);
}
}
foreach (var ctrl in Panel3.Controls)
{
UserSettingModel userSettingModel = new UserSettingModel();
if (ctrl is CheckBox)
{
if ((((CheckBox)ctrl).Checked))
{
CheckBox chk = ctrl as CheckBox;
userSettingModel.UserControlId = chk.ID;
userSettingModel.Status = "True";
userSettingModel.settingNameId = lastIdentityValue;
}
else
{
CheckBox chk = ctrl as CheckBox;
userSettingModel.UserControlId = chk.ID;
userSettingModel.Status = "False";
userSettingModel.settingNameId = lastIdentityValue;
}
userSettingModels.Add(userSettingModel);
}
}
foreach (var ctrl in Panel4.Controls)
{
string selectedValueText = "";
UserSettingModel userSettingModel = new UserSettingModel();
if (ctrl is DropDownList)
{
DropDownList ddl = ctrl as DropDownList;
userSettingModel.UserControlId = ddl.ID;
selectedValueText += ddl.SelectedValue + "|" + ddl.SelectedItem.Text;
userSettingModel.Status = selectedValueText;
userSettingModel.settingNameId = lastIdentityValue;
userSettingModels.Add(userSettingModel);
}
}
foreach (var ctrl in Panel6.Controls)
{
string selectedValueText = "";
UserSettingModel userSettingModel = new UserSettingModel();
if (ctrl is DropDownList)
{
DropDownList ddl = ctrl as DropDownList;
userSettingModel.UserControlId = ddl.ID;
////
if (ddl.Items.Count == 0)
{
selectedValueText = "-3|noValue";
userSettingModel.Status = selectedValueText;
userSettingModel.settingNameId = lastIdentityValue;
userSettingModels.Add(userSettingModel);
}
else
{
selectedValueText += ddl.SelectedValue + "|" + ddl.SelectedItem.Text;
userSettingModel.Status = selectedValueText;
userSettingModel.settingNameId = lastIdentityValue;
userSettingModels.Add(userSettingModel);
}
////
}
}
if (SaveUserSettingsPerName(userSettingModels) > 0)
{
statusLabel.Text = "Saved";
GetAllSettingName(Convert.ToInt32(dealerDropDownList.SelectedValue));
ListItem listItem = new ListItem("Select setting", "-1");
settingNameDropDownList.Items.Insert(0, listItem);
int count = 0;
foreach (ListItem item in settingNameDropDownList.Items)
{
count++;
}
ListItem tempListItem = settingNameDropDownList.Items[count - 1];
settingNameDropDownList.Items.RemoveAt(count - 1);
settingNameDropDownList.Items.Insert(0, tempListItem);
}
else
{
statusLabel.Text = "Not saved";
}
}
}
}
}
private List<UserSettingNameModel> GetSettingNameRelatedToDealer(int dealerId)
{
List<UserSettingNameModel> userSettingNameModels = new List<UserSettingNameModel>();
string query = String.Format("Select * from tblSettingName where DealerId=@dealerId");
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString))
{
using (SqlCommand command = new SqlCommand(query,connection))
{
command.Parameters.Clear();
command.Parameters.AddWithValue("@dealerId", dealerId);
connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
UserSettingNameModel userSettingNameModel = new UserSettingNameModel();
userSettingNameModel.ID = Convert.ToInt32(rdr[0]);
userSettingNameModel.SettingName = rdr[1].ToString();
userSettingNameModels.Add(userSettingNameModel);
}
connection.Close();
}
}
return userSettingNameModels;
}
public int SaveSettingName(UserSettingNameModel userSettingNameModel)
{
int rowsInserted = 0;
string query = String.Format("Insert into tblSettingName values(@settingName,@dealerId)");
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString))
{
using (SqlCommand command = new SqlCommand(query,connection))
{
command.Parameters.Clear();
command.Parameters.AddWithValue("@settingName", userSettingNameModel.SettingName);
command.Parameters.AddWithValue("@dealerId", userSettingNameModel.DealerId);
connection.Open();
rowsInserted = command.ExecuteNonQuery();
connection.Close();
}
}
return rowsInserted;
}
