public override string[] GetRolesForUser(string username) // public override string GetRolesForUser(string username) { // db = new HRMS_DATBASEEntities(); using (dbintjmrpEntities objContext = new dbintjmrpEntities()) { var objUser = objContext.tblUserLogins.FirstOrDefault(x => x.U_USERID == username); if (objUser == null) { return(null); } else { // string[] ret = objUser.Roles.Select(x => x.RoleName).ToArray(); //string[] ret8 = objContext.tblUserLogins.Select(x => x.U_USERID == username).Select(a=>a.).ToArray(); var ret2 = ((from r in objContext.tblUserLogins where r.U_USERID == objUser.U_USERID select new { r.U_ROLE }).FirstOrDefault()).U_ROLE; // string[] ret ;//= {"mm"}; // string s = ret2.U_ROLE; var myList = new List <string>(); myList.Add(ret2); // myList.add("item1"); // myList.add("item2"); string[] ret = myList.ToArray(); return(ret); } } }
public override bool ValidateUser(string username, string password) { dbintjmrpEntities db = new dbintjmrpEntities(); var user = db.tblUserLogins.Where(x => x.U_USERID.Equals(username) && x.U_PASSWORD.Equals(password)).FirstOrDefault(); if (user != null) { return(true); } else { return(false); } }