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";
}
}
}
}
}
