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