public ActionResult Edit(int?id, FormCollection form)
{
Work_Package model = new Work_Package()
{
id = id ?? -1,
name = form["name"],
description = form["description"],
notes = form["notes"],
task_id = int.Parse(form["task_id"]),
status = short.Parse(form["status"])
};
try
{
if (id == null)
{
ps.InsertPackage(model);
return(RedirectToAction("Index"));
}
else
{
ps.UpdatePackage(model);
return(RedirectToAction("Details", new { id = model.id }));
}
}
catch //(Exception ex)
{
return(View(model));
}
}
public Work_Package UpdatePackage(Work_Package wp)
{
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
var package = (from d in finalDB.Work_Packages
where d.id == wp.id
select d).Single();
package.description = wp.description;
package.name = wp.name;
package.status = wp.status;
package.notes = wp.notes;
finalDB.SubmitChanges();
return(package);
}
public Work_Package InsertPackage(Work_Package wp)
{
wp.createddate = DateTime.Now;
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
var task = from w in finalDB.Work_Packages
where w.task_id == wp.task_id
select w.workorder;
int maxOrder = 0;
if (task != null && task.Count() > 0)
{
maxOrder = task.Max <int>();
}
wp.workorder = maxOrder + 5;
finalDB.Work_Packages.InsertOnSubmit(wp);
finalDB.SubmitChanges();
return(wp);
}
