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