public UserLogin GetUserRoleAndId(string username, string password) { using (var db = new RestaurantAutomationEntities()) { var result = from u in db.UserLogins where u.Username == username && u.Password == password select u; return(result.FirstOrDefault()); } }
public UserLogin GetUserName(int userId) { using (var db = new RestaurantAutomationEntities()) { var result = from u in db.UserLogins where u.UserId == userId select u; return(result.FirstOrDefault()); } }