public override string[] GetRolesForUser(string username) { IHttpSessionState session = System.Web.SessionState.SessionStateUtility.GetHttpSessionStateFromContext(HttpContext.Current); if (null != session["Organization"]) { int UserID = 0; int RoleID = 0; try { MyGeneration.dOOdads.BusinessEntity.PushStaticConnectionString(); DAL.Master.User Users = new DL_WEB.DAL.Master.User(); Users.Where.Login.Value = username; Users.Where.Login.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; Users.Query.Load(); if (Users.RowCount == 1) { UserID = Users.UserID; } DAL.Master.UserRole UserRoles = new DL_WEB.DAL.Master.UserRole(); UserRoles.Where.UserID.Value = UserID; UserRoles.Where.UserID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; UserRoles.Where.OrganizationID.Value = (session["Organization"] as DAL.Master.Organization).OrganizationID; UserRoles.Where.OrganizationID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; UserRoles.Query.Load(); if (UserRoles.RowCount > 0) { string[] aRoles = new string[UserRoles.RowCount]; int counter = 0; DAL.Master.Role oRole = new DL_WEB.DAL.Master.Role(); do { oRole.LoadByPrimaryKey(UserRoles.RoleID); aRoles[counter++] = oRole.Name; } while (UserRoles.MoveNext()); return(aRoles); } } finally { MyGeneration.dOOdads.BusinessEntity.PopStaticConnectionString(); } } return(new string[0]); }
public override bool IsUserInRole(string username, string roleName) { int UserID = 0; int RoleID = 0; DAL.Master.User Users = new DL_WEB.DAL.Master.User(); Users.Where.Login.Value = username; Users.Where.Login.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; Users.Query.Load(); if (Users.RowCount == 1) { UserID = Users.UserID; } DAL.Master.Role Roles = new DL_WEB.DAL.Master.Role(); Roles.Where.Name.Value = roleName; Roles.Where.Name.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; Roles.Query.Load(); if (Roles.RowCount == 1) { RoleID = Roles.RoleID; } DAL.Master.UserRole UserRoles = new DL_WEB.DAL.Master.UserRole(); UserRoles.Where.RoleID.Value = RoleID; UserRoles.Where.RoleID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; UserRoles.Where.UserID.Value = UserID; UserRoles.Where.UserID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; UserRoles.Query.Load(); if (UserRoles.RowCount > 0) { return(true); } else { return(false); } }