public void AddTreatToDatabase(Patient curPatient, string illness, DateTime beginningDate)
        {
            try
            {

                var q = c.Patients.Where(p => p.Id == curPatient.Id).Include("MedSheet").First().MedSheet;
                q.TreatRegiments.Add(new TreatRegiment { Illness = illness, BeginningDate = beginningDate });
                c.Patients.Where(p => p.Id == curPatient.Id).Include("MedSheet").First().MedSheet.TreatRegiments.Add(new TreatRegiment { Illness = illness, BeginningDate = beginningDate });
            }
            catch
            {

            }
        }
 public void AddNewRecordToDatabase(Employee doctor, Patient patient, DateTime date)
 {
     using (c)
     {
         c.VisitRecords.AddOrUpdate(d => d.Date, new VisitRecord
         {
             Date = date,
             Doctor = doctor,
             Patient = patient
         });
         c.SaveChanges();
     }
 }