public void Add(Vehicle vehicle)
{
using (smartDrivingContext)
{
smartDrivingContext.Vehicle.Add(vehicle);
smartDrivingContext.SaveChanges();
}
}
public void Add(ActivityType activityType)
{
using (smartDrivingContext)
{
smartDrivingContext.ActivityType.Add(activityType);
smartDrivingContext.SaveChanges();
}
}
public void Add(Staff staff)
{
using (smartDrivingContext)
{
smartDrivingContext.Staff.Add(staff);
smartDrivingContext.SaveChanges();
}
}
public void Add(Customer customer)
{
using (smartDrivingContext)
{
smartDrivingContext.Customer.Add(customer);
smartDrivingContext.SaveChanges();
}
}
public void Add(Evaluation evaluation)
{
using (smartDrivingContext)
{
smartDrivingContext.Evaluation.Add(evaluation);
smartDrivingContext.SaveChanges();
}
}
public void Add(BookingLog bookingLog)
{
using (smartDrivingContext)
{
smartDrivingContext.BookingLog.Add(bookingLog);
smartDrivingContext.SaveChanges();
}
}
public void Add(PostalDistrict postalDistrict)
{
using (smartDrivingContext)
{
smartDrivingContext.PostalDistrict.Add(postalDistrict);
smartDrivingContext.SaveChanges();
}
}
public void Add(Staff staff)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Staffs.Add(staff);
ctx.SaveChanges();
}
}
public void Add(Activity activity)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Activitys.Add(activity);
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 void Add(Role booking)
{
using (var ctx = new SmartDrivingContext())
{
ctx.Roles.Add(booking);
ctx.SaveChanges();
}
}
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(PostalDistrict postalDistrict)
{
using (var ctx = new SmartDrivingContext())
{
ctx.PostalDistricts.Add(postalDistrict);
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(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(EvaluationType evaluationType)
{
using (var ctx = new SmartDrivingContext())
{
EvaluationType e = ctx.EvaluationTypes.Where(x => x.EvaluationTypeId == evaluationType.EvaluationTypeId).First();
e.Title = evaluationType.Title;
e.Description = evaluationType.Description;
ctx.SaveChanges();
}
}
public void Update(PostalDistrict postalDistrict)
{
using (var ctx = new SmartDrivingContext())
{
PostalDistrict p = ctx.PostalDistricts.Where(x => x.PostalDistrictId == postalDistrict.PostalDistrictId).First();
p.City = postalDistrict.City;
p.Zipcode = postalDistrict.Zipcode;
ctx.SaveChanges();
}
}
public void Update(Role booking)
{
using (var ctx = new SmartDrivingContext())
{
Role r = ctx.Roles.Where(x => x.RoleId == booking.RoleId).First();
r.RoleName = booking.RoleName;
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();
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
Activity a = ctx.Activitys.Where(x => x.ActivityId == id).FirstOrDefault();
if (a != null)
{
ctx.Activitys.Attach(a);
ctx.Activitys.Remove(a);
ctx.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
Customer c = ctx.Customers.Where(x => x.CustomerId == id).First();
if (c != null)
{
ctx.Customers.Attach(c);
ctx.Customers.Remove(c);
ctx.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
Role r = ctx.Roles.Where(x => x.RoleId == id).First();
if (r != null)
{
ctx.Roles.Attach(r);
ctx.Roles.Remove(r);
ctx.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
Booking b = ctx.Bookings.Where(x => x.BookingId == id).First();
if (b != null)
{
ctx.Bookings.Attach(b);
ctx.Bookings.Remove(b);
ctx.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
PostalDistrict p = ctx.PostalDistricts.Where(x => x.PostalDistrictId == id).FirstOrDefault();
if (p != null)
{
ctx.PostalDistricts.Attach(p);
ctx.PostalDistricts.Remove(p);
ctx.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
Staff s = ctx.Staffs.Where(x => x.StaffId == id).FirstOrDefault();
if (s != null)
{
ctx.Staffs.Attach(s);
ctx.Staffs.Remove(s);
ctx.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var ctx = new SmartDrivingContext())
{
Evaluation e = ctx.Evaluations.Where(x => x.EvaluationId == id).FirstOrDefault();
if (e != null)
{
ctx.Evaluations.Attach(e);
ctx.Evaluations.Remove(e);
ctx.SaveChanges();
}
}
}
