// GET: FleetAssets/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FleetAsset fleetAsset = db.FleetAssets.Find(id);
if (fleetAsset == null)
{
return(HttpNotFound());
}
FABLists fabl = new FABLists()
{
fa = fleetAsset,
cp = db.Capacities.Where(w => fleetAsset.FleetNo == w.FleetNo).ToList(),
cl = db.Compliences.Where(v => fleetAsset.FleetNo == v.FleetNo).ToList(),
af = db.AdditionalFields.Where(r => fleetAsset.FleetNo == r.FleetNo).ToList(),
at = db.Attachments.Where(r => fleetAsset.FleetNo == r.FleetNo).ToList(),
};
ViewBag.SubTypeID = new SelectList(db.AssetSubTypes, "ID", "SubType", fleetAsset.SubTypeID);
ViewBag.TypeID = new SelectList(db.AssetTypes, "ID", "Type", fleetAsset.TypeID);
ViewBag.FleetAssetMakeID = new SelectList(db.FleetAssetMakes, "ID", "Manufacturer", fleetAsset.FleetAssetMakeID);
ViewBag.FleetAssetModelID = new SelectList(db.FleetAssetModels, "ID", "Name", fleetAsset.FleetAssetModelID);
ViewBag.FuelTypeID = new SelectList(db.FuelTypes, "ID", "Fuel", fleetAsset.FuelTypeID);
//return View(fabl);
return(View("Edit0", fleetAsset));
}
// GET: FleetAssets/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FleetAsset fleetAsset = db.FleetAssets.Find(id);
if (fleetAsset == null)
{
return(HttpNotFound());
}
return(View(fleetAsset));
}
public JsonResult Create(FleetAsset fleetAsset)
{
if (ModelState.IsValid)
{
db.FleetAssets.Add(fleetAsset);
db.SaveChanges();
//return RedirectToAction("Index");
}
ViewBag.SubTypeID = new SelectList(db.AssetSubTypes, "ID", "SubType", fleetAsset.SubTypeID);
ViewBag.TypeID = new SelectList(db.AssetTypes, "ID", "Type", fleetAsset.TypeID);
ViewBag.FleetAssetMakeID = new SelectList(db.FleetAssetMakes, "ID", "Manufacturer", fleetAsset.FleetAssetMakeID);
ViewBag.FleetAssetModelID = new SelectList(db.FleetAssetModels, "ID", "Name", fleetAsset.FleetAssetModelID);
ViewBag.FuelTypeID = new SelectList(db.FuelTypes, "ID", "Fuel", fleetAsset.FuelTypeID);
return(Json(fleetAsset));
}
// GET: FleetAssets/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FleetAsset fleetAsset = db.FleetAssets.Find(id);
if (fleetAsset == null)
{
return(HttpNotFound());
}
FABLists fabl = new FABLists()
{
fa = fleetAsset,
cl = db.Compliences.Where(c => fleetAsset.FleetNo == c.FleetNo).ToList(),
cp = db.Capacities.Where(v => fleetAsset.FleetNo == v.FleetNo).ToList(),
af = db.AdditionalFields.Where(a => fleetAsset.FleetNo == a.FleetNo).ToList(),
at = db.Attachments.Where(r => fleetAsset.FleetNo == r.FleetNo).ToList(),
};
return(View(fabl));
}
public ActionResult DeleteConfirmed(string id)
{
FleetAsset fleetAsset = db.FleetAssets.Find(id);
List <Complience> complFA = db.Compliences.Where(c => fleetAsset.FleetNo == c.FleetNo).ToList();
List <AdditionalField> addfFA = db.AdditionalFields.Where(a => fleetAsset.FleetNo == a.FleetNo).ToList();
List <Capacity> capalFA = db.Capacities.Where(v => fleetAsset.FleetNo == v.FleetNo).ToList();
List <Attachment> attaFA = db.Attachments.Where(g => fleetAsset.FleetNo == g.FleetNo).ToList();
//delete capacities with this FANo
foreach (Capacity cap in capalFA)
{
db.Capacities.Remove(cap);
}
//delete compliences with this FANo
foreach (Complience com in complFA)
{
db.Compliences.Remove(com);
}
//delete Additional Fields with this FANo
foreach (AdditionalField ad in addfFA)
{
db.AdditionalFields.Remove(ad);
}
//delete Attachment Fields with this FANo
foreach (Attachment at in attaFA)
{
db.Attachments.Remove(at);
}
//delete this FA
db.FleetAssets.Remove(fleetAsset);
db.SaveChanges();
return(RedirectToAction("Index"));
}
