public bool AddDoctorReschedule(KeystoneProject.Models.Patient.PatientAppointmentSchedule 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 bool Save(KeystoneProject.Models.Patient.PatientAppointmentSchedule 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 == "" || obj.PatientID == "0") { 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.Gender != null) { cmd.Parameters.AddWithValue("@Gender", obj.Gender); } else { cmd.Parameters.AddWithValue("@Gender", ""); } 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["@PatientAppointmentScheduleID"].Direction = ParameterDirection.Output; cmd1.Parameters.AddWithValue("@Mode", "Add"); } else { cmd1.Parameters.AddWithValue("@PatientAppointmentScheduleID", obj.PatientAppointmentScheduleID); cmd1.Parameters.AddWithValue("@Mode", "Edit"); } // cmd1.Parameters.AddWithValue("@DoctorAppoinmentScheduleID", obj.DoctorAppoinmentScheduleID); cmd1.Parameters.AddWithValue("@PatientID", obj.PatientID); cmd1.Parameters.AddWithValue("@DoctorID", obj.DoctorID); if (obj.AppointmentDate == null) { cmd1.Parameters.AddWithValue("@AppointmentDate", System.DateTime.Now); } else { cmd1.Parameters.AddWithValue("@AppointmentDate", Convert.ToDateTime(obj.AppointDateID)); } 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); }