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 InsertRequirement(Software_Requirement sr)
{
sr.createddate = DateTime.Now;
IPFinalDBDataContext finalDB = new IPFinalDBDataContext();
finalDB.Software_Requirements.InsertOnSubmit(sr);
finalDB.SubmitChanges();
return(sr);
}
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 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 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);
}
