public ActionResult PatientAppointmentCalenderWise()
{
PatientAppointmentCalenderWise PatientAppointment = new PatientAppointmentCalenderWise();
BL_PatientAppointmentCalendarWise _PatientAppointment = new BL_PatientAppointmentCalendarWise();
PatientAppointment.PatientID = _PatientAppointment.GetNextOutsidePatientID();
return(View(PatientAppointment));
}
public bool AddDoctorReschedule(PatientAppointmentCalenderWise obj)
{
Connect();
con.Open();
SqlCommand cmd = new SqlCommand("IUDoctorReschedule", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.RescheduleID != null)
{
cmd.Parameters.AddWithValue("@RescheduleID", 0);
cmd.Parameters["@RescheduleID"].Direction = ParameterDirection.Output;
}
else
{
cmd.Parameters.AddWithValue("@RescheduleID", obj.RescheduleID);
}
cmd.Parameters.AddWithValue("@Reason", obj.Reason);
cmd.Parameters.AddWithValue("@DoctorID", obj.DoctorID);
cmd.Parameters.AddWithValue("@DoctorName", obj.DoctorName);
cmd.Parameters.AddWithValue("@DoctorAppointmentScheduleID", 0);
cmd.Parameters.AddWithValue("@PatientAppointmentID", 0);
// if(obj.)
cmd.Parameters.AddWithValue("@CancelAppointment", obj.CancelAppointment);
cmd.Parameters.AddWithValue("@FromTime", obj.FromTime);
cmd.Parameters.AddWithValue("@ToTime", obj.ToTime);
cmd.Parameters.AddWithValue("@AppointmentType", obj.AppointmentType);
cmd.Parameters.AddWithValue("@Date", obj.Date);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Add");
int i = cmd.ExecuteNonQuery();
con.Close();
return(true);
}
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 bool Save(PatientAppointmentCalenderWise obj, DataSet ds)
{
Connect();
con.Open();
SqlCommand cmd = new SqlCommand("IUPatientAppointment", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PFPatientName", obj.PFPatientName);
if (obj.PatientID == null || obj.PatientID == "")
{
cmd.Parameters.AddWithValue("@PatientID", 0);
cmd.Parameters["@PatientID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@PatientID", obj.PatientID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@PatientRegNo", 0);
cmd.Parameters.AddWithValue("@PatientName", (obj.FirstName + " " + obj.PMiddleName + " " + obj.PLastName).ToUpper());
if (obj.FirstName == null)
{
cmd.Parameters.AddWithValue("@PFirstName", "");
}
else
{
cmd.Parameters.AddWithValue("@PFirstName", obj.FirstName.ToUpper());
}
if (obj.PMiddleName != null)
{
cmd.Parameters.AddWithValue("@PMiddleName", obj.PMiddleName.ToUpper());
}
else
{
cmd.Parameters.AddWithValue("@PMiddleName", "");
}
if (obj.PLastName != null)
{
cmd.Parameters.AddWithValue("@PLastName", obj.PLastName.ToUpper());
}
else
{
cmd.Parameters.AddWithValue("@PLastName", "");
}
if (obj.Age != null)
{
cmd.Parameters.AddWithValue("@Age", obj.Age);
}
else
{
cmd.Parameters.AddWithValue("@Age", 0);
}
cmd.Parameters.AddWithValue("@AgeType", "Years");
cmd.Parameters.AddWithValue("@DateOfBirth", obj.DateOFBirth);
cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo);
cmd.Parameters.AddWithValue("@PatientStatus", 0);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int PatientID = cmd.ExecuteNonQuery();
obj.PatientID = cmd.Parameters["@PatientID"].Value.ToString();
// int i = cmd.ExecuteNonQuery();
var delimiters = new char[] { 'T', 'o' };
var results = obj.FromTime.Split(delimiters);
// string[] datefo=obj.FromTime.Split(p);
SqlCommand cmd1 = new SqlCommand("[IUPatientAppointmentDetails]", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
cmd1.Parameters.AddWithValue("@PatientRegNo", 0);
if (obj.PatientAppointmentScheduleID == null || obj.PatientAppointmentScheduleID == "")
{
cmd1.Parameters.AddWithValue("@PatientAppointmentScheduleID", 0);
cmd1.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd1.Parameters.AddWithValue("@PatientAppointmentScheduleID", obj.PatientID);
cmd1.Parameters.AddWithValue("@Mode", "Edit");
}
// cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", obj.DoctorAppoinmentScheduleID);
cmd1.Parameters.AddWithValue("@DoctorID", obj.DoctorID);
if (obj.AppointmentDate == null)
{
cmd1.Parameters.AddWithValue("@AppointmentDate", System.DateTime.Now);
}
else
{
var date = obj.AppointmentDate.Split(',');
var date1 = Convert.ToDateTime(date[0]).ToString("dd-MM-yyyy");
cmd1.Parameters.AddWithValue("@AppointmentDate", Convert.ToDateTime(date1));
}
if (obj.AppointmentType != "OnCalls")
{
DataView dvDetail = new DataView(ds.Tables[0], "NoOfAppointment = '" + obj.AppointmentNoID + "' ", "", DataViewRowState.CurrentRows);
if (dvDetail.Count > 0)
{
cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", dvDetail[0]["DoctorAppoinmentScheduleID"].ToString());
cmd1.Parameters.AddWithValue("@FromTime", dvDetail[0]["FromTime"].ToString());
cmd1.Parameters.AddWithValue("@ToTime", dvDetail[0]["ToTime"].ToString());
cmd1.Parameters.AddWithValue("@NoOfAppointment", dvDetail[0]["NoOfAppointment"].ToString());
}
else
{
if (ds.Tables[0].Rows[0]["DoctorAppoinmentScheduleID"].ToString() == "")
{
cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", ds.Tables[0].Rows[0]["DoctorAppoinmentScheduleID"].ToString());
}
else
{
cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", obj.DoctorAppoinmentScheduleID);
}
if (obj.FromTime == "")
{
cmd1.Parameters.AddWithValue("@FromTime", "");
}
else
{
cmd1.Parameters.AddWithValue("@FromTime", obj.FromTime);
}
if (obj.ToTime == "")
{
cmd1.Parameters.AddWithValue("@ToTime", "");
}
else
{
cmd1.Parameters.AddWithValue("@ToTime", obj.ToTime);
}
cmd1.Parameters.AddWithValue("@NoOfAppointment", obj.AppointmentNoID);
}
}
else
{
if (ds.Tables[0].Rows[0]["DoctorAppoinmentScheduleID"].ToString() == "")
{
cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", ds.Tables[0].Rows[0]["DoctorAppoinmentScheduleID"].ToString());
}
else
{
cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", "");
}
if (obj.FromTime == "")
{
cmd1.Parameters.AddWithValue("@FromTime", obj.FromTime);
}
else
{
cmd1.Parameters.AddWithValue("@FromTime", "");
}
if (obj.ToTime == "")
{
cmd1.Parameters.AddWithValue("@ToTime", obj.ToTime);
}
else
{
cmd1.Parameters.AddWithValue("@ToTime", "");
}
cmd1.Parameters.AddWithValue("@NoOfAppointment", 0);
}
cmd1.Parameters.AddWithValue("@CreationID", UserID);
//cmd1.Parameters.AddWithValue("@AppointmentType", obj.AppointmentType);
//cmd1.Parameters.AddWithValue("@FromTime", results[0]);
//cmd1.Parameters.AddWithValue("@ToTime", results[2]);
//cmd1.Parameters.AddWithValue("@NoOfAppointment", obj.AppointmentNoID);
//cmd1.Parameters.AddWithValue("@CreationID", UserID);
int Vouchar = cmd1.ExecuteNonQuery();
con.Close();
return(true);
}
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 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
});
}
