public JsonResult AjaxBookAppointment(int PatId, int AppId, string AppDate, int Stat, string Boby, string BoDate)
{
DateTime AppointDate = Convert.ToDateTime(AppDate);
DateTime BookDate = Convert.ToDateTime(BoDate);
if (ModelState.IsValid)
{
PATIENTS_APPOINTMENTS PA = new PATIENTS_APPOINTMENTS()
{
PatientId = PatId,
AppointmentId = AppId,
AppointmentDate = AppointDate,
Status = Stat,
BookedBy = Boby,
BookingDate = BookDate
};
try
{
db.PATIENTS_APPOINTMENTS.Add(PA);
db.SaveChanges();
return(Json("تم حجز الموعد.", JsonRequestBehavior.AllowGet));
}
catch { return(Json("فشل التسجيل !!", JsonRequestBehavior.AllowGet)); }
}
else
{
return(Json("فشل التسجيل !!", JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConfirmed(int Id)
{
PATIENTS_APPOINTMENTS personalDetail = db.PATIENTS_APPOINTMENTS.Find(Id);
db.PATIENTS_APPOINTMENTS.Remove(personalDetail);
db.SaveChanges();
return(RedirectToAction("Index", "Home", "Index"));
}
public IHttpActionResult BookAppointment(PATIENTS_APPOINTMENTS pat)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
db.PATIENTS_APPOINTMENTS.Add(pat);
db.SaveChanges();
return(Ok());
}
public ActionResult DeleteAppointment(int?AppId)
{
if (AppId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PATIENTS_APPOINTMENTS personalDetail = db.PATIENTS_APPOINTMENTS.Find(AppId);
if (personalDetail == null)
{
return(HttpNotFound());
}
return(View(personalDetail));
}
public static string AppointmentStatus(int PatAppId)
{
// int stat = (int)db.PATIENTS_APPOINTMENTS.Find(PatAppId).Status;
int AppId = (int)db.PATIENTS_APPOINTMENTS.Find(PatAppId).AppointmentId;
DateTime AppDate = (DateTime)db.PATIENTS_APPOINTMENTS.Find(PatAppId).AppointmentDate;
TimeSpan AppTime = (TimeSpan)db.DOCTORS_APPOINTMENT_DETAILS.Find(AppId).Starting;
DateTime AppDateTime = NewDateTime(AppDate, AppTime);
if (AppDateTime < DateTime.Now)
{
PATIENTS_APPOINTMENTS PatApp = new PATIENTS_APPOINTMENTS();
PatApp = db.PATIENTS_APPOINTMENTS.Find(PatAppId);
PatApp.Status = 2;
db.Entry(PatApp).State = EntityState.Modified;;
db.SaveChanges();
}
return(db.PATIENTS_APPOINTMENTS.Find(PatAppId).APPOINTMENT_STATE.State_ar);
}
public ActionResult BookAppointment(PATIENTS_APPOINTMENTS PA)
{
if (ModelState.IsValid)
{
string CurrentURL = System.Web.HttpContext.Current.Request.QueryString.ToString();
if (Session["PatientName"] != null)
{
db.PATIENTS_APPOINTMENTS.Add(PA);
db.SaveChanges();
return(RedirectToAction("PatientDashboard", "Account"));
}
else
{
return(RedirectToAction("PatientLogin", "Account", new { returnUrl = CurrentURL }));
}
}
else
{
return(Redirect("Index"));
}
}
