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);
}
