public static string GetUserPasswordHashByUserName(string userName) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).Select(h => h.PasswordHash).First()); } }
public static int GetUserTypeByUserID(int userID) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { return(Convert.ToInt16(context.Users.Where(u => u.ID == userID).Select(v => v.UserType).FirstOrDefault())); } }
public static bool IsSysAdmin(int logIn) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.ID == logIn).Select(s => s.UserType).FirstOrDefault() == 1?true:false); } }
public static RoadTest_DayTimeSlot GetDaySlotsFromHourSlot(int hourSlot) { using (var context = new drivingSchoolDBEntities()) { return(context.RoadTest_DayTimeSlot.Where(x => x.RoadTestID == hourSlot).FirstOrDefault()); } }
public static int GetInstructorByCar(int reg) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { return(Convert.ToInt16(context.Instructors.Where(v => v.Vehicle == reg).Select(i => i.ID).FirstOrDefault())); }; }
//Get instructor free date public static IEnumerable <ScheduleInstructor> GetInstructorAvailableDate(int instruktah, int dateTimeSlot) { using (var context = new drivingSchoolDBEntities()) { return(context.ScheduleInstructors.Where(i => i.InstructorID == instruktah && i.TimeSlotID == dateTimeSlot).ToList()); } }
public static int GetTimeSlotID(string slotTime) { using (var context = new drivingSchoolDBEntities()) { return(context.DayTimeSlots.Where(x => x.TimeSlot == slotTime).Select(i => i.ID).FirstOrDefault()); } }
public static IEnumerable <Customer> GetAllCustomers() { using (var context = new drivingSchoolDBEntities()) { return(context.Customers.OrderBy(c => c.FirstName).ToList()); } }
public static IEnumerable <Customer> GetCustomersByID(int customerID) { using (var context = new drivingSchoolDBEntities()) { return(context.Customers.Where(i => i.ID == customerID).ToList()); } }
public static IEnumerable <Instructor> GetAllInstructors() { using (var context = new drivingSchoolDBEntities()) { return(context.Instructors.ToList()); } }
public static IEnumerable <UserType> GetUserType() { using (var context = new drivingSchoolDBEntities()) { return(context.UserTypes.ToList()); } }
public static IEnumerable <User> GetAllSupervisors() { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.UserType == 3).ToList()); } }
public static IEnumerable <Maintenace> GetAllMaintenanceDetails() { using (var context = new drivingSchoolDBEntities()) { return(context.Maintenaces.ToList()); } }
public static string GetUserPasswordHashByID(Byte userID) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.ID == userID).Select(h => h.PasswordHash).First()); } }
public static IEnumerable <SaleItem> GetAllSaleItems() { using (var context = new drivingSchoolDBEntities()) { return(context.SaleItems.ToList()); } }
public static Customer GetCustomerLastCustomer() { using (var context = new drivingSchoolDBEntities()) { return(context.Customers.OrderByDescending(o => o.ID).FirstOrDefault()); } }
public static decimal?GetSaleSaleItem(int itemID) { using (var context = new drivingSchoolDBEntities()) { return(context.SaleItems.Where(i => i.ID == itemID).Select(p => p.Price).FirstOrDefault()); } }
public static Customer GetCustomersByCustomerNumber(string customerNo) { using (var context = new drivingSchoolDBEntities()) { return(context.Customers.Where(i => i.CustomerNumber.Equals(customerNo, StringComparison.OrdinalIgnoreCase)).FirstOrDefault()); } }
public static int GetProductTypeID(int productID) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { return(Convert.ToInt32(context.SaleItems.Where(i => i.ID == productID).Select(x => x.SaleItemTypeID).FirstOrDefault())); } }
public static IEnumerable <Make> GetCarMake() { using (var context = new drivingSchoolDBEntities()) { return(context.Makes.ToList()); } }
public static IEnumerable <RoadTestTimeSlot> GetHourTimeSlots() { using (var context = new drivingSchoolDBEntities()) { return(context.RoadTestTimeSlots.ToList()); } }
public static IEnumerable <Colour> GetCarColor() { using (var context = new drivingSchoolDBEntities()) { return(context.Colours.ToList()); } }
public static byte GetUserIDByUserName(string userName) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.UserName == userName).Select(i => i.ID).First()); } }
public static IEnumerable <Fuel> GetCarFuel() { using (var context = new drivingSchoolDBEntities()) { return(context.Fuels.ToList()); } }
public static int?GetVehicleByInstructor(int instructor) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { return(Convert.ToInt16(context.Instructors.Where(i => i.ID == instructor).Select(v => v.Vehicle).FirstOrDefault())); }; }
public static IEnumerable <Vehicle> GetAllVehicles() { using (var context = new drivingSchoolDBEntities()) { return(context.Vehicles.ToList()); } }
public static string GetUserNameByID(int supervisorID) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.ID == supervisorID).Select(s => s.UserName).First()); } }
public static IEnumerable <Unit> GetAllUnits() { using (var context = new drivingSchoolDBEntities()) { return(context.Units.ToList()); } }
public static string GetUserFullNameByID(int userID) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.ID == userID).Select(s => s.Name + " " + s.Surname).First()); } }
public static bool CheckIfUserNameIsInUse(string userName) { using (var context = new drivingSchoolDBEntities()) { return(context.Users.Where(u => u.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).Any()? true:false); } }