public IEnumerable <tblCar> GetAllCars()
{
using (var dbContext = new CarDealerDBEntities())
{
return(dbContext.tblCars.ToList());
}
}
public tblCar GetCar(int id)
{
using (var dbContext = new CarDealerDBEntities())
{
var dbCar = dbContext.tblCars.FirstOrDefault(x => x.Car_ID == id);
return(dbCar);
}
}
public bool Add(tblCar car)
{
using (var dbContext = new CarDealerDBEntities())
{
dbContext.tblCars.Add(car);
dbContext.SaveChanges();
return(true);
}
}
public bool Delete(tblCar car)
{
using (var dbContext = new CarDealerDBEntities())
{
var dbCar = dbContext.tblCars.FirstOrDefault(x => x.Car_ID == car.Car_ID);
if (dbCar != null)
{
dbContext.tblCars.Remove(dbCar);
dbContext.SaveChanges();
return(true);
}
return(false);
}
}
public bool Update(tblCar car)
{
using (var dbContext = new CarDealerDBEntities())
{
var old = dbContext.tblCars.FirstOrDefault(x => x.Car_ID == car.Car_ID);
old.SerialNumber = car.SerialNumber;
old.Make = car.Make;
old.Model = car.Model;
old.Color = car.Color;
old.Year = car.Year;
old.CarForSale = car.CarForSale;
dbContext.SaveChanges();
return(true);
}
}