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