public string addBooking(List <Reservation> listOfReservations) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { foreach (Reservation r in listOfReservations) { var booking = new Booking() { BOOKING__ID = r.getBookingId(), CUSTOMER_ID = r.getCustomerId(), CAR_ID = r.getCarId(), BOOKING_DATE = r.getBookingDate(), AMOUNT_DUE = r.getBookingAmountDue(), RETURN_DATE = r.getReturnDate(), }; context.Bookings.Add(booking); } context.SaveChanges(); return("Reservation has been made"); } } catch (Exception e) { throw e; } }
public string addAdmin(Administrator tempAdmin) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Admin admin = new Admin { ADMIN_NAME = tempAdmin.getAdminName(), ADMIN_UNAME = tempAdmin.getAdminUname(), ADMIN_PWORD = tempAdmin.getAdminPword() }; if (context.Admins.Any(x => x.ADMIN_UNAME == admin.ADMIN_UNAME)) { return(null); } else { context.Admins.Add(admin); context.SaveChanges(); return(admin.ADMIN_UNAME); } } } catch (Exception e) { throw e; } }
public string addVehicle(Vehicle tempVehicle) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var car = new Car() { CAR_ID = tempVehicle.getCarId(), CAR_NAME = tempVehicle.getCarName(), CATEGORY = tempVehicle.getCarCategory(), COLOR = tempVehicle.getCarColor(), MFG_DATE = tempVehicle.getCarMfgDate(), INSURANCE_NO = tempVehicle.getCarInsurance(), REG_NO = tempVehicle.getCarRegNo(), RATE_PER_DAY = tempVehicle.getCarRatePerDay(), STATUS = "Available", DATE_OF_INCLUSION = DateTime.Today }; context.Cars.Add(car); context.SaveChanges(); return(car.CAR_NAME); //MessageBox.Show(car.CAR_NAME + " has been Added Successfully"); } } catch (Exception e) { throw e; } }
public void changeCarStatus(int id) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Car car = context.Cars.Where(x => x.CAR_ID == id).FirstOrDefault <Car>(); //context.Entry(manager).CurrentValues.SetValues(boss); //manager.MANAGER_UNAME = boss.getManagerUname(); car.STATUS = "Reserved"; //var manager = new Manager() //{ // MANAGER_NAME = boss.getManagerName(), // MANAGER_UNAME = boss.getManagerUname(), // MANAGER_PWORD = boss.getManagerPword() //}; context.SaveChanges(); } } catch (Exception e) { throw e; } }
public string updateStatus(string regNo, string status) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Car car = context.Cars.Where(x => x.REG_NO == regNo).FirstOrDefault <Car>(); //context.Entry(manager).CurrentValues.SetValues(boss); //manager.MANAGER_UNAME = boss.getManagerUname(); car.STATUS = status; //var manager = new Manager() //{ // MANAGER_NAME = boss.getManagerName(), // MANAGER_UNAME = boss.getManagerUname(), // MANAGER_PWORD = boss.getManagerPword() //}; context.SaveChanges(); return("Status changed Successfully"); } } catch (Exception e) { throw e; } }
public string updateManager(Boss boss, string uname) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Manager manager = context.Managers.Where(x => x.MANAGER_UNAME == uname).FirstOrDefault <Manager>(); //context.Entry(manager).CurrentValues.SetValues(boss); //manager.MANAGER_UNAME = boss.getManagerUname(); manager.MANAGER_NAME = boss.getManagerName(); manager.MANAGER_PWORD = boss.getManagerPword(); //var manager = new Manager() //{ // MANAGER_NAME = boss.getManagerName(), // MANAGER_UNAME = boss.getManagerUname(), // MANAGER_PWORD = boss.getManagerPword() //}; context.SaveChanges(); return(manager.MANAGER_UNAME); } } catch (Exception e) { throw e; } }
//public string deleteCustomer(string name) //{ // try // { // using (var context = new Vehicle_Reervation_DatabaseEntities()) // { // var customer = context.Customers.Where(x => x.NAME == name).SingleOrDefault<Customer>(); // context.Customers.Remove(customer); // context.SaveChanges(); // return customer.NAME; // } // } // catch (Exception e) // { // return "User not Found"; // throw e; // } //} public bool deleteClient(string name) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Customer customer = context.Customers.Where(a => a.NAME == name).FirstOrDefault <Customer>(); if (customer != null) { context.Customers.Remove(customer); context.SaveChanges(); return(true); } else { return(false); } } } catch (Exception e) { Console.Write(e.StackTrace); } return(false); }
public string addManager(Boss boss) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var manager = new Manager() { MANAGER_NAME = boss.getManagerName(), MANAGER_UNAME = boss.getManagerUname(), MANAGER_PWORD = boss.getManagerPword() }; if (context.Managers.Any(x => x.MANAGER_UNAME == manager.MANAGER_UNAME)) { return(null); } else { context.Managers.Add(manager); context.SaveChanges(); return(manager.MANAGER_NAME); } } } catch (Exception e) { throw e; } }
public string updateEntryOperator(EntryOp entryOp, string uname) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { EntryOperator entryOperator = context.EntryOperators.Where(x => x.UNAME == uname).FirstOrDefault <EntryOperator>(); //context.Entry(manager).CurrentValues.SetValues(boss); //manager.MANAGER_UNAME = boss.getManagerUname(); entryOperator.ENTRYOP_NAME = entryOp.getEntryOpName(); entryOperator.PWORD = entryOp.getEntryOpPword(); //var manager = new Manager() //{ // MANAGER_NAME = boss.getManagerName(), // MANAGER_UNAME = boss.getManagerUname(), // MANAGER_PWORD = boss.getManagerPword() //}; context.SaveChanges(); return(entryOperator.ENTRYOP_NAME); } } catch (Exception e) { throw e; } }
public string addEntryOperator(EntryOp entryOp) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var entryOperator = new EntryOperator() { ENTRYOP_NAME = entryOp.getEntryOpName(), UNAME = entryOp.getEntryOpUname(), PWORD = entryOp.getEntryOpPword() }; if (context.EntryOperators.Any(x => x.UNAME == entryOperator.UNAME)) { return(null); } else { context.EntryOperators.Add(entryOperator); context.SaveChanges(); return(entryOperator.ENTRYOP_NAME); } } } catch (Exception e) { throw e; } }
public string deleteVehicle(int id) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var car = context.Cars.Where(a => a.CAR_ID == id).FirstOrDefault <Car>(); context.Cars.Remove(car); context.SaveChanges(); return(car.REG_NO); } } catch (Exception e) { throw e; } }
public string deleteManager(string name) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var manager = context.Managers.Where(x => x.MANAGER_NAME == name).SingleOrDefault <Manager>(); context.Managers.Remove(manager); context.SaveChanges(); return(manager.MANAGER_NAME); } } catch (Exception e) { return("User not Found"); throw e; } }
public string deleteEntryOperator(string name) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var entryOp = context.EntryOperators.Where(x => x.ENTRYOP_NAME == name).SingleOrDefault <EntryOperator>(); context.EntryOperators.Remove(entryOp); context.SaveChanges(); return(entryOp.ENTRYOP_NAME); } } catch (Exception e) { return("User not Found"); throw e; } }
public string addCustomer(Client client) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var customer = new Customer() { CUSTOMER_ID = client.getCustomerId(), NAME = client.getCustomerName(), ADDRESS = client.getCustomerAddress(), CNIC = client.getCustomerCnic(), LICENSE_NO = client.getCustomerLicense(), PHONE = client.getCustomerPhone(), DOB = client.getCustomerDoB(), }; if (context.Customers.Any(x => x.CNIC == customer.CNIC)) { return(null); } else { context.Customers.Add(customer); context.SaveChanges(); int id = customer.CUSTOMER_ID; return(customer.NAME); } } } catch (Exception e) { throw e; } }
public string updateCustomer(Client client, int id) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Customer customer = context.Customers.Where(x => x.CUSTOMER_ID == id).FirstOrDefault <Customer>(); //context.Entry(manager).CurrentValues.SetValues(boss); //manager.MANAGER_UNAME = boss.getManagerUname(); customer.CUSTOMER_ID = client.getCustomerId(); customer.NAME = client.getCustomerName(); customer.PHONE = client.getCustomerPhone(); customer.LICENSE_NO = client.getCustomerLicense(); customer.CNIC = client.getCustomerCnic(); customer.ADDRESS = client.getCustomerAddress(); customer.DOB = client.getCustomerDoB(); //var manager = new Manager() //{ // MANAGER_NAME = boss.getManagerName(), // MANAGER_UNAME = boss.getManagerUname(), // MANAGER_PWORD = boss.getManagerPword() //}; context.SaveChanges(); return(customer.NAME); } } catch (Exception e) { throw e; } }