public long SaveRole(ClsRole objSave) { try { long roleId = 0; using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { var result = this.objDataContext.InsertOrUpdateRole(objSave.lgId, objSave.strRoleName, objSave.strDescription, objSave.blAllowKilometerLimit, objSave.lgCompanyID, mySession.Current.UserId, PageMaster.Role, objSave.blAllowDispatchBackDateEntry).FirstOrDefault(); if (result != null) { roleId = result.InsertedId; foreach (var item in objSave.strRights.Split(',')) { string[] strRight = item.Split('|'); this.objDataContext.InsertOrUpdateRolePermissions(strRight[0].longSafe(), roleId, strRight[1].longSafe(), strRight[2].boolSafe(), strRight[3].boolSafe(), strRight[4].boolSafe(), strRight[5].boolSafe(), strRight[6].boolSafe(), mySession.Current.UserId, PageMaster.Role); } } } scope.Complete(); } return(roleId); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId); return(0); } }
public bool IsRoleExists(long lgRoleId, string strRoleName, long lgCompnayId) { try { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { if (lgCompnayId > 0) { if (this.objDataContext.Roles.Where(x => x.Id != lgRoleId && x.IsDeleted == false && x.RoleName == strRoleName && x.CompanyId == lgCompnayId).Count() > 0) { return(true); } } else { if (this.objDataContext.Roles.Where(x => x.Id != lgRoleId && x.IsDeleted == false && x.RoleName == strRoleName).Count() > 0) { return(true); } } } return(false); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId); return(false); } }
public ClsRole GetRoleByRoleId(long lgRoleId) { ClsRole objClsRole = new ClsRole(); try { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { GetRoleByIdResult item = this.objDataContext.GetRoleById(lgRoleId).FirstOrDefault(); if (item != null) { objClsRole.lgId = item.Id; objClsRole.strRoleName = item.RoleName; objClsRole.strDescription = item.DESCRIPTION; objClsRole.blAllowKilometerLimit = Convert.ToBoolean(item.AllowKilometerLimit); objClsRole.blAllowDispatchBackDateEntry = Convert.ToBoolean(item.AllowDispatchBackDateEntry); objClsRole.lgCompanyID = Convert.ToInt32(item.CompanyID); } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId); } return(objClsRole); }
public List <SelectListItem> GetAllRoleForDropDown(long?CompanyId) { List <SelectListItem> lstRole = new List <SelectListItem>(); try { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { int AdminRoleID = Common.Enum.USER_ADMIN_ROLES.ADMIN.GetHashCode(); int SysAdminRoleID = Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode(); lstRole.Add(new SelectListItem { Text = "--Select--", Value = string.Empty }); List <GetRoleAllResult> lstRoleResult = this.objDataContext.GetRoleAll(mySession.Current.UserId, SysAdminRoleID, AdminRoleID).ToList(); if (lstRoleResult.Count > 0) { if (CompanyId == null || CompanyId == 0) { foreach (var item in lstRoleResult) { lstRole.Add(new SelectListItem { Text = item.RoleName, Value = item.Id.ToString() }); } } else { var lstCompanyFilterRoleResult = lstRoleResult.Where(x => x.CompanyID == CompanyId).ToList(); foreach (var item in lstCompanyFilterRoleResult) { lstRole.Add(new SelectListItem { Text = item.RoleName, Value = item.Id.ToString() }); } } } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId); } return(lstRole); }
public List <SearchRoleResult> SearchRole(int inRow, int inPage, string strSearch, string strSort) { try { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { int SysAdminRoleID = Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode(); int AdminRoleID = Common.Enum.USER_ADMIN_ROLES.ADMIN.GetHashCode(); return(this.objDataContext.SearchRole(inRow, inPage, strSearch, strSort, mySession.Current.UserId, SysAdminRoleID, AdminRoleID).ToList()); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId); return(null); } }
public bool IsRoleDeleted(long lgRoleId) { try { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { if (this.objDataContext.Roles.Where(x => x.Id == lgRoleId && x.IsDeleted == true).Count() > 0) { return(true); } return(false); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); return(false); } }
public DeleteRoleResult DeleteRole(string strRoleIdList, long lgDeletedBy) { try { using (this.objDataContext = new RoleDataContext(Functions.StrConnection)) { DeleteRoleResult result = this.objDataContext.DeleteRole(strRoleIdList, lgDeletedBy, PageMaster.Role, PageMaster.User).FirstOrDefault(); if (result == null) { result = new DeleteRoleResult(); } return(result); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId); return(null); } }