protected void btnAdd_Click(object sender, EventArgs e) { if (ValidateAndSave("Add") == false) { return; } UserPrivDTO newPriv = this.CreateObject(); //this.removeFromList(newPriv.UserId, newPriv.ViewId); if (ViewState["lstPriv"] != null) { lstPriv = (List <UserPrivDTO>)ViewState["lstPriv"]; } else { lstPriv = new List <UserPrivDTO>(); } lstPriv.Add(newPriv); ViewState["lstPriv"] = lstPriv; //dt.Rows.Add(selUser,selViewId,selViewName, isView, isInsert, isDelete,selInt,selHeadOfc,selCCO,selZone,selUnit,selArea,selBran,selDist,selUpz, // selProj,selGrade,selSect); grList.DataSource = lstPriv; grList.DataBind(); hfId.Value = ""; }
private UserPrivDTO CreateObject() { decimal selId = String.IsNullOrEmpty(hfId.Value)?0:Convert.ToDecimal(hfId.Value); string isView = chkView.Checked ? "Y" : "N"; string isInsert = chkInsert.Checked ? "Y" : "N"; string isDelete = chkDelete.Checked ? "Y" : "N"; string selUser = ddlUserId.SelectedValue.ToString().Trim(); int selViewId = Convert.ToInt32(ddlScreen.SelectedValue.Trim()); string selViewName = ddlScreen.SelectedItem.Text.ToString().Trim(); decimal selInt = Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()); selInt = selInt == 99999 || selInt <= 0 ? -1 : selInt; decimal selHeadOfc = ddlHeadOffice.Items.Count > 0 ? Convert.ToDecimal(ddlHeadOffice.SelectedValue.Trim()) : -1; decimal selCCO = ddlCCO.Items.Count > 0 ? Convert.ToDecimal(ddlCCO.SelectedValue.Trim()) : -1; decimal selZone = ddlZone.Items.Count > 0 ? Convert.ToDecimal(ddlZone.SelectedValue.Trim()) : -1; decimal selUnit = ddlUnit.Items.Count > 0 ? Convert.ToDecimal(ddlUnit.SelectedValue.Trim()) : -1; decimal selArea = ddlArea.Items.Count > 0 ? Convert.ToDecimal(ddlArea.SelectedValue.Trim()) : -1; decimal selBran = ddlBranch.Items.Count > 0 ? Convert.ToDecimal(ddlBranch.SelectedValue.Trim()) : -1; decimal selDist = ddlDistrict.Items.Count > 0 ? Convert.ToDecimal(ddlDistrict.SelectedValue.Trim()) : -1; decimal selUpz = Convert.ToDecimal(ddlUpazilla.SelectedValue.Trim()); decimal selProj = Convert.ToDecimal(ddlProject.SelectedValue.Trim()); decimal selGrade = Convert.ToDecimal(ddlGrade.SelectedValue.Trim()); decimal selSect = Convert.ToDecimal(ddlSector.SelectedValue.Trim()); objPriv = new UserPrivDTO(); objPriv.ID = selId; objPriv.AreaId = selArea; objPriv.BranchId = selBran; objPriv.CCOId = selCCO; objPriv.DeletePerm = isDelete; objPriv.DistrictId = selDist; objPriv.GradeId = selGrade; objPriv.HeadOfficeId = selHeadOfc; objPriv.InsertPerm = isInsert; objPriv.InsertedBy = Session["USERID"].ToString(); objPriv.InsertedDate = DateTime.Now; objPriv.InterventionId = selInt; objPriv.ProjectId = selProj; objPriv.SectorId = selSect; objPriv.UnitId = selUnit; objPriv.UpazillaId = selUpz; objPriv.UserId = selUser; objPriv.ViewId = selViewId; objPriv.PageName = selViewName; objPriv.ViewPerm = isView; objPriv.ZoneId = selZone; return(objPriv); }
//protected void grList_RowCommand(object sender, GridViewCommandEventArgs e) //{ // GridView _gridView = (GridView)sender; // // Get the selected index and the command name // int _selectedIndex = int.Parse(e.CommandArgument.ToString()); // string _commandName = e.CommandName; // _gridView.SelectedIndex = _selectedIndex; // switch (_commandName) // { // case ("DoubleClick"): // { // ddlUserId.SelectedValue = grList.DataKeys[_gridView.SelectedIndex].Values[0].ToString(); // ddlScreen.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[1].ToString(); // chkView.Checked=grList.DataKeys[_gridView.SelectedIndex].Values[2].ToString()=="Y"?true:false; // chkInsert.Checked=grList.DataKeys[_gridView.SelectedIndex].Values[3].ToString()=="Y"?true:false; // chkDelete.Checked=grList.DataKeys[_gridView.SelectedIndex].Values[4].ToString()=="Y"?true:false; // ddlIntervention.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[5].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), 0), ddlHeadOffice, "OfficeTitle", "OfficeID", true); // ddlHeadOffice.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[6].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlHeadOffice.SelectedValue.Trim())), ddlCCO, "OfficeTitle", "OfficeID", true); // ddlCCO.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[7].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlCCO.SelectedValue.Trim())), ddlZone, "OfficeTitle", "OfficeID", true); // ddlZone.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[8].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlZone.SelectedValue.Trim())), ddlUnit, "OfficeTitle", "OfficeID", true); // ddlUnit.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[9].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlUnit.SelectedValue.Trim())), ddlDistrict, "OfficeTitle", "OfficeID", true); // ddlDistrict.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[12].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlDistrict.SelectedValue.Trim())), ddlArea, "OfficeTitle", "OfficeID", true); // ddlArea.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[10].ToString(); // Common.FillDropDownList(objMasMgr.GetParentWiseOffice(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlArea.SelectedValue.Trim())), ddlBranch, "OfficeTitle", "OfficeID", true); // ddlBranch.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[11].ToString(); // ddlUpazilla.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[13].ToString(); // ddlProject.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[14].ToString(); // ddlGrade.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[15].ToString(); // ddlSector.SelectedValue=grList.DataKeys[_gridView.SelectedIndex].Values[16].ToString(); // ViewState["selectedPriv"] = this.CreateObject(); // this.removeFromList(grList.DataKeys[_gridView.SelectedIndex].Values[0].ToString(), Convert.ToInt32(grList.DataKeys[_gridView.SelectedIndex].Values[1])); // } // break; // case ("Delete"): // try // { // this.removeFromList(grList.DataKeys[_gridView.SelectedIndex].Values[0].ToString(), Convert.ToInt32(grList.DataKeys[_gridView.SelectedIndex].Values[1])); // grList.DataSource = null; // grList.DataBind(); // lstPriv = (List<UserPriv>)ViewState["lstPriv"]; // grList.DataSource = lstPriv; // grList.DataBind(); // } // catch (Exception ex) // { // lblMsg.Text = "Error : " + ex; // throw (ex); // } // break; // } //} private void removeFromList(decimal ID, List <UserPrivDTO> privlist) { //remove from list //lstPriv = (List<UserPriv>)ViewState["grPrivilegeList"]; if (privlist == null) { return; } UserPrivDTO exist = privlist.Where(pp => pp.ID.Equals(ID)).FirstOrDefault(); if (exist != null) { privlist.Remove(exist); } //ViewState["lstPriv"] = lstPriv; }
protected void btnView_Click(object sender, EventArgs e) { if (ValidateAndSave("View") == false) { return; } objPriv = new UserPrivDTO(); objPriv.UserId = ddlUsers.SelectedValue.ToString().Trim(); objPriv.ViewId = Convert.ToInt32(ddlScreens.SelectedValue.Trim()); // dtList = objEmpMgr.SelectTraining(); grPrivilegeList.DataSource = null; grPrivilegeList.DataBind(); lstPriv = objUserPriv.GetUserPrivPages(objPriv); ViewState["grPrivilegeList"] = lstPriv; grPrivilegeList.DataSource = lstPriv; grPrivilegeList.DataBind(); }
public List <UserPrivDTO> GetUserPrivPages(UserPrivDTO objPriv) { List <UserPriv> lstUserPriv = context.UserPrivs.Where(pp => pp.UserId.Equals(objPriv.UserId) && (objPriv.ViewId == -1 || pp.ViewId == objPriv.ViewId)).ToList(); List <UserPrivDTO> userPrivs = (from priv in lstUserPriv join view in context.ViewNames on priv.ViewId equals view.ViewId join interv in context.DivisionLists on priv.InterventionId equals interv.DivisionId into UserInt from intname in UserInt.DefaultIfEmpty() join headoff in context.OfficeLists on priv.HeadOfficeId equals headoff.OfficeID into userheadoff from headoffdef in userheadoff.DefaultIfEmpty() join cco in context.OfficeLists on priv.CCOId equals cco.OfficeID into Usercco from ccodef in Usercco.DefaultIfEmpty() join zone in context.OfficeLists on priv.ZoneId equals zone.OfficeID into Userzone from zonedef in Userzone.DefaultIfEmpty() join unit in context.OfficeLists on priv.UnitId equals unit.OfficeID into Userunit from unitdef in Userunit.DefaultIfEmpty() join area in context.OfficeLists on priv.AreaId equals area.OfficeID into Userarea from areadef in Userarea.DefaultIfEmpty() join bran in context.OfficeLists on priv.BranchId equals bran.OfficeID into Userbran from brandef in Userbran.DefaultIfEmpty() join dist in context.OfficeLists on priv.DistrictId equals dist.OfficeID into Userdist from distdef in Userdist.DefaultIfEmpty() join proj in context.ProjectLists on priv.ProjectId equals proj.ProjectId into Userproj from projdef in Userproj.DefaultIfEmpty() join grd in context.GradeLists on priv.GradeId equals grd.GradeId into Usergrd from grddef in Usergrd.DefaultIfEmpty() join sect in context.SectorLists on priv.SectorId equals sect.SectorId into Usersect from sectdef in Usersect.DefaultIfEmpty() select new UserPrivDTO() { ID = priv.ID, AreaId = priv.AreaId, BranchId = priv.BranchId, CCOId = priv.CCOId, DeletePerm = priv.DeletePerm, DistrictId = priv.DistrictId, GradeId = priv.GradeId, HeadOfficeId = priv.HeadOfficeId, InsertPerm = priv.InsertPerm, InterventionId = priv.InterventionId, InterventionName = intname == null ? "" : intname.DivisionName, HeadOfficeName = headoffdef == null ? "All" : headoffdef.OfficeTitle, CCOName = ccodef == null ? "All" : ccodef.OfficeTitle, ZoneName = zonedef == null ? "All" : zonedef.OfficeTitle, UnitName = unitdef == null ? "All" : unitdef.OfficeTitle, AreaName = areadef == null ? "All" : areadef.OfficeTitle, BranchName = brandef == null ? "All" : brandef.OfficeTitle, DistrictName = distdef == null ? "All" : distdef.OfficeTitle, ProjectName = projdef == null ? "All" : projdef.ProjectName, GradeName = grddef == null ? "All" : grddef.GradeName, SectorName = sectdef == null ? "All" : sectdef.SectorName, PageName = view.ViewName1, ProjectId = priv.ProjectId, SectorId = priv.SectorId, UnitId = priv.UnitId, UpazillaId = priv.UpazillaId, UserId = priv.UserId, ViewId = priv.ViewId, ViewPerm = priv.ViewPerm, ZoneId = priv.ZoneId }).ToList(); return(userPrivs); }