private List<UserSettingModel> GetAllSettingBySelectedSettingId(int settingId) { List<UserSettingModel> userSettingModels = new List<UserSettingModel>(); string query = String.Format("Select * from tblUserAtDealer where SettingNameId=@settingId"); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.Clear(); command.Parameters.AddWithValue("@settingId", settingId); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { UserSettingModel userSettingModel = new UserSettingModel(); userSettingModel.ID = Convert.ToInt32(rdr[0]); userSettingModel.UserControlId = rdr[1].ToString(); userSettingModel.Status = rdr[2].ToString(); userSettingModels.Add(userSettingModel); } connection.Close(); } } return userSettingModels; }
//update.............................................. protected void upDateButton_Click(object sender, EventArgs e) { 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 = Convert.ToInt32(settingNameDropDownList.SelectedValue); } else { CheckBox chk = ctrl as CheckBox; userSettingModel.UserControlId = chk.ID; userSettingModel.Status = "False"; userSettingModel.settingNameId = Convert.ToInt32(settingNameDropDownList.SelectedValue); } 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 = Convert.ToInt32(settingNameDropDownList.SelectedValue); 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 = Convert.ToInt32(settingNameDropDownList.SelectedValue); } else { CheckBox chk = ctrl as CheckBox; userSettingModel.UserControlId = chk.ID; userSettingModel.Status = "False"; userSettingModel.settingNameId = Convert.ToInt32(settingNameDropDownList.SelectedValue); } 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 = Convert.ToInt32(settingNameDropDownList.SelectedValue); 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 = Convert.ToInt32(settingNameDropDownList.SelectedValue); userSettingModels.Add(userSettingModel); } else { selectedValueText += ddl.SelectedValue + "|" + ddl.SelectedItem.Text; userSettingModel.Status = selectedValueText; userSettingModel.settingNameId = Convert.ToInt32(settingNameDropDownList.SelectedValue); userSettingModels.Add(userSettingModel); } } } if (UpdateUserSettingPerName(userSettingModels) > 0) { statusLabel.Text = "Updated"; //ListItem listItem = new ListItem("Select setting", "-1"); //settingNameDropDownList.Items.Insert(0, listItem); } else { statusLabel.Text = "Not updated"; } }
private void CleaeAllField() { foreach (var ctrl in Panel1.Controls) { if (ctrl is CheckBox) { ((CheckBox) ctrl).Checked = false; } } foreach (var ctrl in Panel3.Controls) { if (ctrl is CheckBox) { ((CheckBox)ctrl).Checked = false; } } foreach (var ctrl in Panel6.Controls) { string selectedValueText = ""; UserSettingModel userSettingModel = new UserSettingModel(); if (ctrl is DropDownList) { DropDownList ddl = ctrl as DropDownList; ddl.Items.Clear(); } } }
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"; } } } } }