private bool InsertRight(OralConsultationItem item, OralConsultation entity) { foreach (var itm in db.TmpOralConsultationRights.Where(p => p.GUID == item.GUID)) { OralConsultationRight dbItem = new OralConsultationRight { OralConsultation = entity, HumanRightID = itm.HumanRightID, OralConsultationID = itm.OralConsultationID, OralConsultationRightID = itm.OralConsultationRightID }; db.OralConsultationRights.Add(dbItem); } List <int> deletionTempItems = new List <int>(); foreach (var itm3 in db.TmpOralConsultationRights.Where(p => p.GUID == item.GUID)) { deletionTempItems.Add(itm3.ID); } foreach (int ID in deletionTempItems) { db.TmpOralConsultationRights.Remove(db.TmpOralConsultationRights.Find(ID)); } return(true); }
private bool UpdateRight(OralConsultationItem item, OralConsultation entity) { List <int> existingItems = new List <int>(); foreach (var itm in db.TmpOralConsultationRights.Where(p => p.GUID == item.GUID)) { existingItems.Add(itm.OralConsultationRightID); OralConsultationRight dbItem = new OralConsultationRight { OralConsultation = entity, HumanRightID = itm.HumanRightID, OralConsultationID = itm.OralConsultationID, OralConsultationRightID = itm.OralConsultationRightID }; if (itm.OralConsultationRightID == 0) { db.OralConsultationRights.Add(dbItem); } else { db.OralConsultationRights.Attach(dbItem); db.Entry(dbItem).State = EntityState.Modified; } } List <int> deletedItems = new List <int>(); foreach (var itm2 in db.OralConsultationRights.Where(p => p.OralConsultationID == item.OralConsultationID)) { deletedItems.Add(itm2.OralConsultationRightID); } List <int> common = deletedItems.Except(existingItems).ToList(); foreach (int deletionID in common) { db.OralConsultationRights.Remove(db.OralConsultationRights.Find(deletionID)); } List <int> deletionTempItems = new List <int>(); foreach (var itm3 in db.TmpOralConsultationRights.Where(p => p.GUID == item.GUID)) { deletionTempItems.Add(itm3.ID); } foreach (int ID in deletionTempItems) { db.TmpOralConsultationRights.Remove(db.TmpOralConsultationRights.Find(ID)); } return(true); }