public string update(string Apppoinment_id, string patient_name, string a, string b, string c, string doc_id) { try { HospitalManagementEntity context = new HospitalManagementEntity(); Patient_Appoinment u = context.Patient_Appoinment.Find(Convert.ToInt32(Apppoinment_id)); u.Patient_name = patient_name; u.Appoinment_date = Convert.ToDateTime(a); int id = Convert.ToInt32(doc_id); User s = context.Users.Find(id); if (s == null) { return("Invalide Doctor Id "); } u.Doctor_id = Convert.ToInt32(doc_id); u.Address = b; u.Mobile_no = c; context.Entry(u).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return("Updation Successfull"); } catch (Exception e) { return("Can't Update Id's"); } }
public string insert() { try { HospitalManagementEntity context = new HospitalManagementEntity(); Patient_Appoinment appo = new Patient_Appoinment(); appo.Address = address; appo.Appoinment_date = date2; if (doc_id == "") { return("Doctor id must be Required"); } int id = Convert.ToInt32(doc_id); User s = context.Users.Find(id); if (s == null) { return("Doctor Id Invalide"); } appo.Doctor_id = Convert.ToInt32(doc_id); appo.Start_date = date1; appo.Mobile_no = mobile; appo.Patient_name = name; context.Patient_Appoinment.Add(appo); context.SaveChanges(); return("Appointment Recorded"); } catch (Exception e) { return("Doctor Id Must Be Integer"); } }