public void UpdateProcedure(int procedureId, Procedure procedure)
 {
     using (var dataContext = new eHealthCareEntities())
     {
         try
         {
             var procedureToUpdate = GetProcedureById(procedure.PatientId, procedureId);
             if (procedureToUpdate != null)
             {
                 procedureToUpdate.Date = procedure.Date;
                 procedureToUpdate.Notes = procedure.Notes;
                 procedureToUpdate.PrimaryProviderId = procedure.PrimaryProviderId;
                 procedureToUpdate.ProcedureName = procedure.ProcedureName;
                 procedureToUpdate.SecondaryProviderId = procedure.SecondaryProviderId;
                 dataContext.Procedures.Attach(procedureToUpdate);
                 dataContext.Entry(procedureToUpdate).State = EntityState.Modified;
                 dataContext.SaveChanges();
             }
         }
         catch (DbEntityValidationException ex)
         {
             throw new Exception(ex.EntityValidationErrors.GetValidationErrors());
         }
         catch
         {
             throw;
         }
     }
 }
 public void SaveProcedure(Procedure procedure)
 {
     using (var dataContext = new eHealthCareEntities())
     {
         try
         {
             dataContext.Procedures.Add(procedure);
             dataContext.SaveChanges();
         }
         catch (DbEntityValidationException ex)
         {
             throw new Exception(ex.EntityValidationErrors.GetValidationErrors());
         }
         catch
         {
             throw;
         }
     }
 }