private OralConsultationItem UpdateOralConsultation(OralConsultationItem item)
{
OralConsultation entity = new OralConsultation
{
OralConsultationID = item.OralConsultationID,
//ResidentID = (int)item.ResidentID,
IssueID = (int)item.IssueID,
OralConsultationDate = item.OralConsultationDate,
InvocationTypeID = item.InvocationTypeID,
TargetGroupID = item.TargetGroupID,
ProblemDescription = item.ProblemDescription,
ConsultationDescription = item.ConsultationDescription,
UserID = item.UserID,
ChangeDate = DateTime.Now
};
db.OralConsultations.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
this.UpdateConsultant(item, entity);
this.UpdateOrganization(item, entity);
this.UpdateRight(item, entity);
this.UpdatePermission(item, entity);
db.SaveChanges();
item.OralConsultationID = entity.OralConsultationID;
return(item);
}
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 OralConsultationItem InsertOralConsultation(OralConsultationItem item)
{
OralConsultation entity = new OralConsultation
{
OralConsultationID = item.OralConsultationID,
//ResidentID = (int)item.ResidentID,
IssueID = (int)item.IssueID,
OralConsultationDate = item.OralConsultationDate,
InvocationTypeID = item.InvocationTypeID,
TargetGroupID = item.TargetGroupID,
ProblemDescription = item.ProblemDescription,
ConsultationDescription = item.ConsultationDescription,
UserID = item.UserID,
ChangeDate = DateTime.Now,
OwnerID = item.UserID
};
db.OralConsultations.Add(entity);
this.InsertConsultant(item, entity);
this.InsertOrganization(item, entity);
this.InsertRight(item, entity);
this.InsertPermission(item, entity);
db.SaveChanges();
item.OralConsultationID = entity.OralConsultationID;
return(item);
}
private bool UpdatePermission(OralConsultationItem item, OralConsultation entity)
{
List <int> existingItems = new List <int>();
foreach (var itm in db.TmpOralConsultationPermissions.Where(p => p.GUID == item.GUID))
{
existingItems.Add(itm.OralConsultationPermissionID);
OralConsultationPermission dbItem = new OralConsultationPermission
{
OralConsultation = entity,
UserID = itm.UserID,
IsChange = itm.IsChange,
IsRead = itm.IsRead,
OralConsultationID = itm.OralConsultationID,
OralConsultationPermissionID = itm.OralConsultationPermissionID
};
if (itm.OralConsultationPermissionID == 0)
{
db.OralConsultationPermissions.Add(dbItem);
}
else
{
db.OralConsultationPermissions.Attach(dbItem);
db.Entry(dbItem).State = EntityState.Modified;
}
}
List <int> deletedItems = new List <int>();
foreach (var itm2 in db.OralConsultationPermissions.Where(p => p.OralConsultationID == item.OralConsultationID))
{
deletedItems.Add(itm2.OralConsultationPermissionID);
}
List <int> common = deletedItems.Except(existingItems).ToList();
foreach (int deletionID in common)
{
db.OralConsultationPermissions.Remove(db.OralConsultationPermissions.Find(deletionID));
}
List <int> deletionTempItems = new List <int>();
foreach (var itm3 in db.TmpOralConsultationPermissions.Where(p => p.GUID == item.GUID))
{
deletionTempItems.Add(itm3.ID);
}
foreach (int ID in deletionTempItems)
{
db.TmpOralConsultationPermissions.Remove(db.TmpOralConsultationPermissions.Find(ID));
}
return(true);
}