internal int DeleteUserAccessById(string UserAccessId, string Ocode)
{
int aid = Convert.ToInt16(UserAccessId);
try
{
tbl_UserAccess userAccess = _context.tbl_UserAccess.First(i => i.UserAccessId == aid);
_context.tbl_UserAccess.DeleteObject(userAccess);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int SaveUserAccess(List <tbl_UserAccess> UserAccessList)
{
try
{
foreach (tbl_UserAccess aitem in UserAccessList)
{
tbl_UserAccess _userAccess = _context.tbl_UserAccess.FirstOrDefault(x => x.UserID == aitem.UserID && x.PageID == aitem.PageID && x.CategoryId == aitem.CategoryId && x.ModuleId == aitem.ModuleId);
if (_userAccess != null)
{
_context.DeleteObject(_userAccess);
_context.SaveChanges();
}
_context.tbl_UserAccess.AddObject(aitem);
_context.SaveChanges();
}
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void BtnSave_Clcik(object sender, EventArgs e)
{
try
{
List <tbl_UserAccess> UserAccessList = new List <tbl_UserAccess>();
CheckBox headerChkBox = ((CheckBox)gridviewPagePermissiones.HeaderRow.FindControl("headerLevelCheckBox"));
if (headerChkBox.Checked == true)
{
foreach (GridViewRow gvRow in gridviewPagePermissiones.Rows)
{
tbl_UserAccess UAccess = new tbl_UserAccess();
UAccess.UserID = new Guid(drpUserName.SelectedValue.ToString());
UAccess.UserName = drpUserName.SelectedItem.ToString();
UAccess.RoleID = Convert.ToInt32(drpRole.SelectedValue.ToString());
UAccess.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
UAccess.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
UAccess.EDIT_DATE = DateTime.Now;
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
Label lblPagePermissionId = ((Label)gvRow.FindControl("lblPageId"));
Label lblcatId = ((Label)gvRow.FindControl("lblcategoryhId"));
Label lblMulId = ((Label)gvRow.FindControl("lblModuleId"));
CheckBox rowCanVisit = ((CheckBox)gvRow.FindControl("chCanVisit"));
CheckBox rowCanEdit = ((CheckBox)gvRow.FindControl("ChCanEdit"));
CheckBox rowCanDelete = ((CheckBox)gvRow.FindControl("ChCanDelete"));
CheckBox rowcanExecute = ((CheckBox)gvRow.FindControl("ChCanExecute"));
UAccess.PageID = Convert.ToInt32(lblPagePermissionId.Text);
UAccess.CategoryId = Convert.ToInt32(lblcatId.Text);
UAccess.ModuleId = Convert.ToInt32(lblMulId.Text);
UAccess.CanVisit = Convert.ToBoolean(rowCanVisit.Checked);
UAccess.CanExecute = Convert.ToBoolean(rowcanExecute.Checked);
UAccess.CanEdit = Convert.ToBoolean(rowCanEdit.Checked);
UAccess.CanDelete = Convert.ToBoolean(rowCanDelete.Checked);
UserAccessList.Add(UAccess);
rowChkBox.Checked = true;//((CheckBox)sender).Checked;
}
}
else
{
foreach (GridViewRow gvRow in gridviewPagePermissiones.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
tbl_UserAccess UAccess = new tbl_UserAccess();
UAccess.UserID = Guid.Parse(drpUserName.SelectedValue.ToString());
UAccess.UserName = drpUserName.SelectedItem.ToString();
UAccess.RoleID = Convert.ToInt32(drpRole.SelectedValue.ToString());
UAccess.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
UAccess.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
UAccess.EDIT_DATE = DateTime.Now;
Label lblPagePermissionId = ((Label)gvRow.FindControl("lblPageId"));
Label lblcatId = ((Label)gvRow.FindControl("lblcategoryhId"));
Label lblMulId = ((Label)gvRow.FindControl("lblModuleId"));
CheckBox rowCanVisit = ((CheckBox)gvRow.FindControl("chCanVisit"));
CheckBox rowCanEdit = ((CheckBox)gvRow.FindControl("ChCanEdit"));
CheckBox rowCanDelete = ((CheckBox)gvRow.FindControl("ChCanDelete"));
CheckBox rowcanExecute = ((CheckBox)gvRow.FindControl("ChCanExecute"));
UAccess.PageID = Convert.ToInt32(lblPagePermissionId.Text);
UAccess.CategoryId = Convert.ToInt32(lblcatId.Text);
UAccess.ModuleId = Convert.ToInt32(lblMulId.Text);
UAccess.CanVisit = Convert.ToBoolean(rowCanVisit.Checked);
UAccess.CanExecute = Convert.ToBoolean(rowcanExecute.Checked);
UAccess.CanEdit = Convert.ToBoolean(rowCanEdit.Checked);
UAccess.CanDelete = Convert.ToBoolean(rowCanDelete.Checked);
UserAccessList.Add(UAccess);
}
}
}
int result = UserAccessBllObj.SaveUserAccess(UserAccessList);
if (result == 1)
{
//lblStatus.Text = "Data Save Successfully.";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true);
}
}
catch (Exception)
{
throw;
}
}
