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