public string AddPatientAppointment(int patientId, int doctorId, string appointmentDate, string appointmentTime, int problemBodyPartId, string problemDescription) { AddPatientAppointmentBO objAddPatientAppointmentBO = new AddPatientAppointmentBO(); objAddPatientAppointmentBO.patientId = patientId; objAddPatientAppointmentBO.doctorId = doctorId; objAddPatientAppointmentBO.appointmentDate = appointmentDate; objAddPatientAppointmentBO.appointmentTime = appointmentTime; objAddPatientAppointmentBO.problemBodyPartId = problemBodyPartId; objAddPatientAppointmentBO.problemDescription = problemDescription; AddPatientAppointmentDL objAddNewPatientAppointmentDL = new AddPatientAppointmentDL(); return objAddNewPatientAppointmentDL.AddPatientAppointment(objAddPatientAppointmentBO); }
public string AddPatientAppointment(int patientId, int doctorId, string appointmentDate, string appointmentTime, int problemBodyPartId, string problemDescription) { AddPatientAppointmentBO objAddPatientAppointmentBO = new AddPatientAppointmentBO(); objAddPatientAppointmentBO.patientId = patientId; objAddPatientAppointmentBO.doctorId = doctorId; objAddPatientAppointmentBO.appointmentDate = appointmentDate; objAddPatientAppointmentBO.appointmentTime = appointmentTime; objAddPatientAppointmentBO.problemBodyPartId = problemBodyPartId; objAddPatientAppointmentBO.problemDescription = problemDescription; AddPatientAppointmentDL objAddNewPatientAppointmentDL = new AddPatientAppointmentDL(); return(objAddNewPatientAppointmentDL.AddPatientAppointment(objAddPatientAppointmentBO)); }
public string AddPatientAppointment(AddPatientAppointmentBO objAddPatientAppointmentBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddPatientAppointment", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@patientId", objAddPatientAppointmentBO.patientId); cmd.Parameters.Add("@doctorId", objAddPatientAppointmentBO.doctorId); cmd.Parameters.Add("@appointmentDate", objAddPatientAppointmentBO.appointmentDate); cmd.Parameters.Add("@appointmentTime", objAddPatientAppointmentBO.appointmentTime); cmd.Parameters.Add("@problemBodyPartId", objAddPatientAppointmentBO.problemBodyPartId); cmd.Parameters.Add("@problemDescription", objAddPatientAppointmentBO.problemDescription); conn.Open(); string appointmentToken = (cmd.ExecuteScalar()).ToString(); conn.Close(); return appointmentToken; }
public string AddPatientAppointment(AddPatientAppointmentBO objAddPatientAppointmentBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddPatientAppointment", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@patientId", objAddPatientAppointmentBO.patientId); cmd.Parameters.Add("@doctorId", objAddPatientAppointmentBO.doctorId); cmd.Parameters.Add("@appointmentDate", objAddPatientAppointmentBO.appointmentDate); cmd.Parameters.Add("@appointmentTime", objAddPatientAppointmentBO.appointmentTime); cmd.Parameters.Add("@problemBodyPartId", objAddPatientAppointmentBO.problemBodyPartId); cmd.Parameters.Add("@problemDescription", objAddPatientAppointmentBO.problemDescription); conn.Open(); string appointmentToken = (cmd.ExecuteScalar()).ToString(); conn.Close(); return(appointmentToken); }