public OralConsultationConsultantItem UpdateConsultant(OralConsultationConsultantItem item)
{
try
{
TmpOralConsultationConsultant entity = new TmpOralConsultationConsultant
{
ID = item.ID,
OralConsultationConsultantID = item.OralConsultationConsultantID,
OralConsultationID = item.OralConsultationID,
ConsultantID = item.ConsultantID,
GUID = item.GUID
};
db.TmpOralConsultationConsultants.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
Consultant consultant = db.Consultants.Find(item.ConsultantID);
item.ConsultantName = consultant.FirstName + " " + consultant.LastName;
return(item);
}
catch (Exception ex)
{
exception = ex;
return(null);
}
}
public OralConsultationConsultantItem InsertConsultant(OralConsultationConsultantItem item)
{
try
{
TmpOralConsultationConsultant entity = new TmpOralConsultationConsultant
{
OralConsultationConsultantID = 0,
OralConsultationID = item.OralConsultationID,
ConsultantID = item.ConsultantID,
GUID = item.GUID
};
db.TmpOralConsultationConsultants.Add(entity);
db.SaveChanges();
item.ID = entity.ID;
item.OralConsultationConsultantID = entity.OralConsultationConsultantID;
Consultant consultant = db.Consultants.Find(item.ConsultantID);
item.ConsultantName = consultant.FirstName + " " + consultant.LastName;
return(item);
}
catch (Exception ex)
{
exception = ex;
return(null);
}
}
public void DeleteConsultant(ConsultantItem consultantItem)
{
var entity = new Consultant
{
ConsultantID = consultantItem.ConsultantID
};
db.Consultants.Attach(entity);
db.Consultants.Remove(entity);
db.SaveChanges();
}
public void CreateConsultant(ConsultantItem consultantItem)
{
var entity = new Consultant
{
FirstName = consultantItem.FirstName,
LastName = consultantItem.LastName,
Id = consultantItem.Id
};
db.Consultants.Add(entity);
db.SaveChanges();
consultantItem.ConsultantID = entity.ConsultantID;
}
public void UpdateConsultant(ConsultantItem consultantItem)
{
var entity = new Consultant
{
ConsultantID = consultantItem.ConsultantID,
FirstName = consultantItem.FirstName,
LastName = consultantItem.LastName,
Id = consultantItem.Id
};
db.Consultants.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
}
