/*
* Last remaining development item for this iteration:
* 1. Implement the RemoveEquipmentOnCarton action on the CartonController, right now it is just
* throwing a BadRequest.
*/
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
if (ModelState.IsValid)
{
//KF: implement the remove function
try
{
var equipment = (from cd in db.CartonDetails
where cd.CartonId == removeEquipmentViewModel.CartonId &&
cd.EquipmentId == removeEquipmentViewModel.EquipmentId
select cd).FirstOrDefault();
if (equipment != null)
{
db.CartonDetails.Remove(equipment);
db.SaveChanges();
}
}
catch
{
throw new System.Exception();
}
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
/// <summary>
/// Implementation of item removal
/// Development item #1 and customer request #2 for current iteration
/// </summary>
/// <param name="removeEquipmentViewModel">When the EquipmentId is 0, the user is requesting to remove all items </param>
/// <returns></returns>
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
try
{
if (ModelState.IsValid)
{
//customer request #2: When the EquipmentId is 0, the user is requesting to remove all items
if (removeEquipmentViewModel.EquipmentId == 0)
{
//remove all items from carton
List <CartonDetail> items = db.CartonDetails
.Where(cd => cd.CartonId == removeEquipmentViewModel.CartonId).ToList();
db.CartonDetails.RemoveRange(items);
}
else
{
//Development item #1: using DBContext remove item user selected by getting it from the DBContext, which in turn sets entity state to delete
db.CartonDetails.Remove(db.CartonDetails.Single(cd => cd.CartonId == removeEquipmentViewModel.CartonId && cd.EquipmentId == removeEquipmentViewModel.EquipmentId));
}
db.SaveChanges();
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
catch (Exception ex)
{
log.Error(ex.Message);
throw ex;
}
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
if (ModelState.IsValid)
{
var carton = db.Cartons
.Include(x => x.CartonDetails)
.Where(x => x.Id == removeEquipmentViewModel.CartonId)
.FirstOrDefault();
if (carton == null || carton.CartonDetails == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var cartonDetail = carton.CartonDetails.FirstOrDefault(x => x.EquipmentId == removeEquipmentViewModel.EquipmentId);
if (cartonDetail == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
db.CartonDetails.Remove(cartonDetail);
db.SaveChanges();
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
public ActionResult RemoveALLEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
if (ModelState.IsValid)
{
var carton = db.Cartons
.Include(c => c.CartonDetails)
.Where(c => c.Id == removeEquipmentViewModel.CartonId)
.SingleOrDefault();
if (carton != null)
{
var cartondetails = carton.CartonDetails.Where(x => x.CartonId == carton.Id).ToList();
foreach (var cartondetail in cartondetails)
{
db.CartonDetails.Remove(cartondetail);
}
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
if (ModelState.IsValid)
{
// DM: I typically either inject or wrap my contexts directly in a using statement where I need them, so I'll do it here for an example.
// I realize the db variable is available and should be used and if the team prefered that method that's not a problem for me especially in a web site where the life of a call is well defined
cartonService.RemoveEquipmentOnCarton(removeEquipmentViewModel);
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//////return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
if (ModelState.IsValid)
{
//Remove code here
CartonDetail cartonDetail = db.CartonDetails.Where(cd => cd.CartonId == removeEquipmentViewModel.CartonId && cd.EquipmentId == removeEquipmentViewModel.EquipmentId).Single();
db.CartonDetails.Remove(cartonDetail);
db.SaveChanges();
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
if (ModelState.IsValid)
{
var result = this.RemoveEquiment(removeEquipmentViewModel.CartonId, removeEquipmentViewModel.EquipmentId);
if (!result)
{
return(HttpNotFound());
}
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
/// <summary>
/// This is to remove the Equipment from the Carton by the Carton Id and Equipment ID
/// </summary>
/// <param name="removeEquipmentViewModel"></param>
/// <returns></returns>
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
if (ModelState.IsValid)
{
CartonDetail cartonDetail = db.CartonDetails.SingleOrDefault(c => c.EquipmentId == removeEquipmentViewModel.EquipmentId);
if (cartonDetail != null)
{
db.CartonDetails.Remove(cartonDetail);
db.SaveChanges();
}
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
try
{
if (ModelState.IsValid)
{
//Remove code here
var EquipmentId = db.CartonDetails.Where(d => d.EquipmentId == removeEquipmentViewModel.EquipmentId).First();
db.CartonDetails.Remove(EquipmentId);
db.SaveChanges();
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "Carton", "Index")));
}
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
if (ModelState.IsValid)
{
var equipment = db.CartonDetails.
Where(e => e.CartonId == removeEquipmentViewModel.CartonId && e.EquipmentId == removeEquipmentViewModel.EquipmentId)
.SingleOrDefault();
if (equipment != null)
{
db.CartonDetails.Remove(equipment);
db.SaveChanges();
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Equipment is not found!!!"));
}
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
if (ModelState.IsValid)
{
var details = db.CartonDetails
.Where(cd => cd.CartonId == removeEquipmentViewModel.CartonId)
.Where(cd => cd.EquipmentId == removeEquipmentViewModel.EquipmentId)
.ToList();
foreach (var data in details)
{
db.CartonDetails.Remove(data);
}
db.SaveChanges();
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//AM: TODO REMAININGDEV 1 = Implement Remove function - DONE
if (ModelState.IsValid)
{
var carton = db.Cartons
.Include(x => x.CartonDetails)
.Where(x => x.Id == removeEquipmentViewModel.CartonId)
.FirstOrDefault();
if (carton == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (carton.CartonDetails == null || carton.CartonDetails.Count < 1)
{
//No Equipment added yet
return(RedirectToAction("Index"));
}
var cartonDetail = carton.CartonDetails.FirstOrDefault(e => e.EquipmentId == removeEquipmentViewModel.EquipmentId);
if (cartonDetail == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
db.CartonDetails.Remove(cartonDetail);
db.SaveChanges();
}
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId, valMSG = SuccessMsgcd1 }));
}
//Last remaining Item for the iteration to removeEquipment On Carton.
public ActionResult RemoveEquipmentOnCarton([Bind(Include = "CartonId,EquipmentId")] RemoveEquipmentViewModel removeEquipmentViewModel)
{
var carton = db.Cartons
.Include(c => c.CartonDetails)
.Where(c => c.Id == removeEquipmentViewModel.CartonId)
.SingleOrDefault();
if (carton == null)
{
return(HttpNotFound());
}
var equipment = db.Equipments
.Where(e => e.Id == removeEquipmentViewModel.EquipmentId)
.SingleOrDefault();
if (equipment == null)
{
return(HttpNotFound());
}
var cartondetailID = db.CartonDetails
.Where(cd => cd.EquipmentId == equipment.Id)
.SingleOrDefault();
var detail = new CartonDetail()
{
Carton = carton,
Equipment = equipment
};
CartonDetail cartondetail = db.CartonDetails.Find(cartondetailID.Id);
db.CartonDetails.Remove(cartondetail);
db.SaveChanges();
return(RedirectToAction("ViewCartonEquipment", new { id = removeEquipmentViewModel.CartonId }));
}
