//delete one item from Inventory table
public static List <ModelZoneMap> DeleteModel(ModelZoneMap e)
{
var model1 = (from model in db.ModelZoneMaps
where model.Model.Contains(model.Model)
select model).SingleOrDefault();
db.ModelZoneMaps.Remove(model1);
db.SaveChanges();
return(GetAllModels());
}
public IHttpActionResult GetModelZoneMap(int id)
{
ModelZoneMap modelZoneMap = db.ModelZoneMaps.Find(id);
if (modelZoneMap == null)
{
return(NotFound());
}
return(Ok(modelZoneMap));
}
public IHttpActionResult PostModelZoneMap(ModelZoneMap modelZoneMap)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ModelZoneMaps.Add(modelZoneMap);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = modelZoneMap.Seq }, modelZoneMap));
}
public IHttpActionResult DeleteModelZoneMap(int id)
{
ModelZoneMap modelZoneMap = db.ModelZoneMaps.Find(id);
if (modelZoneMap == null)
{
return(NotFound());
}
db.ModelZoneMaps.Remove(modelZoneMap);
db.SaveChanges();
return(Ok(modelZoneMap));
}
//update one model into model table
public static List <ModelZoneMap> UpdateInventory(ModelZoneMap e)
{
var model1 = (from model in db.ModelZoneMaps
where model.Model.Equals(e.Model)
select model);
foreach (ModelZoneMap i in model1)
{
i.Zone1Code = e.Zone1Code;
}
db.SaveChanges();
return(GetAllModels());
}
//Insert one model into model table
public static List <ModelZoneMap> InsertInventory(ModelZoneMap e)
{
db.ModelZoneMaps.Add(e);
db.SaveChanges();
return(GetAllModels());
}
