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