public static User GetActiveUser(string username, string password) { using (var _d = new BioModel()) { return(_d.Users.FirstOrDefault( f => f.UserName == username && f.Password == password && f.UserIsActive == true)); } }
public static List <EmployeeData> GetEmployeeData() { using (var _d = new BioModel()) { var q = from q1 in _d.Empoyees select new EmployeeData { EnrolleeId = q1.EmployeeId, EnrolleeNo = q1.EmployeeNo, EnrolleeIdNo = q1.EmployeeIdNo, LastName = q1.EmployeeLastName, FirstName = q1.EmployeeFirstName, MiddleName = q1.EmployeeMiddleName }; return(q.OrderBy(o => o.LastName).ToList()); } }
public static List <EmployeeData> GetEmployeeData(int iId) { using (var _d = new BioModel()) { var q = from q1 in _d.Empoyees join q2 in _d.Positions on q1.PositionId equals q2.PositionId join q3 in _d.Departments on q2.DepartmentId equals q3.DepartmentId where q3.DepartmentId == iId select new EmployeeData { EnrolleeId = q1.EmployeeId, EnrolleeNo = q1.EmployeeNo, EnrolleeIdNo = q1.EmployeeIdNo, LastName = q1.EmployeeLastName, FirstName = q1.EmployeeFirstName, MiddleName = q1.EmployeeMiddleName }; return(q.OrderBy(o => o.LastName).ToList()); } }