public JsonResult EditGetPatientAppointmentDetails(int PatientAppointmentScheduleID)
{
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
ModelState.Clear();
return(new JsonResult {
Data = _PatientAppointment.GetPatientAppointmentDetails(PatientAppointmentScheduleID), JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
// return View(db.GetDepartment(id));
}
public JsonResult GetDoctorRescheduleAppointment(int DoctorID, DateTime AppointmentDate, string AppointmentType)
{
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
ModelState.Clear();
return(new JsonResult {
Data = _PatientAppointment.GetDoctorRescheduleAppointment(DoctorID, AppointmentDate, AppointmentType), JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
// return View(db.GetDepartment(id));
}
public ActionResult PatientAppointmentCalenderWise()
{
PatientAppointmentCalenderWise PatientAppointment = new PatientAppointmentCalenderWise();
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
PatientAppointment.PatientID = _PatientAppointment.GetNextOutsidePatientID();
return(View(PatientAppointment));
}
public JsonResult BindPatientAppointmentID(string PatientID)
{
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
PatientAppointmentCalenderWise PatientAppointment = new PatientAppointmentCalenderWise();
DataSet ds = _PatientAppointment.GetPatientAppointmentsAppointID(HospitalID, LocationID, Convert.ToInt32(PatientID));
List <PatientAppointmentCalenderWise> PatientAppointmentscheduleList = new List <PatientAppointmentCalenderWise>();
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 JsonResult Delete(int PatientAppointmentScheduleID)
{
string del = null;
PatientAppointmentScheduleID = Convert.ToInt32(Request.Form["PatientAppointmentScheduleID"]);
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
try
{
string DependaincyName = _PatientAppointment.DeletePatientAppointmentDetail(Convert.ToInt32(PatientAppointmentScheduleID));
del = "PatientAppointment Deleted Successfully";
}
catch (Exception)
{
throw;
}
return(new JsonResult {
Data = del, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});;
}
public ActionResult PatientAppointmentCalenderWise(PatientAppointmentCalenderWise obj, FormCollection fc)
{
// PatientAppointmentSchedule objPatientAppointmentSchedule=new Models.Patient.PatientAppointmentSchedule();
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
var delimiters = new char[] { 'T', 'o' };
//obj.FromTime = fc["AppointmentTime"];
//var time = obj.FromTime;
var results = obj.FromTime.Split(delimiters);
obj.FinancialYearID = fc["FinancialYearID"];
obj.PatientRegNo = fc["0"];
obj.PatientID = fc["PatientID"];
obj.PatientName = fc["FirstName"];
obj.PFirstName = fc["FirstName"];
obj.PMiddleName = fc["PMiddleName"];
obj.PLastName = fc["PLastName"];
obj.PatientStatus = fc["False"];
obj.Day = fc["Day"];
obj.Month = fc["Month"];
obj.Year = fc["Year"];
obj.PFPatientName = fc["PFPatientName"];
obj.DateOFBirth = fc["DateOFBirth"];
// objPatientAppointmentSchedule.Gender = Request.Form["Gender"];
if (Request.Form["Days"] != "")
{
obj.Day = fc["Day"].ToString();
obj.Age = obj.Day.ToString();
obj.AgeType = "Days";
}
if (Request.Form["Months"] != "")
{
obj.Month = fc["Month"].ToString();
obj.Age = obj.Month;
obj.AgeType = "Month";
}
if (Request.Form["Years"] != "")
{
obj.Year = fc["Year"].ToString();
obj.Age = obj.Year;
obj.AgeType = "Year";
}
obj.AppointmentDate = fc["appointmentTime"];
var date = obj.AppointmentDate.Split(',');
var date1 = Convert.ToDateTime(date[0]).ToString("dd-MM-yyyy");
// objPatientAppointmentSchedule.AppointmentType = Request.Form["AppointmentType"];
obj.AppointmentType = fc["AppointType"];
obj.DoctorPrintName = fc["ConsultantDoctorName"];
obj.PatientAppointmentScheduleID = fc["PatientID"];
if (obj.DoctorAppoinmentScheduleID == "")
{
obj.DoctorAppoinmentScheduleID = fc["DoctorAppoinmentScheduleID"];
}
else
{
obj.DoctorAppoinmentScheduleID = fc["DoctorAppoinmentScheduleID"];
}
obj.FromTime = results[0];
obj.ToTime = results[2];
obj.MobileNo = fc["MobileNo"].ToString();
#region DoctorSchedule
BindFromToTime(obj.AppointmentType, obj.DoctorID, date1);
BindNoOfAppointment(fc["AppointType"], obj.DoctorID);
#endregion
if (_PatientAppointment.Save(obj, dsDoctorSchedule))
{
ModelState.Clear();
ViewData["flag"] = "Done";
TempData["msg"] = "Appointment Save Sucessfully";
}
else
{
ViewData["flag"] = "Error";
}
return(RedirectToAction("PatientAppointmentCalenderWise", "PatientAppointmentCalenderWise"));
// return RedirectToAction("PatientAppointmentSchedule", "PatientAppointmentSchedule");
}
public ActionResult BindFromToTime1(string AppointmentType, string DoctorID, string AppointmentDate)
{
string Mode = "";
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
PatientAppointment.PatientAppointmentNO = AppointmentType;
PatientAppointment.DoctorID = DoctorID;
DataSet dsDoctorTimedetail = new DataSet();
if (PatientAppointment.PatientAppointmentNO == "Weekly")
{
dsDoctorTimedetail = _PatientAppointment.GetPatientAppointmentDetailForDoctorDetail(HospitalID, LocationID, Convert.ToInt32(PatientAppointment.DoctorID), PatientAppointment.PatientAppointmentNO, Convert.ToString(Convert.ToDateTime(AppointmentDate).DayOfWeek.ToString()), Convert.ToDateTime(AppointmentDate));
}
else
if (PatientAppointment.PatientAppointmentNO == "Monthly")
{
dsDoctorTimedetail = _PatientAppointment.GetPatientAppointmentDetailForDoctorDetail(HospitalID, LocationID, Convert.ToInt32(PatientAppointment.DoctorID), PatientAppointment.PatientAppointmentNO, Convert.ToString(Convert.ToDateTime(AppointmentDate).Day), Convert.ToDateTime(AppointmentDate));
}
else
{
dsDoctorTimedetail = _PatientAppointment.GetPatientAppointmentDetailForDoctorDetail(HospitalID, LocationID, Convert.ToInt32(PatientAppointment.DoctorID), PatientAppointment.PatientAppointmentNO, "Daily", Convert.ToDateTime(AppointmentDate));
}
GetEmptyDatasetPatientSchedule();
//foreach (DataRow drMainDetail in dsDoctorTimedetail.Tables[0].Rows)
//{
string FromTime;
string ToTime;
// // DateTime Endtime;
// FromTime = Convert.ToDateTime(drMainDetail["FromTime"]).ToString("hh:mm:ss");
// Totime = Convert.ToDateTime(drMainDetail["ToTime"]).ToString("hh:mm:ss");
//}
// if (dsDoctorTimedetail.Tables[0].Rows.Count > 0)
// {
// int PerAppointment = 0;
// //Endtime = Convert.ToDateTime(drMainDetail["ToTime"].ToString());
// PerAppointment = Convert.ToInt32(drMainDetail["PerAppointmentTimeinMinute"].ToString());
// if (PatientAppointment.PatientAppointmentNO != "OnCalls")
// {
// for (int i = 1; Convert.ToInt32(drMainDetail["NoOfAppointment"].ToString()) >= i; i++)
// {
// DataView dvDetail = new DataView(dsDoctorTimedetail.Tables[1], "DoctorAppoinmentScheduleID = " + drMainDetail["DoctorAppoinmentScheduleID"].ToString() + " and NoOfAppointment = " + i + "", "", DataViewRowState.CurrentRows);
// Totime = Convert.ToDateTime(FromTime).AddMinutes(+PerAppointment).ToString("hh:mm:ss");
// if (Mode.ToString() == "Edit")
// {
// if (i == NoOfAppointment)
// {
// dvDetail = new DataView(dsDoctorTimedetail.Tables[1], "DoctorAppoinmentScheduleID = " + drMainDetail["DoctorAppoinmentScheduleID"].ToString() + " and NoOfAppointment = " + 0 + "", "", DataViewRowState.CurrentRows);
// }
// }
// if (dvDetail.Count == 0)
// {
// DataRow dr = dsDoctorSchedule.Tables[0].NewRow();
// dr["FromTime"] = FromTime;
// dr["ToTime"] = Totime;
// dr["FromToTime"] = "" + Convert.ToDateTime(FromTime).TimeOfDay + " To " + Convert.ToDateTime(Totime).TimeOfDay + "";
// dr["DoctorAppoinmentScheduleID"] = drMainDetail["DoctorAppoinmentScheduleID"].ToString();
// dr["NoOfAppointment"] = i;
// dsDoctorSchedule.Tables[0].Rows.Add(dr);
// }
// FromTime = Totime;
// }
// }
// else
// {
// DataRow dr = dsDoctorSchedule.Tables[0].NewRow();
// dr["FromTime"] = Convert.ToString(FromTime);
// dr["ToTime"] = Convert.ToString(Totime);
// dr["FromToTime"] = "" + FromTime + " To " + Totime + "";
// dr["DoctorAppoinmentScheduleID"] = drMainDetail["DoctorAppoinmentScheduleID"].ToString();
// dr["NoOfAppointment"] = 0;
// dsDoctorSchedule.Tables[0].Rows.Add(dr);
// }
// }
//}
// DataRow drAppointment = dsDoctorSchedule.Tables[0].NewRow();
List <string[]> fillFromTO = new List <string[]>();
List <string> fillFromTO1 = new List <string>();
foreach (DataRow dr in dsDoctorTimedetail.Tables[0].Rows)
{
fillFromTO.Add(new string[] {
FromTime = Convert.ToDateTime(dr["FromTime"]).ToString("hh:mm:ss tt"),
ToTime = Convert.ToDateTime(dr["ToTime"]).ToString("hh:mm:ss tt"),
//FromTime = Convert.ToDateTime(dr["FromTime"].ToString("hh:mm:ss")),
// ToTime= Convert.ToDateTime(dr["ToTime"].ToString("hh:mm:ss"))
});
}
//if (Mode.ToString() == "Edit")
//{
// NoOfAppointment = 0;
//}
return(new JsonResult {
Data = fillFromTO, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult BindFromToTime(string AppointmentType, string DoctorID, string AppointmentDate)
{
string Mode = "";
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
PatientAppointment.PatientAppointmentNO = AppointmentType;
PatientAppointment.DoctorID = DoctorID;
DataSet dsDoctorTimedetail = new DataSet();
if (PatientAppointment.PatientAppointmentNO == "Weekly")
{
dsDoctorTimedetail = _PatientAppointment.GetPatientAppointmentDetailForDoctorDetail(HospitalID, LocationID, Convert.ToInt32(PatientAppointment.DoctorID), PatientAppointment.PatientAppointmentNO, Convert.ToString(Convert.ToDateTime(AppointmentDate).DayOfWeek.ToString()), Convert.ToDateTime(AppointmentDate));
}
else
if (PatientAppointment.PatientAppointmentNO == "Monthly")
{
dsDoctorTimedetail = _PatientAppointment.GetPatientAppointmentDetailForDoctorDetail(HospitalID, LocationID, Convert.ToInt32(PatientAppointment.DoctorID), PatientAppointment.PatientAppointmentNO, Convert.ToString(Convert.ToDateTime(AppointmentDate).Day.ToString()), Convert.ToDateTime(AppointmentDate));
}
else
{
dsDoctorTimedetail = _PatientAppointment.GetPatientAppointmentDetailForDoctorDetail(HospitalID, LocationID, Convert.ToInt32(PatientAppointment.DoctorID), PatientAppointment.PatientAppointmentNO, "Daily", Convert.ToDateTime(AppointmentDate));
}
GetEmptyDatasetPatientSchedule();
foreach (DataRow drMainDetail in dsDoctorTimedetail.Tables[0].Rows)
{
if (dsDoctorTimedetail.Tables[0].Rows.Count > 0)
{
string FromTime;
string Totime;
DateTime Endtime;
int PerAppointment = 0;
string Totime1;
if (dsDoctorTimedetail.Tables[3].Rows.Count > 0)
{
FromTime = Convert.ToDateTime(dsDoctorTimedetail.Tables[3].Rows[0]["FromTime"]).ToString("hh:mm:ss");
Totime = Convert.ToDateTime(dsDoctorTimedetail.Tables[3].Rows[0]["ToTime"]).ToString("hh:mm:ss");
Totime1 = Convert.ToDateTime(dsDoctorTimedetail.Tables[3].Rows[0]["ToTime"]).ToString("hh:mm:ss");
}
else
{
FromTime = Convert.ToDateTime(drMainDetail["FromTime"]).ToString("hh:mm:ss");
Totime = Convert.ToDateTime(drMainDetail["ToTime"]).ToString("hh:mm:ss");
Totime1 = Convert.ToDateTime(drMainDetail["ToTime"]).ToString("hh:mm:ss");
}
//Endtime = Convert.ToDateTime(drMainDetail["ToTime"].ToString());
PerAppointment = Convert.ToInt32(drMainDetail["PerAppointmentTimeinMinute"].ToString());
if (PatientAppointment.PatientAppointmentNO != "OnCalls")
{
for (int i = 1; Convert.ToInt32(drMainDetail["NoOfAppointment"].ToString()) >= i; i++)
{
DataView dvDetail = new DataView(dsDoctorTimedetail.Tables[1], "DoctorAppoinmentScheduleID = " + drMainDetail["DoctorAppoinmentScheduleID"].ToString() + " and NoOfAppointment = " + i + "", "", DataViewRowState.CurrentRows);
Totime = Convert.ToDateTime(FromTime).AddMinutes(+PerAppointment).ToString("hh:mm:ss");
if (Convert.ToDateTime(Totime) > Convert.ToDateTime(Totime1))
{
break;
}
if (Mode.ToString() == "Edit")
{
if (i == NoOfAppointment)
{
dvDetail = new DataView(dsDoctorTimedetail.Tables[1], "DoctorAppoinmentScheduleID = " + drMainDetail["DoctorAppoinmentScheduleID"].ToString() + " and NoOfAppointment = " + 0 + "", "", DataViewRowState.CurrentRows);
}
}
if (dvDetail.Count == 0)
{
DataRow dr = dsDoctorSchedule.Tables[0].NewRow();
dr["FromTime"] = FromTime;
dr["ToTime"] = Totime;
dr["FromToTime"] = "" + Convert.ToDateTime(FromTime).TimeOfDay + " To " + Convert.ToDateTime(Totime).TimeOfDay + "";
dr["DoctorAppoinmentScheduleID"] = drMainDetail["DoctorAppoinmentScheduleID"].ToString();
dr["NoOfAppointment"] = i;
dsDoctorSchedule.Tables[0].Rows.Add(dr);
}
else
{
if (dsDoctorTimedetail.Tables[3].Rows.Count > 0)
{
Connect();
SqlCommand cmd = new SqlCommand("update PatientAppointmentDetails set FromTime='" + Convert.ToDateTime(FromTime).ToString("hh:mm:ss") + "' , ToTime='" + Convert.ToDateTime(Totime).ToString("hh:mm:ss") + "' where DoctorAppoinmentScheduleID=" + dsDoctorTimedetail.Tables[0].Rows[0]["DoctorAppoinmentScheduleID"].ToString() + " and NoOfAppointment=" + i + " and AppointmentDate='" + Convert.ToDateTime(AppointmentDate).ToString("yyyy-MM-dd") + "' and HospitalID=" + HospitalID + " and LocationID=" + LocationID + " and RowStatus=0", con);
con.Open();
int a = cmd.ExecuteNonQuery();
con.Close();
}
}
//---
FromTime = Totime;
}
}
else
{
DataRow dr = dsDoctorSchedule.Tables[0].NewRow();
dr["FromTime"] = Convert.ToString(FromTime);
dr["ToTime"] = Convert.ToString(Totime);
dr["FromToTime"] = "" + FromTime + " To " + Totime + "";
dr["DoctorAppoinmentScheduleID"] = drMainDetail["DoctorAppoinmentScheduleID"].ToString();
dr["NoOfAppointment"] = 0;
dsDoctorSchedule.Tables[0].Rows.Add(dr);
}
}
}
DataRow drAppointment = dsDoctorSchedule.Tables[0].NewRow();
List <string[]> fillFromTO = new List <string[]>();
List <string> fillFromTO1 = new List <string>();
if (dsDoctorTimedetail.Tables[3].Rows.Count > 0)
{
if (Convert.ToBoolean(dsDoctorTimedetail.Tables[3].Rows[0]["CancelAppointment"].ToString()) == true)
{
dsDoctorTimedetail.Reset();
return(new JsonResult {
Data = "Doctor Not Comming", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
foreach (DataRow dr in dsDoctorSchedule.Tables[0].Rows)
{
fillFromTO.Add(new string[] { dr["FromToTime"].ToString(), dr["NoOfAppointment"].ToString() });
}
if (Mode.ToString() == "Edit")
{
NoOfAppointment = 0;
}
return(new JsonResult {
Data = fillFromTO, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult SaveDoctorReschedule(string DoctorName, string DoctorID, string Reason, string FromTime1, string ToTime, string AppointmentDate, string AppointmentType, string CancelAppointment)
{
string message = "";
try
{
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
PatientAppointmentCalenderWise PatientAppointment = new PatientAppointmentCalenderWise();
PatientAppointment.HospitalID = Convert.ToInt32(Session["HospitalID"]);
PatientAppointment.LocationID = Convert.ToInt32(Session["LocationID"]);
int UserID = Convert.ToInt32(Session["UserID"]);
PatientAppointment.RescheduleID = "0";
PatientAppointment.Reason = Reason;
PatientAppointment.DoctorName = DoctorName;
PatientAppointment.DoctorID = DoctorID;
PatientAppointment.DoctorAppoinmentID = "0";
PatientAppointment.PatientAppointmentID = "0";
PatientAppointment.Date = Convert.ToDateTime(AppointmentDate);
if (CancelAppointment == "true")
{
PatientAppointment.CancelAppointment = true;
}
else
{
PatientAppointment.CancelAppointment = false;
}
PatientAppointment.AppointmentType = AppointmentType;
PatientAppointment.FromTime = FromTime1;
PatientAppointment.ToTime = ToTime;
if (_PatientAppointment.AddDoctorReschedule(PatientAppointment))
{
//ModelState.Clear();
//ViewData["flag"] = "Done";
//TempData["msg"] = "Appointment Added Successfully";
ModelState.Clear();
ViewData["flag"] = "Done";
message = "Appointment Added Successfully";
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
catch (Exception ex)
{
message = ex.Message;
}
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
