public override int Add(Vehicle vh)
{
var vmy = Mapper.IMap.Map <VehicleModelYear>(vh);
using (var dbCtx = new VehicleDBEntities())
{
dbCtx.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[VehicleModelYear] ON");
dbCtx.VehicleModelYear.Add(vmy);
dbCtx.SaveChanges();
dbCtx.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[VehicleModelYear] OFF");
}
return(vmy.id);
}
public override bool Delete(int id)
{
using (var dbCtx = new VehicleDBEntities())
{
var vehicle = (from veh in dbCtx.VehicleModelYear
where veh.id == id
select veh).FirstOrDefault();
if (vehicle == null)
{
return(false);
}
else
{
dbCtx.VehicleModelYear.Remove(vehicle);
dbCtx.SaveChanges();
return(true);
}
}
}
public override bool Update(Vehicle vh)
{
using (var dbCtx = new VehicleDBEntities())
{
var vehicle = (from veh in dbCtx.VehicleModelYear
where veh.id == vh.Id
select veh).FirstOrDefault();
if (vehicle == null)
{
return(false);
}
else
{
vehicle.make = vh.Manufacturer;
vehicle.model = vh.Model;
vehicle.year = vh.Year;
dbCtx.SaveChanges();
return(true);
}
}
}