public loggedUserModel MemberAuthentication(loginUserModel model) { loggedUserModel UserAuth = null; if (model != null) { using (_ctx = new ApiSecurityEntities()) { UserAuth = ( from u in _ctx.UserAuthentications join r in _ctx.UserRoles on u.RoleID equals r.RoleID where u.LoginID == model.LoginId && u.Password == model.Password && u.StatusID == 1 select new { UserId = u.UserID, UserName = u.UserName, Role = r.RoleName, Status = (int)u.StatusID }).Select(x => new loggedUserModel { UserId = x.UserId, UserName = x.UserName, Role = x.Role, Status = (int)x.Status }).FirstOrDefault(); } } return(UserAuth); }
public loggedUserModel MemberAuthentication(loginUserModel model) { loggedUserModel UserAuth = null; if (model != null) { using (_ctx = new ERP_Entities()) { //UserAuth = ( // from u in _ctx.UserAuthentications // join r in _ctx.UserRoles on u.RoleID equals r.RoleID // where u.LoginID == model.LoginId && u.Password == model.Password && u.StatusID == 1 // select new // { // UserId = u.UserID, // UserName = u.UserName, // Role = r.RoleName, // Status = (int)u.StatusID // }).Select(x => new loggedUserModel // { // UserId = x.UserId, // UserName = x.UserName, // Role = x.Role, // Status = (int)x.Status // }).FirstOrDefault(); UserAuth = ( from u in _ctx.CmnUserAuthentications where u.LoginID == model.LoginId && u.Password == model.Password && u.StatusID == 1 select new { UserId = u.UserID, UserName = "******", Role = "Role", Status = (int)u.StatusID }).Select(x => new loggedUserModel { UserId = x.UserId, UserName = x.UserName, Role = x.Role, Status = (int)x.Status }).FirstOrDefault(); } } return(UserAuth); }
public JsonResult Login(loginUserModel model) { objAuth = new UserAuthentications(); loggedUserModel loggeddata = null; Session["UserSession"] = null; try { if (model != null) { loggeddata = objAuth.MemberAuthentication(model); loggeddata.Ip = HostService.GetIP(); Session["UserSession"] = loggeddata; Session["UserID"] = loggeddata.UserId; } } catch (Exception e) { e.ToString(); } return(Json(loggeddata, JsonRequestBehavior.AllowGet)); }