public PackageRequirementsModel GetPackageRequirementsInfo(int id) { PackageRequirementsModel prm = new PackageRequirementsModel(); IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var req1 = from sr in finalDB.Software_Requirements join ps in finalDB.Package_Softwares on sr.id equals ps.sr_id where ps.wp_id == id select new Software_Requirement { id = sr.id, title = sr.title }; if (req1 != null) prm.Selected = req1.ToList(); var req2 = from sr in finalDB.Software_Requirements join ps in finalDB.Package_Softwares on sr.id equals ps.sr_id where ps.wp_id == id select new Software_Requirement { id = sr.id, title = sr.title }; //Not Completed... return null; }
//revise this class to be singleton public IEnumerable<Software_Requirement> GetRequirements() { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var list = (from sr in finalDB.Software_Requirements select sr).ToList(); return list; }
//revise this class to be singleton public IEnumerable<Work_Package> GetPackages() { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var list = (from wp in finalDB.Work_Packages select wp).ToList(); return list; }
public ActionResult Details(int id) { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); DataLoadOptions ds = new DataLoadOptions(); ds.LoadWith<Work_Package>(wp => wp.Package_Softwares); ds.LoadWith<Package_Software>(ps => ps.Software_Requirement); finalDB.LoadOptions = ds; var pack = (from p in finalDB.Work_Packages where p.id == id select p).Single(); //var data = from sr in finalDB.Software_Requirements // join ps in finalDB.Package_Softwares // on sr.id equals ps.sr_id // where ps.wp_id == id // select sr; //foreach (var ps in data) //{ // pack.Package_Softwares.Add(new Package_Software() // { // Software_Requirement = ps, // Work_Package = pack // }); //} return View(pack); }
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 Software_Requirement InsertRequirement(Software_Requirement sr) { sr.createddate = DateTime.Now; IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); finalDB.Software_Requirements.InsertOnSubmit(sr); finalDB.SubmitChanges(); return sr; }
public Software_Requirement DeleteRequirement(int id) { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var requirement = (from sr in finalDB.Software_Requirements where sr.id == id select sr).Single(); finalDB.Software_Requirements.DeleteOnSubmit(requirement); finalDB.SubmitChanges(); return null; }
public Work_Package DeletePackage(int id) { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var requirement = (from wp in finalDB.Work_Packages where wp.id == id select wp).FirstOrDefault(); finalDB.Work_Packages.DeleteOnSubmit(requirement); finalDB.SubmitChanges(); return null; }
public Software_Requirement UpdateRequirement(Software_Requirement sr) { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var requirement = (from d in finalDB.Software_Requirements where d.id == sr.id select d).Single(); requirement.description = sr.description; requirement.platform = sr.platform; requirement.title = sr.title; finalDB.SubmitChanges(); return requirement; }
public Work_Package GetPackageByID(int id) { if (id <= 0) return new Work_Package() { createddate = DateTime.Now, id = -1 }; try { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); var requirement = (from wp in finalDB.Work_Packages where wp.id == id select wp).SingleOrDefault(); return requirement; } catch { return null; } }
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 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 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 IList<SelectedPakcagesResult> SelectedPackages(int id) { IPFinalDBDataContext finalDB = new IPFinalDBDataContext(); return finalDB.SelectedPakcages(id).ToList<SelectedPakcagesResult>(); }
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); }