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>()); }