public VehicleBooking Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.VehicleBookings.FirstOrDefault());
}
}
public IEnumerable <ActivityType> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.ActivityTypes.ToList());
}
}
public IEnumerable <Role> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Roles.Include(x => x.Staffs).ToList());
}
}
public IEnumerable <EvaluationType> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.EvaluationTypes.ToList());
}
}
public Evaluation Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Evaluations.FirstOrDefault());
}
}
public Vehicle Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Vehicles.Include(x => x.Bookings).FirstOrDefault());
}
}
public IEnumerable <Evaluation> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Evaluations.Include(x => x.Activity).ToList());
}
}
public IEnumerable <PostalDistrict> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.PostalDistricts.ToList());
}
}
public PostalDistrict Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.PostalDistricts.FirstOrDefault());
}
}
public Role Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Roles.Include(x => x.Staffs).FirstOrDefault());
}
}
public IEnumerable <BookingEvaluation> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.BookingEvaluations.ToList());
}
}
public Customer Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Customers.Include(x => x.Bookings).FirstOrDefault());
}
}
public IEnumerable <Customer> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Customers.Include(x => x.Bookings).ToList());
}
}
public IEnumerable <VehicleBooking> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.VehicleBookings.ToList());
}
}
public ActivityType Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.ActivityTypes.FirstOrDefault());
}
}
public void Add(BookingEvaluation bookingEvaluation)
{
using (var ctx = new SmartDrivingContext())
{
ctx.BookingEvaluations.Add(bookingEvaluation);
ctx.SaveChanges();
}
}
public void Add(Evaluation evaluation)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Evaluations.Add(evaluation);
ctx.SaveChanges();
}
}
public void Add(Staff staff)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Staffs.Add(staff);
ctx.SaveChanges();
}
}
public void Add(Customer customer)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Customers.Add(customer);
ctx.SaveChanges();
}
}
public void Add(VehicleBooking vehicleBooking)
{
using (var ctx = new SmartDrivingContext())
{
ctx.VehicleBookings.Add(vehicleBooking);
ctx.SaveChanges();
}
}
public IEnumerable <Activity> ReadAll()
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Activitys.Include(x => x.ActivityType).
Include(x => x.Bookings).ToList());
}
}
public void Add(Activity activity)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Activitys.Add(activity);
ctx.SaveChanges();
}
}
public void Add(PostalDistrict postalDistrict)
{
using (var ctx = new SmartDrivingContext())
{
ctx.PostalDistricts.Add(postalDistrict);
ctx.SaveChanges();
}
}
public void Add(Role booking)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Roles.Add(booking);
ctx.SaveChanges();
}
}
public Activity Get(int id)
{
using (var ctx = new SmartDrivingContext())
{
return(ctx.Activitys.Include(x => x.ActivityType)
.Include(x => x.Bookings).FirstOrDefault());
}
}
public void Update(Vehicle vehicle)
{
using (var ctx = new SmartDrivingContext())
{
Vehicle v = ctx.Vehicles.Where(x => x.VehicleId == vehicle.VehicleId).First();
v.RegistrationDtl = vehicle.RegistrationDtl;
ctx.SaveChanges();
}
}
public void Update(VehicleBooking vehicleBooking)
{
using (var ctx = new SmartDrivingContext())
{
VehicleBooking v = ctx.VehicleBookings.Where(x => x.VehicleBookingId == vehicleBooking.VehicleBookingId).First();
v.BookingId = vehicleBooking.BookingId;
ctx.SaveChanges();
}
}
public void Update(BookingEvaluation bookingEvaluation)
{
using (var ctx = new SmartDrivingContext())
{
BookingEvaluation b = ctx.BookingEvaluations.Where(x => x.BookingEvaluationId == bookingEvaluation.BookingEvaluationId).First();
b.EvaluationResulte = bookingEvaluation.EvaluationResulte;
ctx.SaveChanges();
}
}
public void Update(Evaluation evaluation)
{
using (var ctx = new SmartDrivingContext())
{
Evaluation e = ctx.Evaluations.Where(x => x.EvaluationId == evaluation.EvaluationId).First();
e.Resulte = evaluation.Resulte;
ctx.SaveChanges();
}
}
public void Update(ActivityType activityType)
{
using (var ctx = new SmartDrivingContext())
{
ActivityType a = ctx.ActivityTypes.Where(x => x.ActivityTypeId == activityType.ActivityTypeId).First();
a.Title = activityType.Title;
a.Description = activityType.Description;
ctx.SaveChanges();
}
}
