protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <LevelHeirarchyDetails> datalist = new List <LevelHeirarchyDetails>();
LevelHeirarchyDetails data = new LevelHeirarchyDetails();
data.CompanyID = ddlCompany.SelectedValue == null?"":ddlCompany.SelectedValue.ToString();
data.PlantID = ddlPlant.SelectedValue == null ? "" : ddlPlant.SelectedValue.ToString();
if (data.CompanyID == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "openWarning", "openWarningModal('Company ID required.');", true);
return;
}
if (data.PlantID == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "openWarning", "openWarningModal('Plant ID required.');", true);
return;
}
data.EffectiveFromDate = hfEffectiveFromDate.Value == null?DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : hfEffectiveFromDate.Value;
data.EffectiveToDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").ToString();
if (cbShop.Checked)
{
data.KeyValue = "Shop";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "Shop";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbShopCell.Checked)
{
data.KeyValue = "ShopCell";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "ShopCell";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbShopGroup.Checked)
{
data.KeyValue = "ShopGroup";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "ShopGroup";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbShopCellGroup.Checked)
{
data.KeyValue = "ShopCellGroup";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "ShopCellGroup";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbCell.Checked)
{
data.KeyValue = "Cell";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "Cell";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbCellGroup.Checked)
{
data.KeyValue = "CellGroup";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "CellGroup";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbPlantGroup.Checked)
{
data.KeyValue = "Group";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "Check");
}
else
{
data.KeyValue = "Group";
DBAccess.saveupdateLevelHeirarchyMenuDetails(data, "UnCheck");
}
if (cbShop.Checked)
{
data.KeyID = "5";
data.DisplayValue = "Shop";
DBAccess.saveupdateLevelHeirarchyDetails(data, "Check");
}
else
{
data.KeyID = "5";
data.DisplayValue = "Shop";
DBAccess.saveupdateLevelHeirarchyDetails(data, "UnCheck");
}
if (cbCell.Checked)
{
data.KeyID = "6";
data.DisplayValue = "Cell";
DBAccess.saveupdateLevelHeirarchyDetails(data, "Check");
}
else
{
data.KeyID = "6";
data.DisplayValue = "Cell";
DBAccess.saveupdateLevelHeirarchyDetails(data, "UnCheck");
}
if (cbPlantGroup.Checked)
{
data.KeyID = "7";
data.DisplayValue = "Group";
DBAccess.saveupdateLevelHeirarchyDetails(data, "Check");
}
else
{
data.KeyID = "7";
data.DisplayValue = "Group";
DBAccess.saveupdateLevelHeirarchyDetails(data, "UnCheck");
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "successMsg", "showSuccessMsg('Record saved Successfully.','');", true);
BindLevelHeirarchyData();
}
catch (Exception ex)
{
}
}
private void BindLevelHeirarchyData()
{
try
{
string company = "";
//if (lblCompany.Visible)
//{
// company = lblCompany.Text;
//}
if (ddlCompany.Visible)
{
company = ddlCompany.SelectedValue == null ? "" : ddlCompany.SelectedValue.ToString();
}
List <LevelHeirarchyDetails> dataList = new List <LevelHeirarchyDetails>();
LevelHeirarchyDetails data = new LevelHeirarchyDetails();
data.CompanyID = company;
data.PlantID = ddlPlant.SelectedValue == null ? "" : ddlPlant.SelectedValue.ToString();
dataList = DBAccess.getLevelHeirarchyDetails(data);
if (dataList.Count > 0)
{
cbShop.Checked = dataList.Where(x => x.KeyValue == "Shop").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "Shop").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbShop.Visible = dataList.Where(x => x.KeyValue == "Shop").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "Shop").Select(x => x.CheckOrUncheck).FirstOrDefault();
cbShopCell.Checked = dataList.Where(x => x.KeyValue == "ShopCell").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "ShopCell").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbShopCell.Visible = dataList.Where(x => x.KeyValue == "ShopCell").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "ShopCell").Select(x => x.CheckOrUncheck).FirstOrDefault();
cbShopGroup.Checked = dataList.Where(x => x.KeyValue == "ShopGroup").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "ShopGroup").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbShopGroup.Visible = dataList.Where(x => x.KeyValue == "ShopGroup").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "ShopGroup").Select(x => x.CheckOrUncheck).FirstOrDefault();
cbShopCellGroup.Checked = dataList.Where(x => x.KeyValue == "ShopCellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "ShopCellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbShopCellGroup.Visible = dataList.Where(x => x.KeyValue == "ShopCellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "ShopCellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault();
cbCell.Checked = dataList.Where(x => x.KeyValue == "Cell").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "Cell").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbCell.Visible = dataList.Where(x => x.KeyValue == "Cell").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "Cell").Select(x => x.CheckOrUncheck).FirstOrDefault();
cbCellGroup.Checked = dataList.Where(x => x.KeyValue == "CellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "CellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbCellGroup.Visible = dataList.Where(x => x.KeyValue == "CellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "CellGroup").Select(x => x.CheckOrUncheck).FirstOrDefault();
cbPlantGroup.Checked = dataList.Where(x => x.KeyValue == "Group").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "Group").Select(x => x.CheckOrUncheck).FirstOrDefault();
lbGroup.Visible = dataList.Where(x => x.KeyValue == "Group").Select(x => x.CheckOrUncheck).FirstOrDefault() == null ? false : dataList.Where(x => x.KeyValue == "Group").Select(x => x.CheckOrUncheck).FirstOrDefault();
hfEffectiveFromDate.Value = dataList.Select(x => x.EffectiveFromDate).FirstOrDefault() == null ? "" : dataList.Select(x => x.EffectiveFromDate).FirstOrDefault();
}
else
{
cbShop.Checked = false;
cbShopCell.Checked = false;
cbShopGroup.Checked = false;
cbShopCellGroup.Checked = false;
cbCell.Checked = false;
cbCellGroup.Checked = false;
cbPlantGroup.Checked = false;
hfEffectiveFromDate.Value = "";
lbShop.Visible = false;
lbShopCell.Visible = false;
lbShopGroup.Visible = false;
lbShopCellGroup.Visible = false;
lbCell.Visible = false;
lbCellGroup.Visible = false;
lbGroup.Visible = false;
}
}
catch (Exception ex)
{
}
}
