public ActionResult ShowAppointment() { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); appointmentInfo appointments = new appointmentInfo(); appointments.doctor_Id = Convert.ToInt32(Session["LogedUserID"]); var appointment = appoinment_Entities_db.appointmentInfoes.Where(x => x.doctor_Id == appointments.doctor_Id && x.appointment_Status == false).ToList(); if (appointment.Count != 0) { return(View(appointment)); } else { return(View()); } }
public ActionResult CreateAppointment(int doctorId, string appointmentTime) { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); appointmentInfo appointment = new appointmentInfo(); appointment.patient_Id = Convert.ToInt32(Session["LogedUserID"]); var patientAppointment = appoinment_Entities_db.appointmentInfoes.Where( i => i.patient_Id == appointment.patient_Id && i.appointment_Status == true).ToList(); if (patientAppointment.Count == 0) { userLogin login = new userLogin(); //appointment.appointment_Id = 1; //appointment.appointment_Id = appoinment_Entities_db.appointmentInfoes.Select(c => c.appointment_Id).Count() + 1; appointment.doctor_Id = doctorId; var doctorName = appoinment_Entities_db.userLogins.Where( i => i.UserID == doctorId).Single().FullName; appointment.doctor_Name = doctorName; appointment.patient_Name = appoinment_Entities_db.userLogins.Where( i => i.UserID == appointment.patient_Id).Single().FullName; DateTime date = DateTime.Now; var shortDate = date.Date; appointment.appointment_Date = shortDate; appointment.appointment_Time = TimeSpan.Parse(appointmentTime); appointment.appointment_Status = false; appoinment_Entities_db.appointmentInfoes.Add(appointment); appoinment_Entities_db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Fail", JsonRequestBehavior.AllowGet)); } }
public ActionResult ShowAppointment(int?patientId, string status) { Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities(); appointmentInfo appointmentInfo = new appointmentInfo(); appointmentInfo.doctor_Id = Convert.ToInt32(Session["LogedUserID"]); appointmentInfo = appoinment_Entities_db.appointmentInfoes.Where(x => x.patient_Id == patientId && x.doctor_Id == appointmentInfo.doctor_Id).FirstOrDefault(); if (appointmentInfo != null) { if (status == "Confirm") { appointmentInfo.appointment_Status = true; } else { appointmentInfo.appointment_Status = false; } appoinment_Entities_db.appointmentInfoes.Add(appointmentInfo); appoinment_Entities_db.Entry(appointmentInfo).State = System.Data.Entity.EntityState.Modified; appoinment_Entities_db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } return(Json("Fail", JsonRequestBehavior.AllowGet)); }