public void SaveCars(int id, string name, string color, int year)
{
using (var context = new localDbEntities())
{
context.CarsDbs.Add(new CarsDb()
{
Id = id,
Name = name,
Color = color,
Year = year
});
context.SaveChanges();
}
}
public void UpdateCars(int id, string name, string color, int year)
{
using (var context = new localDbEntities())
{
var carIdentity = context.CarsDbs.Where(c => c.Id == id).FirstOrDefault <CarsDb>();
if (carIdentity != null)
{
carIdentity.Name = name;
carIdentity.Color = color;
carIdentity.Year = year;
context.SaveChanges();
}
}
}
public IList <CarModels> GetCarDetails(int year)
{
IList <CarModels> cars = null;
using (var context = new localDbEntities())
{
cars = context.CarsDbs.Where(c => c.Year == year).Select(c => new CarModels()
{
Id = c.Id,
Name = c.Name,
Color = c.Color,
Year = (int)c.Year
}).ToList <CarModels>();
}
return(cars);
}
