public static tblUser CurrentUser() { tblUser userInfo = null; using (ticketmanagmentEntities db = new ticketmanagmentEntities()) { var userid = Convert.ToInt32(HttpContext.Current.User.Identity.Name); userInfo = db.tblUsers.Where(x => x.userId == userid ).FirstOrDefault(); } return userInfo; }
public tblUser AuthenticateUser(LoginModel objLoginModel) { tblUser objLogin = null; using (ticketmanagmentEntities dbobj = new ticketmanagmentEntities()) { objLogin= dbobj.tblUsers.Where(x => x.userName == objLoginModel.UserName && x.Password == objLoginModel.Password && x.RoleId == objLoginModel.UserRole && x.IsActive == true ).FirstOrDefault(); } return objLogin; }
public List<CategoryModel> GetAllCategoryList() { List<CategoryModel> CategoryList = null; using (ticketmanagmentEntities db = new ticketmanagmentEntities()) { CategoryList = db.tblCategories.Where(x => x.IsActive == true).Select(x => new CategoryModel { CategoryId = x.CategoryId, CatgoryName = x.CatgoryName, }).ToList(); } return CategoryList; }