public JsonResult GetAllPatientAppointmentData(string Date)
{
BL_PatientAppointmentSchedule _PatientAppointment = new BL_PatientAppointmentSchedule();
PatientAppointmentSchedule PatientAppointment = new PatientAppointmentSchedule();
DataSet ds = _PatientAppointment.GetAllPatientAppointmentData(Date);
List <PatientAppointmentSchedule> PatientAppointmentscheduleList = new List <PatientAppointmentSchedule>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientAppointmentscheduleList.Add(new PatientAppointmentSchedule
{
PatientID = dr["PatientID"].ToString(),
PatientName = dr["PatientName"].ToString(),
DoctorName = dr["Doctor Name"].ToString(),
AppointmentDate = Convert.ToDateTime(dr["AppointmentDate"]).ToString("yyyy-MM-dd"),
FromTime = dr["FromTime"].ToString(),
ToTime = dr["ToTime"].ToString(),
//PatientAppointment.Age = dr["Age"].ToString();
//PatientAppointment.DateOFBirth = Convert.ToDateTime(dr["DateOfBirth"]).ToString("yyyy-MM-dd");
});
}
// PatientAppointmentscheduleList.Add(PatientAppointment);
return(new JsonResult {
Data = PatientAppointmentscheduleList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult BindPatientAppointmentID(string PatientID)
{
BL_PatientAppointmentSchedule _PatientAppointment = new BL_PatientAppointmentSchedule();
PatientAppointmentSchedule PatientAppointment = new PatientAppointmentSchedule();
DataSet ds = _PatientAppointment.GetPatientAppointmentsAppointID(HospitalID, LocationID, Convert.ToInt32(PatientID));
List <PatientAppointmentSchedule> PatientAppointmentscheduleList = new List <PatientAppointmentSchedule>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientAppointment.PatientID = dr["PatientID"].ToString();
PatientAppointment.PFPatientName = dr["PFPatientName"].ToString();
PatientAppointment.PFirstName = dr["PFirstName"].ToString();
PatientAppointment.PMiddleName = dr["PMiddleName"].ToString();
PatientAppointment.PLastName = dr["PLastName"].ToString();
PatientAppointment.MobileNo = dr["MobileNo"].ToString();
PatientAppointment.Age = dr["Age"].ToString();
PatientAppointment.DateOFBirth = Convert.ToDateTime(dr["DateOfBirth"]).ToString("yyyy-MM-dd");
}
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr1 in ds.Tables[1].Rows)
{
PatientAppointment.PatientAppointmentScheduleID = dr1["PatientAppointmentScheduleID"].ToString();
PatientAppointment.DoctorAppoinmentScheduleID = dr1["DoctorAppoinmentScheduleID"].ToString();
PatientAppointment.DoctorID = dr1["DoctorID"].ToString();
PatientAppointment.AppointmentDate = Convert.ToDateTime(dr1["AppointmentDate"]).ToString("yyyy-MM-dd");
PatientAppointment.AppointmentTime = dr1["FromTime"].ToString() + " To " + dr1["ToTime"].ToString();
PatientAppointment.AppointmentType = dr1["AppointmentType"].ToString();
PatientAppointment.DoctorPrintName = dr1["DoctorPrintName"].ToString();
PatientAppointment.NoOfAppointment = dr1["NoOfAppointment"].ToString();
}
}
PatientAppointmentscheduleList.Add(PatientAppointment);
return(new JsonResult {
Data = PatientAppointmentscheduleList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult PatientAppointmentSchedule(PatientAppointmentSchedule objPatientAppointmentSchedule, FormCollection fc)
{
// PatientAppointmentSchedule objPatientAppointmentSchedule=new Models.Patient.PatientAppointmentSchedule();
BL_PatientAppointmentSchedule _PatientAppointment = new BL_PatientAppointmentSchedule();
var delimiters = new char[] { 'T', 'o' };
var results = objPatientAppointmentSchedule.FromTime.Split(delimiters);
objPatientAppointmentSchedule.FinancialYearID = fc["FinancialYearID"];
objPatientAppointmentSchedule.PatientRegNo = fc["0"];
objPatientAppointmentSchedule.PatientID = fc["AppointmentNo"];
objPatientAppointmentSchedule.PatientAppointmentNO = fc["AppointmentNo"];
objPatientAppointmentSchedule.PatientName = fc["FirstName"];
objPatientAppointmentSchedule.PFirstName = fc["FirstName"];
objPatientAppointmentSchedule.PMiddleName = fc["PMiddleName"];
objPatientAppointmentSchedule.PLastName = fc["PLastName"];
objPatientAppointmentSchedule.PatientStatus = fc["False"];
objPatientAppointmentSchedule.Day = fc["Day"];
objPatientAppointmentSchedule.Month = fc["Month"];
objPatientAppointmentSchedule.Year = fc["Year"];
objPatientAppointmentSchedule.PFPatientName = fc["PFPatientName"];
objPatientAppointmentSchedule.DateOFBirth = fc["DateOFBirth"];
// objPatientAppointmentSchedule.Gender = Request.Form["Gender"];
if (Request.Form["Days"] != "")
{
objPatientAppointmentSchedule.Day = fc["Day"].ToString();
objPatientAppointmentSchedule.Age = objPatientAppointmentSchedule.Day.ToString();
objPatientAppointmentSchedule.AgeType = "Days";
}
if (Request.Form["Months"] != "")
{
objPatientAppointmentSchedule.Month = fc["Month"].ToString();
objPatientAppointmentSchedule.Age = objPatientAppointmentSchedule.Month;
objPatientAppointmentSchedule.AgeType = "Month";
}
if (Request.Form["Years"] != "")
{
objPatientAppointmentSchedule.Year = fc["Year"].ToString();
objPatientAppointmentSchedule.Age = objPatientAppointmentSchedule.Year;
objPatientAppointmentSchedule.AgeType = "Year";
}
objPatientAppointmentSchedule.AppointmentDate = fc["AppointDateID"];
// objPatientAppointmentSchedule.AppointmentType = Request.Form["AppointmentType"];
objPatientAppointmentSchedule.AppointmentType = fc["AppointType"];
objPatientAppointmentSchedule.DoctorPrintName = fc["ConsultantDoctorName"];
objPatientAppointmentSchedule.PatientAppointmentScheduleID = fc["PatientAppointmentScheduleID"];
if (objPatientAppointmentSchedule.DoctorAppoinmentScheduleID == "")
{
objPatientAppointmentSchedule.DoctorAppoinmentScheduleID = fc["DoctorAppoinmentScheduleID"];
}
else
{
objPatientAppointmentSchedule.DoctorAppoinmentScheduleID = fc["DoctorAppoinmentScheduleID"];
}
objPatientAppointmentSchedule.FromTime = results[0];
objPatientAppointmentSchedule.ToTime = results[2];
objPatientAppointmentSchedule.MobileNo = fc["MobileNo"].ToString();
objPatientAppointmentSchedule.AppointmentNoID = fc["AppointmentNoID"];
#region DoctorSchedule
BindFromToTime(objPatientAppointmentSchedule.AppointmentType, objPatientAppointmentSchedule.DoctorID, fc["AppointDateID"].ToString());
BindNoOfAppointment(fc["AppointmentTime"], objPatientAppointmentSchedule.DoctorID);
#endregion
//dsDoctorSchedule = _PatientAppointment.GetPatientAppointmentDetails(HospitalID, LocationID, Convert.ToInt32(objPatientAppointmentSchedule.PatientID));
if (_PatientAppointment.Save(objPatientAppointmentSchedule, dsDoctorSchedule))
{
ModelState.Clear();
ViewData["flag"] = "Done";
TempData["msg"] = "Appointment Save Sucessfully";
}
else
{
ViewData["flag"] = "Error";
}
return(RedirectToAction("PatientAppointmentSchedule", "PatientAppointmentSchedule"));
}
