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);
}
}
