private bool Permission(int intRoleID, DataList dl, DataListItem di) { dynamic objPermission = new tblPermission(); int intTabID = 0; intTabID = (int)dl.DataKeys[di.ItemIndex]; objPermission.Where.AppTabID.Value = intTabID; objPermission.Where.AppRoleID.Value = intRoleID; objPermission.Query.Load(); if (objPermission.RowCount <= 0) { objPermission.AddNew(); objPermission.AppCreatedDate = DateTime.Now; objPermission.AppCreatedBy = (int)Session[appFunctions.Session.UserID.ToString()]; } objPermission.AppRoleID = intRoleID; if (di.FindControl("chkIsAdd") == null) { objPermission.AppIsAdd = false; } else { objPermission.AppIsAdd = ((CheckBox)di.FindControl("chkIsAdd")).Checked; } if (di.FindControl("chkIsEdit") == null) { objPermission.AppIsEdit = false; } else { objPermission.AppIsEdit = ((CheckBox)di.FindControl("chkIsEdit")).Checked; } if (di.FindControl("chkIsDelete") == null) { objPermission.AppIsDelete = false; } else { objPermission.AppIsDelete = ((CheckBox)di.FindControl("chkIsDelete")).Checked; } objPermission.AppIsView = ((CheckBox)di.FindControl("chkIsView")).Checked; objPermission.AppTabID = intTabID; objPermission.Save(); return(true); }
public bool Add(tblPermission obj) { try { repository.tblPermissions.Add(obj); repository.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Delete(int id) { try { tblPermission result = Get(id); if (result != null) { result.Deleted = true; repository.SaveChanges(); return(true); } return(false); } catch (Exception) { return(false); } }
public bool Update(tblPermission obj) { try { tblPermission result = Get(obj.PermissionId); if (result != null) { repository.Entry(result).CurrentValues.SetValues(obj); repository.SaveChanges(); return(true); } return(false); } catch (Exception) { return(false); } }
private bool Delete(int intPKID) { bool retval = false; objRole = new tblRole(); dynamic objPermission = new tblPermission(); objPermission.DeleteSelectedRoleTab(intPKID); var _with1 = objRole; if (_with1.LoadByPrimaryKey(intPKID)) { _with1.MarkAsDeleted(); _with1.Save(); } retval = true; objRole = null; return(retval); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //tblUser objUser = new tblUser(); //dgvGridView.DataSource = objUser.RecentUsers(Session[appFunctions.Session.UserID.ToString()].ToString(), Convert.ToBoolean(Session[appFunctions.Session.IsSuperAdmin.ToString()].ToString())); //dgvGridView.DataBind(); //objUser = null; ViewState["SortOrder"] = appFunctions.Enum_SortOrderBy.Asc; ViewState["SortColumn"] = ""; DataTable objPermissionDT = new DataTable(); if ((bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]) { tblTab objTab = new tblTab(); objTab.Query.AddOrderBy(tblTab.ColumnNames.AppDisplayOrder, MyGeneration.dOOdads.WhereParameter.Dir.ASC); objTab.Query.AddOrderBy(tblTab.ColumnNames.AppParentID, MyGeneration.dOOdads.WhereParameter.Dir.ASC); objTab.Where.AppIsShowOnDashboard.Value = true; objTab.Query.Load(); objPermissionDT = objTab.DefaultView.Table; } else { tblPermission objPermission = new tblPermission(); try { objPermissionDT = objPermission.LoadTabsForRole(Convert.ToInt32(Session[appFunctions.Session.RoleID.ToString()].ToString()), true); } catch { Response.Redirect("UserPannel.aspx"); } } rptDashBoardLinks.DataSource = objPermissionDT; rptDashBoardLinks.DataBind(); //string dashBoardString = ""; //foreach (DataRow dr in objPermissionDT.Rows) //{ // dashBoardString += "<div class='col-md-2 col-sm-3 col-xs-3' align='Center'>"; // dashBoardString += "<a href='" + dr["appWebPageName"].ToString() + "'>"; // if (dr["appIconPath"].ToString() != "") // { // dashBoardString += "<img src='" + dr["appIconPath"].ToString() + "' height='100px' width='100px' alt='" + dr["appTabName"] + "'/>"; // } // else // { // dashBoardString += "<img src='Images/NoImg.png' height='100px' width='100px' alt='" + dr["appTabName"] + "'/>"; // } // dashBoardString += "<div style='text=align:center;Width:100px;line-height:20Px;height:40Px;'>" + dr["appTabName"].ToString() + "</div>"; // dashBoardString += "</a>"; // dashBoardString += "</div>"; //} //DashBord.InnerHtml = dashBoardString; LoadDataGridInquiry(); } }
public void AddTotblPermissions(tblPermission tblPermission) { AddObject("tblPermissions", tblPermission); }
public static tblPermission CreatetblPermission(int permissionID, string branchId) { tblPermission tblPermission = new tblPermission(); tblPermission.PermissionID = permissionID; tblPermission.BranchId = branchId; return tblPermission; }
protected void btnLogIn_Click(object sender, System.EventArgs e) { clsEncryption objEncrypt = new clsEncryption(); objAdminUser = new tblUser(); objAdminUser.Where.AppUserName.Value = txtUserName.Text; try { objAdminUser.Where.AppPassword.Value = objEncrypt.Encrypt(txtPassword.Text, appFunctions.strKey.ToString()); } catch (Exception ex) { lblMsg.Text = "Invalid Username or Password"; SaveLog(false); return; } objAdminUser.Query.Load(); if (objAdminUser.RowCount > 0) { if (objAdminUser.AppIsActive) { if (chkRemeber.Checked) { httpCookie = new HttpCookie("JetAPIAdminUsername", objEncrypt.Encrypt(txtUserName.Text, appFunctions.strKey)); httpCookie.Expires = DateTime.Today.AddDays(10); Response.Cookies.Add(httpCookie); httpCookie = new HttpCookie("JetAPIAdminPassword", objEncrypt.Encrypt(txtPassword.Text, appFunctions.strKey)); httpCookie.Expires = DateTime.Today.AddDays(10); Response.Cookies.Add(httpCookie); } else { httpCookie = new HttpCookie("JetAPIAdminUsername", ""); httpCookie.Expires = DateTime.Today.AddDays(0); Response.Cookies.Add(httpCookie); httpCookie = new HttpCookie("JetAPIAdminPassword", ""); httpCookie.Expires = DateTime.Today.AddDays(0); Response.Cookies.Add(httpCookie); } Session[appFunctions.Session.UserID.ToString()] = objAdminUser.AppUserId; Session[appFunctions.Session.RoleID.ToString()] = objAdminUser.AppRoleId; Session[appFunctions.Session.UserName.ToString()] = objAdminUser.AppUserName; Session[appFunctions.Session.EmployeeName.ToString()] = objAdminUser.AppFullName; Session[appFunctions.Session.IsSuperAdmin.ToString()] = objAdminUser.AppIsSuperAdmin; objAdminUser.AppLastLoginTime = DateTime.Now; objAdminUser.Save(); SaveLog(true); if ((bool)Session[appFunctions.Session.IsSuperAdmin.ToString()] == false) { tblPermission objPermission = new tblPermission(); bool hasDashboardPermission = objPermission.CheckDeshbordTab(Session[appFunctions.Session.RoleID.ToString()].ToString()); //objPermission.CheckDeshbordTab(Session[appFunctions.Session.RoleID.ToString()].ToString()); if (hasDashboardPermission) { Response.Redirect("Dashboard.aspx"); } else { Response.Redirect("UserPanel.aspx"); } } else { Response.Redirect("Dashboard.aspx"); } } else { lblMsg.Text = "Your account is disabled, Contact to administrator."; SaveLog(false); } } else { lblMsg.Text = "Invalid Username or Password"; SaveLog(false); } }
private bool SaveData() { bool functionReturnValue = false; int intRoleId = 0; objRole = new tblRole(); objRole.Where.AppRoleName.Value = txtRoleName.Text; objRole.Query.AddResultColumn(tblRole.ColumnNames.AppRoleID); objRole.Query.Load(); if (objRole.RowCount > 0) { if (objRole.AppRoleID.ToString() != hdnPKID.Value.ToString()) { DInfo.ShowMessage("Role Name Already Exist", Enums.MessageType.Error); return(functionReturnValue); } } objRole = new tblRole(); if (string.IsNullOrEmpty(hdnPKID.Value)) { objRole.AddNew(); objRole.AppCreatedDate = DateTime.Now; objRole.AppCreatedBy = (int)Session[appFunctions.Session.UserID.ToString()]; } else { objRole.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } objRole.AppRoleName = txtRoleName.Text; objRole.AppDescription = txtDescription.Text; objRole.Save(); intRoleId = objRole.AppRoleID; tblPermission objPermission = new tblPermission(); DataList dlChild = default(DataList); DataList dlChild2 = default(DataList); foreach (DataListItem diMain in dlMain.Items) { //' Do diMain Permission(intRoleId, dlMain, diMain); dlChild = (DataList)diMain.FindControl("dlChild"); foreach (DataListItem diChild in dlChild.Items) { //' Do diChild Permission(intRoleId, dlChild, diChild); dlChild2 = (DataList)diChild.FindControl("dlChild2"); foreach (DataListItem diChild2 in dlChild2.Items) { //' Do diChil2 Permission(intRoleId, dlChild2, diChild2); } } } return(true); }
public void SetMenu() { tblPermission objPermisssion = new tblPermission(); //Change for manu and sub menu load DataTable DtTab = new DataTable(); objRole = new tblRole(); DtTab = objRole.LoadPermissionTabMenu(Session[appFunctions.Session.RoleID.ToString()].ToString(), 0.ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); for (int i = 0; i <= DtTab.Rows.Count - 1; i++) { if ((bool)DtTab.Rows[i]["AppIsMenu"]) { menuString += "<li><a href='#'>" + DtTab.Rows[i]["AppTabName"]; objMenuType = new tblMenuType(); DataTable menutypeDt = new DataTable(); menutypeDt = objMenuType.LoadMenuTypes(); menuString += "</a> "; //loadmenuChild(menutypeDt, 2, "0", true); menuString += "<ul>"; for (int j = 0; j <= menutypeDt.Rows.Count - 1; j++) { menuString += "<li><a href='MenuItems.aspx?ID=" + objEncrypt.Encrypt(menutypeDt.Rows[j]["appMenuTypeId"].ToString(), appFunctions.strKey) + "&type=mtype'>" + menutypeDt.Rows[j]["appMenuTypeName"].ToString(); menuString += "</a>"; menuString += "</li>"; } menuString += "</ul>"; menuString += "</li>"; } else { DataTable DtChildTab = new DataTable(); objRole = new tblRole(); DtChildTab = objRole.LoadPermissionTabMenu(Session[appFunctions.Session.RoleID.ToString()].ToString(), DtTab.Rows[i]["AppTabID"].ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); menuString += "<li><a href='" + DtTab.Rows[i]["appWebPageName"] + "'>" + DtTab.Rows[i]["AppTabName"]; menuString += "</a> "; loadchildmenu(DtChildTab, 2); //if ((bool)DtTab.Rows[i]["AppIsMenu"] == true) //{ // loadchildmenu(DtTab.Rows(i)("AppTabID").ToString, DtTab.Rows(i)("AppIsMenu"), DtTab.Rows(i)("AppIsTabAdd"), DtTab.Rows(i)("AppIsTabEdit")); //} //else //{ // menuString += "<li><a class='menuLink' id='" + DtTab.Rows(i)("AppTabID").ToString + "' href='" + DtTab.Rows(i)("appWebPageName") + "'>" + DtTab.Rows(i)("AppTabName") + "</a>"; // loadchildmenu(DtTab.Rows(i)("AppTabID").ToString, DtTab.Rows(i)("AppIsMenu"), DtTab.Rows(i)("AppIsTabAdd"), DtTab.Rows(i)("AppIsTabEdit")); //} menuString += "</li>"; } } litMainMenu.Text = menuString; }