public TypeConsultationInstanceItem InsertInstance(TypeConsultationInstanceItem item)
{
try
{
TmpTypeConsultationInstance entity = new TmpTypeConsultationInstance
{
TypeConsultationInstanceID = 0,
TypeConsultationID = item.TypeConsultationID,
OrganizationID = item.OrganizationID,
GUID = item.GUID
};
db.TmpTypeConsultationInstances.Add(entity);
db.SaveChanges();
item.ID = entity.ID;
item.TypeConsultationInstanceID = entity.TypeConsultationInstanceID;
Organization organization = db.Organizations.Find(item.OrganizationID);
item.OrganizationName = organization.OrganizationName;
return(item);
}
catch (Exception ex)
{
exception = ex;
return(null);
}
}
public TypeConsultationInstanceItem UpdateInstance(TypeConsultationInstanceItem item)
{
try
{
TmpTypeConsultationInstance entity = new TmpTypeConsultationInstance
{
ID = item.ID,
TypeConsultationInstanceID = item.TypeConsultationInstanceID,
TypeConsultationID = item.TypeConsultationID,
OrganizationID = item.OrganizationID,
GUID = item.GUID
};
db.TmpTypeConsultationInstances.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
Organization organization = db.Organizations.Find(item.OrganizationID);
item.OrganizationName = organization.OrganizationName;
return(item);
}
catch (Exception ex)
{
exception = ex;
return(null);
}
}
public TypeConsultationInstanceItem DeleteInstance(TypeConsultationInstanceItem item)
{
try
{
TmpTypeConsultationInstance entity = new TmpTypeConsultationInstance
{
ID = item.ID,
TypeConsultationInstanceID = item.TypeConsultationInstanceID,
TypeConsultationID = item.TypeConsultationID,
OrganizationID = item.OrganizationID,
GUID = item.GUID
};
db.TmpTypeConsultationInstances.Attach(entity);
db.TmpTypeConsultationInstances.Remove(entity);
db.SaveChanges();
return(item);
}
catch (Exception ex)
{
exception = ex;
return(null);
}
}