public ActionResult Delete(DoctorAndNetUsers model)
{
ViewBag.Message = "Appointment Cancelled !";
AllAppointment deleteAppointment = myEntities.AllAppointments.FirstOrDefault(a => a.AptId == model.AllAppointment.AptId);
myEntities.AllAppointments.Remove(deleteAppointment);
myEntities.SaveChanges();
return(View("ConfirmAppointment"));
}
public ActionResult Schedule(int id)
{
ViewBag.Slots = new SelectList(myEntities.doctorSlots.Where(d => d.doctorId == id), "slotTimes", "slotTimes");
var doctor = myEntities.Doctors.Where(d => d.DocId == id).FirstOrDefault();
DoctorAndNetUsers doctorAndNetUser = new DoctorAndNetUsers();
doctorAndNetUser.Doctor = doctor;
doctorAndNetUser.AllAppointment = new AllAppointment();
doctorAndNetUser.AllAppointment.SlotDate = Convert.ToDateTime(DateTime.Now);
doctorAndNetUser.AllAppointment.Slots = "";
return(View(doctorAndNetUser));
}
public ActionResult Delete(int id)
{
var appointment = myEntities.AllAppointments.SingleOrDefault(a => a.AptId == id);
int dId = int.Parse(Request.QueryString["dId"]);
ViewBag.Slots = new SelectList(myEntities.doctorSlots.Where(d => d.doctorId == dId), "slotTimes", "slotTimes");
var doctor = myEntities.Doctors.SingleOrDefault(d => d.DocId == dId);
var doctorAndAppointment = new DoctorAndNetUsers
{
AllAppointment = appointment,
Doctor = doctor
};
return(View(doctorAndAppointment));
}
public ActionResult ConfirmAppointment(DoctorAndNetUsers model)
{
string UserName = User.Identity.Name;
int DoctorId = model.Doctor.DocId;
DateTime AptDate = Convert.ToDateTime(model.AllAppointment.SlotDate);
string AptTime = model.AllAppointment.Slots;
var existsOrNot = myEntities.AllAppointments.Where(c => c.DoctorId == DoctorId && c.SlotDate == AptDate && c.Slots == AptTime);
var count = existsOrNot.Count();
if (count == 0)
{
if (AptTime == null)
{
ViewBag.Slots = new SelectList(myEntities.doctorSlots.Where(d => d.doctorId == DoctorId), "slotTimes", "slotTimes");
var doctor = myEntities.Doctors.Where(d => d.DocId == DoctorId).FirstOrDefault();
DoctorAndNetUsers doctorAndNetUser = new DoctorAndNetUsers();
doctorAndNetUser.Doctor = doctor;
doctorAndNetUser.AllAppointment = new AllAppointment();
doctorAndNetUser.AllAppointment.SlotDate = Convert.ToDateTime(DateTime.Now);
doctorAndNetUser.AllAppointment.Slots = "";
return(View("Schedule", doctorAndNetUser));
}
else
{
AllAppointment appointment = new AllAppointment();
appointment.UserName = UserName;
appointment.DoctorId = DoctorId;
appointment.SlotDate = AptDate;
appointment.Slots = AptTime;
appointment.DrAvailability = "yes";
myEntities.AllAppointments.Add(appointment);
myEntities.SaveChanges();
ViewBag.Message = "Appointment Confirmed !";
return(View());
}
}
else
{
ViewBag.Message = "Slots not Available Now !";
return(View());
}
}
public ActionResult Edit(int id)
{
try
{
var appointment = myEntities.AllAppointments.SingleOrDefault(a => a.AptId == id);
int dId = int.Parse(Request.QueryString["dId"]);
ViewBag.Slots = new SelectList(myEntities.doctorSlots.Where(d => d.doctorId == dId), "slotTimes", "slotTimes");
var doctor = myEntities.Doctors.SingleOrDefault(d => d.DocId == dId);
var doctorAndAppointment = new DoctorAndNetUsers
{
AllAppointment = appointment,
Doctor = doctor
};
return(View(doctorAndAppointment));
}
catch (Exception)
{
throw new Exception("Problem with updation.");;
}
}
public ActionResult Edit(DoctorAndNetUsers model)
{
string UserName = User.Identity.Name;
int DoctorId = model.Doctor.DocId;
DateTime AptDate = Convert.ToDateTime(model.AllAppointment.SlotDate);
string AptTime = model.AllAppointment.Slots;
var existsOrNot = myEntities.AllAppointments.Where(c => c.DoctorId == DoctorId && c.SlotDate == AptDate && c.Slots == AptTime);
var count = existsOrNot.Count();
if (count == 0)
{
AllAppointment appointment = myEntities.AllAppointments.FirstOrDefault(a => a.AptId == model.AllAppointment.AptId);
appointment.SlotDate = AptDate;
appointment.Slots = AptTime;
myEntities.SaveChanges();
ViewBag.Message = "Appointment Confirmed !";
}
else
{
ViewBag.Message = "Slots not Available Now !";
}
return(View("ConfirmAppointment"));
}
