private void detach_BuffetProjectRequirements(BuffetProjectRequirement entity)
{
this.SendPropertyChanging();
entity.ProjectInformation = null;
}
partial void DeleteBuffetProjectRequirement(BuffetProjectRequirement instance);
partial void UpdateBuffetProjectRequirement(BuffetProjectRequirement instance);
partial void InsertBuffetProjectRequirement(BuffetProjectRequirement instance);
private void detach_BuffetProjectRequirements(BuffetProjectRequirement entity)
{
this.SendPropertyChanging();
entity.RequirementType = null;
}
public void createNewEntries(int req_type, List<string> singleInstanceReqs, List<string> singleInstanceProjs, List<string> multiInstanceReqs, List<string> multiInstanceProjs, CookDBDataContext db, int filter)
{
//loop through lists and move all single instances that are IN multi instances TO multi instances and delete from single.
//do this a few times to make sure no matches slip through the cracks...
for (int p = 0; p < 5; p++)
{
for (int i = 0; i < singleInstanceReqs.Count(); i++)
{
if (multiInstanceReqs.Contains(singleInstanceReqs[i]))
{
//if theres a match, concat a pipe and then the accompanying project id of the project that shares the req
multiInstanceProjs[multiInstanceReqs.IndexOf(singleInstanceReqs[i])] += "|" + singleInstanceProjs[i];
//remove this req from the singles
singleInstanceReqs.RemoveAt(i);
singleInstanceProjs.RemoveAt(i);
}
}
}
//create new entry for each of the single instances
for (int i = 0; i < singleInstanceReqs.Count(); i++)
{
BuffetProjectRequirement newEntry = new BuffetProjectRequirement();
newEntry.name = singleInstanceReqs[i];
newEntry.filename = singleInstanceReqs[i];
newEntry.project_id = filter;
newEntry.associated_projects = db.ProjectInformations.Single(z => z.project_id.Equals(singleInstanceProjs[i])).project_number;
newEntry.requirement_type_id = req_type;
if (newEntry.filename != "" && newEntry.filename != null)
{
db.BuffetProjectRequirements.InsertOnSubmit(newEntry);
db.SubmitChanges();
}
}
//create new entry for each of the multi instances
for (int i = 0; i < multiInstanceReqs.Count(); i++)
{
BuffetProjectRequirement newEntry = new BuffetProjectRequirement();
var brokenUpProjects = multiInstanceProjs[i].Split('|');
foreach (string a in brokenUpProjects)
{
newEntry.associated_projects += db.ProjectInformations.Single(z => z.project_id.Equals(int.Parse(a))).project_number + ",";
}
newEntry.associated_projects = newEntry.associated_projects.Substring(0, newEntry.associated_projects.LastIndexOf(','));
newEntry.project_id = filter;
newEntry.requirement_type_id = req_type;
newEntry.name = multiInstanceReqs[i];
newEntry.filename = multiInstanceReqs[i];
if (newEntry.filename != "" && newEntry.filename != null)
{
db.BuffetProjectRequirements.InsertOnSubmit(newEntry);
db.SubmitChanges();
}
}
}