public customer Create(customer newCustomer)
{
using (var db = new VSMSContext())
{
db.customers.Add(newCustomer);
db.SaveChanges();
}
return(newCustomer);
}
public user Create(user newuser)
{
using (var db = new VSMSContext())
{
db.users.Add(newuser);
db.SaveChanges();
}
return(newuser);
}
public vehicle Create(vehicle newVehicle)
{
using (var db = new VSMSContext())
{
db.vehicles.Add(newVehicle);
db.SaveChanges();
}
return(newVehicle);
}
public comboboxdata Create(comboboxdata newcomboboxdata)
{
using (var db = new VSMSContext())
{
db.comboboxdatas.Add(newcomboboxdata);
db.SaveChanges();
}
return(newcomboboxdata);
}
public void Update(int id_of_car, int sellPrice) //selling a vehicle
{
using (var db = new VSMSContext())
{
var toBeUpdated = db.vehicles.Where(c => c.vehicleId == id_of_car).First();
toBeUpdated.sprice = sellPrice;
toBeUpdated.status = "Sold";
db.SaveChanges();
}
}
public bool Delete(int rowId)
{
using (var db = new VSMSContext())
{
var toBeDeleted = db.vehicles.SingleOrDefault(c => c.vehicleId == rowId);
db.vehicles.Remove(toBeDeleted);
db.SaveChanges();
}
return(true);
}