public int Common_PatientWardTransfer(int patientId, int previousWardId, int previousWardNumber, string transferDate, string transferTime, string reasonForTransfer, int newWardId, int newWardNumber, int empId) { Common_PatientWardTransferBO objCommon_PatientWardTransferBO = new Common_PatientWardTransferBO(); objCommon_PatientWardTransferBO.patientId = patientId; objCommon_PatientWardTransferBO.previousWardId = previousWardId; objCommon_PatientWardTransferBO.previousWardNumber = previousWardNumber; objCommon_PatientWardTransferBO.transferDate = transferDate; objCommon_PatientWardTransferBO.transferTime = transferTime; objCommon_PatientWardTransferBO.reasonForTransfer = reasonForTransfer; objCommon_PatientWardTransferBO.newWardId = newWardId; objCommon_PatientWardTransferBO.newWardNumber = newWardNumber; objCommon_PatientWardTransferBO.empId = empId; Common_PatientWardTransferDL objCommon_PatientWardTransferDL = new Common_PatientWardTransferDL(); return objCommon_PatientWardTransferDL.Common_PatientWardTransfer(objCommon_PatientWardTransferBO); }
public int Common_PatientWardTransfer(Common_PatientWardTransferBO objCommon_PatientWardTransferBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spPatientWardTransfer", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@patientId", objCommon_PatientWardTransferBO.patientId); cmd.Parameters.Add("@previousWardId", objCommon_PatientWardTransferBO.previousWardId); cmd.Parameters.Add("@previousWardNumber", objCommon_PatientWardTransferBO.previousWardNumber); cmd.Parameters.Add("@transferTime", objCommon_PatientWardTransferBO.transferTime); cmd.Parameters.Add("@transferDate", objCommon_PatientWardTransferBO.transferDate); cmd.Parameters.Add("@reasonForTransfer", objCommon_PatientWardTransferBO.reasonForTransfer); cmd.Parameters.Add("@newWardId", objCommon_PatientWardTransferBO.newWardId); cmd.Parameters.Add("@newWardNumber", objCommon_PatientWardTransferBO.newWardNumber); cmd.Parameters.Add("@empId", objCommon_PatientWardTransferBO.empId); conn.Open(); int wardTransferId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return wardTransferId; }
public int Common_PatientWardTransfer(int patientId, int previousWardId, int previousWardNumber, string transferDate, string transferTime, string reasonForTransfer, int newWardId, int newWardNumber, int empId) { Common_PatientWardTransferBO objCommon_PatientWardTransferBO = new Common_PatientWardTransferBO(); objCommon_PatientWardTransferBO.patientId = patientId; objCommon_PatientWardTransferBO.previousWardId = previousWardId; objCommon_PatientWardTransferBO.previousWardNumber = previousWardNumber; objCommon_PatientWardTransferBO.transferDate = transferDate; objCommon_PatientWardTransferBO.transferTime = transferTime; objCommon_PatientWardTransferBO.reasonForTransfer = reasonForTransfer; objCommon_PatientWardTransferBO.newWardId = newWardId; objCommon_PatientWardTransferBO.newWardNumber = newWardNumber; objCommon_PatientWardTransferBO.empId = empId; Common_PatientWardTransferDL objCommon_PatientWardTransferDL = new Common_PatientWardTransferDL(); return(objCommon_PatientWardTransferDL.Common_PatientWardTransfer(objCommon_PatientWardTransferBO)); }
public int Common_PatientWardTransfer(Common_PatientWardTransferBO objCommon_PatientWardTransferBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spPatientWardTransfer", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@patientId", objCommon_PatientWardTransferBO.patientId); cmd.Parameters.Add("@previousWardId", objCommon_PatientWardTransferBO.previousWardId); cmd.Parameters.Add("@previousWardNumber", objCommon_PatientWardTransferBO.previousWardNumber); cmd.Parameters.Add("@transferTime", objCommon_PatientWardTransferBO.transferTime); cmd.Parameters.Add("@transferDate", objCommon_PatientWardTransferBO.transferDate); cmd.Parameters.Add("@reasonForTransfer", objCommon_PatientWardTransferBO.reasonForTransfer); cmd.Parameters.Add("@newWardId", objCommon_PatientWardTransferBO.newWardId); cmd.Parameters.Add("@newWardNumber", objCommon_PatientWardTransferBO.newWardNumber); cmd.Parameters.Add("@empId", objCommon_PatientWardTransferBO.empId); conn.Open(); int wardTransferId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(wardTransferId); }