private bool InsertConsultant(OralConsultationItem item, OralConsultation entity)
{
foreach (var itm in db.TmpOralConsultationConsultants.Where(p => p.GUID == item.GUID))
{
OralConsultationConsultant dbItem = new OralConsultationConsultant
{
OralConsultation = entity,
ConsultantID = itm.ConsultantID,
OralConsultationID = itm.OralConsultationID,
OralConsultationConsultantID = itm.OralConsultationConsultantID
};
db.OralConsultationConsultants.Add(dbItem);
}
List <int> deletionTempItems = new List <int>();
foreach (var itm3 in db.TmpOralConsultationConsultants.Where(p => p.GUID == item.GUID))
{
deletionTempItems.Add(itm3.ID);
}
foreach (int ID in deletionTempItems)
{
db.TmpOralConsultationConsultants.Remove(db.TmpOralConsultationConsultants.Find(ID));
}
return(true);
}
private bool UpdateConsultant(OralConsultationItem item, OralConsultation entity)
{
List <int> existingItems = new List <int>();
foreach (var itm in db.TmpOralConsultationConsultants.Where(p => p.GUID == item.GUID))
{
existingItems.Add(itm.OralConsultationConsultantID);
OralConsultationConsultant dbItem = new OralConsultationConsultant
{
OralConsultation = entity,
ConsultantID = itm.ConsultantID,
OralConsultationID = itm.OralConsultationID,
OralConsultationConsultantID = itm.OralConsultationConsultantID
};
if (itm.OralConsultationConsultantID == 0)
{
db.OralConsultationConsultants.Add(dbItem);
}
else
{
db.OralConsultationConsultants.Attach(dbItem);
db.Entry(dbItem).State = EntityState.Modified;
}
}
List <int> deletedItems = new List <int>();
foreach (var itm2 in db.OralConsultationConsultants.Where(p => p.OralConsultationID == item.OralConsultationID))
{
deletedItems.Add(itm2.OralConsultationConsultantID);
}
List <int> common = deletedItems.Except(existingItems).ToList();
foreach (int deletionID in common)
{
db.OralConsultationConsultants.Remove(db.OralConsultationConsultants.Find(deletionID));
}
List <int> deletionTempItems = new List <int>();
foreach (var itm3 in db.TmpOralConsultationConsultants.Where(p => p.GUID == item.GUID))
{
deletionTempItems.Add(itm3.ID);
}
foreach (int ID in deletionTempItems)
{
db.TmpOralConsultationConsultants.Remove(db.TmpOralConsultationConsultants.Find(ID));
}
return(true);
}