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(); }