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 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 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 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 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 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 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 Boss managerCredentials(string uname) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Manager manager = context.Managers.Where(a => a.MANAGER_UNAME == uname).FirstOrDefault <Manager>(); if (manager == null) { return(null); } else { Boss boss = new Boss(manager.MANAGER_UNAME, manager.MANAGER_NAME, manager.MANAGER_PWORD); return(boss); } } } catch (Exception e) { throw e; } }
public EntryOp entryOperatorCredentials(string uname) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { EntryOperator entryOperator = context.EntryOperators.Where(a => a.UNAME == uname).FirstOrDefault <EntryOperator>(); if (entryOperator == null) { return(null); } else { EntryOp entryOp = new EntryOp(entryOperator.UNAME, entryOperator.ENTRYOP_NAME, entryOperator.PWORD); return(entryOp); } } } catch (Exception e) { throw e; } }
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 int customerIDIncrementer() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var customers = context.Customers.OrderByDescending(x => x.CUSTOMER_ID); if (customers.Count() > 0) { var lastId = customers.FirstOrDefault <Customer>(); return(++lastId.CUSTOMER_ID); } else { return(0); } } } 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 Client customerRemovalCredentials(string name) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Customer customer = context.Customers.Where(a => a.NAME == name).FirstOrDefault <Customer>(); if (customer == null) { return(null); } else { Client client = new Client(customer.CUSTOMER_ID, customer.NAME, customer.ADDRESS, customer.CNIC, customer.LICENSE_NO, customer.PHONE, customer.DOB); return(client); } } } catch (Exception e) { throw e; } }
public Reservation reservationDetails(int id) { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { Booking booking = context.Bookings.Where(a => a.BOOKING__ID == id).FirstOrDefault <Booking>(); if (booking == null) { return(null); } else { Reservation reservation = new Reservation(booking.BOOKING__ID, booking.CUSTOMER_ID, booking.CAR_ID, (float)booking.AMOUNT_DUE, booking.BOOKING_DATE, booking.RETURN_DATE); return(reservation); } } } catch (Exception e) { throw e; } }
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 int bookingIDIncrementer() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { var bookings = context.Bookings.OrderByDescending(x => x.BOOKING__ID); if (bookings.Count() > 0) { var lastId = bookings.FirstOrDefault <Booking>(); return(++lastId.BOOKING__ID); } else { return(0); } } } catch (Exception e) { throw e; } }
public int thisMonthCustomers() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { int thisMonthCustomers = context.Customers.Where(x => x.DATE_OF_REG.Month == DateTime.Today.Month).Count(); return(thisMonthCustomers); } }
public double thisMonthIncomeGenerated() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { double income = context.Bookings.Where(x => x.BOOKING_DATE.Month == DateTime.Today.Month).Sum(x => x.AMOUNT_DUE); return(income); } }
public int thisMonthBookings() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { int bookingsThisMonth = context.Bookings.Where(x => x.BOOKING_DATE.Month == DateTime.Today.Month).Count(); return(bookingsThisMonth); } }
public int totalVehicles() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { int totalVehicles = context.Cars.Count(); return(totalVehicles); } }
public int totalJeeps() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { int totalVehicles = context.Cars.Where(x => x.CATEGORY == "Jeep").Count(); return(totalVehicles); } }
public int thisMonthVehicles() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { int thisMonthVehicles = context.Cars.Where(x => x.DATE_OF_INCLUSION.Month == DateTime.Today.Month).Count(); return(thisMonthVehicles); } }
//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 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(), // }; // 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; // } //} //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; //} #region Operations for PDF Report public int totalBookingsToDate() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { int totalBookings = context.Bookings.Count(); return(totalBookings); } }
public double totalIncomeGenerated() { using (Vehicle_Reervation_DatabaseEntities context = new Vehicle_Reervation_DatabaseEntities()) { double income = context.Bookings.Sum(x => x.AMOUNT_DUE); return(income); } }
public List <Customer> customerComboBoxPopulator() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { List <Customer> customers = context.Customers.ToList <Customer>(); return(customers); } } catch (Exception e) { throw e; } }
public List <EntryOperator> entryOpComboBoxPopulator() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { List <EntryOperator> entryOps = context.EntryOperators.ToList <EntryOperator>(); return(entryOps); } } catch (Exception e) { throw e; } }
public List <Car> carComboBoxPopulator() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { List <Car> availableCars = context.Cars.Where(x => x.STATUS == "Available").ToList <Car>(); return(availableCars); } } catch (Exception e) { throw e; } }
public List <Car> vehicleManagementComboBoxPopulator() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { List <Car> availableCars = context.Cars.ToList <Car>(); return(availableCars); } } catch (Exception e) { throw e; } }
public List <Booking> ReservationComboBoxPopulator() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { List <Booking> reservations = context.Bookings.ToList <Booking>(); return(reservations); } } catch (Exception e) { throw e; } }
public List <Manager> managerComboBoxPopulator() { try { using (var context = new Vehicle_Reervation_DatabaseEntities()) { List <Manager> managers = context.Managers.ToList <Manager>(); //List<Boss> bosses = managers.Cast<Boss>().ToList(); return(managers); } } catch (Exception e) { throw e; } }