public static PartGroup AddGroupPart(int groupID, int partID)
{
CurtDevDataContext db = new CurtDevDataContext();
try {
PartGroupPart pgp = db.PartGroupParts.Where(x => x.partGroupID.Equals(groupID) && x.partID.Equals(partID)).First();
} catch {
int sort = 1;
try {
sort = db.PartGroupParts.Where(x => x.partGroupID.Equals(groupID)).OrderByDescending(x => x.sort).Select(x => x.sort).First() + 1;
} catch {}
PartGroupPart pgp = new PartGroupPart {
partID = partID,
partGroupID = groupID,
sort = sort
};
db.PartGroupParts.InsertOnSubmit(pgp);
db.SubmitChanges();
List<string> partgroupparts = db.PartGroupParts.Where(x => x.partGroupID.Equals(groupID)).OrderBy(x => x.sort).Select(x => x.id.ToString()).ToList();
UpdateGroupSort(partgroupparts);
}
return GetGroup(groupID);
}
public static PartGroup SaveGroup(int partID, string name, int groupID = 0)
{
CurtDevDataContext db = new CurtDevDataContext();
PartGroup pg = new PartGroup();
if (groupID == 0) {
pg = new PartGroup {
name = name
};
db.PartGroups.InsertOnSubmit(pg);
db.SubmitChanges();
PartGroupPart pgp = new PartGroupPart {
partGroupID = pg.id,
partID = partID,
sort = 1
};
db.PartGroupParts.InsertOnSubmit(pgp);
} else {
pg = db.PartGroups.Where(x => x.id.Equals(groupID)).First();
pg.name = name;
}
db.SubmitChanges();
UpdatePart(partID);
return GetGroup(pg.id);
}
