public static void InsertInvoice(List <SaleDetails> saleData, List <InstructorLearnerSchedule> schedule) { using (TransactionScope scope = new TransactionScope()) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { //save sale data Invoice invo = new Invoice(); InvoiceLineItem lineItem = new InvoiceLineItem(); //add invoice data SaleDetails saleInvoiceData = saleData.FirstOrDefault(); invo.CashierID = saleInvoiceData.CashierID; invo.CustomerID = saleInvoiceData.CustomerID; invo.Date = saleInvoiceData.Date; invo.InvoiceNumber = saleInvoiceData.InvoiceNumber; context.Invoices.Add(invo); context.SaveChanges(); foreach (var sale in saleData) { //add InvoiceLineItems lineItem.InvoiceID = invo.ID; lineItem.ProductID = sale.productID; lineItem.Quantity = (int)sale.Quantity; lineItem.Description = sale.Description; lineItem.Amount = sale.Amount; lineItem.Discount = sale.Discount; context.InvoiceLineItems.Add(lineItem); context.SaveChanges(); } // save schedule data ScheduleInstructor instructorLearnerSched = new ScheduleInstructor(); foreach (var shd in schedule) { instructorLearnerSched.BookingType = shd.BookingTpye; instructorLearnerSched.Date = shd.Date; instructorLearnerSched.InstructorID = shd.InstructorID; instructorLearnerSched.TimeSlotID = shd.slottedTime; instructorLearnerSched.StudentID = shd.StudentID; instructorLearnerSched.Pending = true; context.ScheduleInstructors.Add(instructorLearnerSched); context.SaveChanges(); } } scope.Complete(); } }
public static void InsertCustomer(Customer cust) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Customers.Add(cust); context.SaveChanges(); } }
public static void InsertUser(User usr) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Users.Add(usr); context.SaveChanges(); } }
public static void UpdateCustomerData(Customer customerData) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Entry(customerData).State = customerData.ID == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); } }
public static void UpdateVehicleData(Vehicle updateVehic) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Entry(updateVehic).State = updateVehic.ID == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); } }
public static void InsertVehicle(Vehicle vehicleData) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Vehicles.Add(vehicleData); context.SaveChanges(); } }
public static void InsertInstructor(Instructor instructorData) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Instructors.Add(instructorData); context.SaveChanges(); } }
public static void UpdateUserData(User updateUsr) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Entry(updateUsr).State = updateUsr.ID == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); } }
public static void InsertMaintenaceData(Maintenace maintananceData) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Maintenaces.Add(maintananceData); context.SaveChanges(); } }
public static void UpdateMaintenaceData(Maintenace updateMaintanance) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.Entry(updateMaintanance).State = updateMaintanance.ID == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); } }
public static void InsertFuelingData(VehicleFueling fuelingData) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { context.VehicleFuelings.Add(fuelingData); context.SaveChanges(); } }
public static void RescheduleLesson(int scheduleID, DateTime theDate, int slot) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { if (context.ScheduleInstructors.Where(t => t.ID == scheduleID).Any()) { var reScheduledbooking = context.ScheduleInstructors.Where(t => t.ID == scheduleID).Single(); reScheduledbooking.TimeSlotID = slot; reScheduledbooking.Date = theDate; context.SaveChanges(); } } }
public static void ResetPassword(PaswordReset passReset, string userPassHash) { using (var scope = new TransactionScope()) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { var sysUser = context.Users.Where(u => u.ID == passReset.UserID).First(); sysUser.PasswordHash = userPassHash; context.PaswordResets.Add(passReset); context.SaveChanges(); scope.Complete(); } } }
public static void ScheduleRecons(List <InstructorLearnerSchedule> scheduleList, byte UsrId) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { foreach (var sched in scheduleList) { var pending = sched.Complete == true || sched.Cancel == true ? false : true; var selectedSchedule = context.ScheduleInstructors.Where(i => i.ID == sched.ScheduleInstructorID).SingleOrDefault(); selectedSchedule.Cancelled = sched.Cancel; selectedSchedule.Completed = sched.Complete; selectedSchedule.NoShow = sched.NoShow; selectedSchedule.Pending = pending; selectedSchedule.ReconsComment = sched.Comment; selectedSchedule.ScheduleReconsDoneBy = UsrId; context.SaveChanges(); } } }
// public void InsertScheduleData public static void CancelSale(InvoiceData selectedItem) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { Invoice invoice = new Invoice { CancellationReason = selectedItem.CancellationReason, Cancelled = selectedItem.Cancelled, CancelledBy = selectedItem.CancelledBy, Date = selectedItem.Date, CashierID = selectedItem.CashierID, CustomerID = selectedItem.CustomerID, ID = selectedItem.ID, InvoiceNumber = selectedItem.InvoiceNumber }; context.Entry(invoice).State = invoice.ID == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); } }
public static void RescheduleRoadTest(int scheduleID, DateTime theDate, int slot, byte hourSlot) { using (drivingSchoolDBEntities context = new drivingSchoolDBEntities()) { if (context.ScheduleInstructors.Where(t => t.ID == scheduleID).Any()) { var reScheduleTest = context.ScheduleInstructors.Where(t => t.ID == scheduleID).Single(); var reScheduledest1 = context.ScheduleInstructors.Where(s => s.AffectedHourSlot == reScheduleTest.AffectedHourSlot && s.Date == reScheduleTest.Date && s.ID != scheduleID).Single(); reScheduledest1.TimeSlotID = slot + 1; reScheduledest1.Date = theDate; reScheduledest1.AffectedHourSlot = hourSlot; reScheduleTest.TimeSlotID = slot; reScheduleTest.Date = theDate; reScheduleTest.AffectedHourSlot = hourSlot; context.SaveChanges(); } } }