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 Software_Requirement GetRequirementByID(int id)
{
if (id <= 0)
{
return new Software_Requirement()
{
createddate = DateTime.Now
}
}
;
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
var requirement = (from sr in finalDB.Software_Requirements
where sr.id == id
select sr).Single();
return(requirement);
}
public ActionResult Index()
{
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
var data = from p in finalDB.Package_Softwares
group p by p.wp_id into psg
select psg;
var packs = (from p in finalDB.Work_Packages
select p).ToList();
foreach (var pack in packs)
{
pack.RequirementCount = data.Count(p => p.Key == pack.id);
}
return(View(packs));
}
public bool UpdateRequirements(int id, List <Package_Software> reqs)
{
// try
//{
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
finalDB.DeletePackageSoftware(id);
foreach (Package_Software item in reqs)
{
finalDB.Package_Softwares.InsertOnSubmit(item);
}
finalDB.SubmitChanges();
return(true);
//}
//catch { return false; }
}
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);
}
public IList <SelectedPakcagesResult> SelectedPackages(int id)
{
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
return(finalDB.SelectedPakcages(id).ToList <SelectedPakcagesResult>());
}
