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) { } }