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