public int Doctor_IPDDoctorTransfer(string transferDate, string transferTime, string reasonForTransfer, int transferToDoctorId, int transferByDoctorId, int patientId) { Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO = new Doctor_IPDDoctorTransferBO(); objDoctor_IPDDoctorTransferBO.transferDate = transferDate; objDoctor_IPDDoctorTransferBO.transferTime = transferTime; objDoctor_IPDDoctorTransferBO.reasonForTransfer = reasonForTransfer; objDoctor_IPDDoctorTransferBO.transferByDoctorId = transferByDoctorId; objDoctor_IPDDoctorTransferBO.transferToDoctorId = transferToDoctorId; objDoctor_IPDDoctorTransferBO.patientId = patientId; Doctor_IPDDoctorTransferDL objDoctor_IPDDoctorTransferDL = new Doctor_IPDDoctorTransferDL(); return objDoctor_IPDDoctorTransferDL.Doctor_IPDDoctorTransfer(objDoctor_IPDDoctorTransferBO); }
public int Doctor_IPDDoctorTransfer(string transferDate, string transferTime, string reasonForTransfer, int transferToDoctorId, int transferByDoctorId, int patientId) { Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO = new Doctor_IPDDoctorTransferBO(); objDoctor_IPDDoctorTransferBO.transferDate = transferDate; objDoctor_IPDDoctorTransferBO.transferTime = transferTime; objDoctor_IPDDoctorTransferBO.reasonForTransfer = reasonForTransfer; objDoctor_IPDDoctorTransferBO.transferByDoctorId = transferByDoctorId; objDoctor_IPDDoctorTransferBO.transferToDoctorId = transferToDoctorId; objDoctor_IPDDoctorTransferBO.patientId = patientId; Doctor_IPDDoctorTransferDL objDoctor_IPDDoctorTransferDL = new Doctor_IPDDoctorTransferDL(); return(objDoctor_IPDDoctorTransferDL.Doctor_IPDDoctorTransfer(objDoctor_IPDDoctorTransferBO)); }
public int Doctor_IPDDoctorTransfer(Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("sp_Doctor_IPDDoctorTransfer", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@transferDate", objDoctor_IPDDoctorTransferBO.transferDate); cmd.Parameters.Add("@transferTime", objDoctor_IPDDoctorTransferBO.transferTime); cmd.Parameters.Add("@reasonForTransfer", objDoctor_IPDDoctorTransferBO.reasonForTransfer); cmd.Parameters.Add("@transferToDoctorId", objDoctor_IPDDoctorTransferBO.transferToDoctorId); cmd.Parameters.Add("@transferByDoctorId", objDoctor_IPDDoctorTransferBO.transferByDoctorId); cmd.Parameters.Add("@patientId", objDoctor_IPDDoctorTransferBO.patientId); conn.Open(); int doctorTransferId = Convert.ToInt32((cmd.ExecuteScalar()).ToString()); conn.Close(); return doctorTransferId; }
public int Doctor_IPDDoctorTransfer(Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("sp_Doctor_IPDDoctorTransfer", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@transferDate", objDoctor_IPDDoctorTransferBO.transferDate); cmd.Parameters.Add("@transferTime", objDoctor_IPDDoctorTransferBO.transferTime); cmd.Parameters.Add("@reasonForTransfer", objDoctor_IPDDoctorTransferBO.reasonForTransfer); cmd.Parameters.Add("@transferToDoctorId", objDoctor_IPDDoctorTransferBO.transferToDoctorId); cmd.Parameters.Add("@transferByDoctorId", objDoctor_IPDDoctorTransferBO.transferByDoctorId); cmd.Parameters.Add("@patientId", objDoctor_IPDDoctorTransferBO.patientId); conn.Open(); int doctorTransferId = Convert.ToInt32((cmd.ExecuteScalar()).ToString()); conn.Close(); return(doctorTransferId); }