public int Common_AddOPDMedicalTestRegistration(int patientId, int medicalTestId,
string testDate, string testTime)
{
Common_AddOPDMedicalTestRegistrationBO objCommon_AddOPDMedicalTestRegistrationBO = new Common_AddOPDMedicalTestRegistrationBO();
objCommon_AddOPDMedicalTestRegistrationBO.patientId = patientId;
objCommon_AddOPDMedicalTestRegistrationBO.medicalTestId = medicalTestId;
objCommon_AddOPDMedicalTestRegistrationBO.testDate = testDate;
objCommon_AddOPDMedicalTestRegistrationBO.testTime = testTime;
Common_AddOPDMedicalTestRegistrationDL objCommon_AddOPDMedicalTestRegistrationDL = new Common_AddOPDMedicalTestRegistrationDL();
return objCommon_AddOPDMedicalTestRegistrationDL.Common_AddOPDMedicalTestRegistration(objCommon_AddOPDMedicalTestRegistrationBO);
}
public int Common_AddOPDMedicalTestRegistration(int patientId, int medicalTestId,
string testDate, string testTime)
{
Common_AddOPDMedicalTestRegistrationBO objCommon_AddOPDMedicalTestRegistrationBO = new Common_AddOPDMedicalTestRegistrationBO();
objCommon_AddOPDMedicalTestRegistrationBO.patientId = patientId;
objCommon_AddOPDMedicalTestRegistrationBO.medicalTestId = medicalTestId;
objCommon_AddOPDMedicalTestRegistrationBO.testDate = testDate;
objCommon_AddOPDMedicalTestRegistrationBO.testTime = testTime;
Common_AddOPDMedicalTestRegistrationDL objCommon_AddOPDMedicalTestRegistrationDL = new Common_AddOPDMedicalTestRegistrationDL();
return(objCommon_AddOPDMedicalTestRegistrationDL.Common_AddOPDMedicalTestRegistration(objCommon_AddOPDMedicalTestRegistrationBO));
}
public int Common_AddOPDMedicalTestRegistration(Common_AddOPDMedicalTestRegistrationBO objAddOPDMedicalTestRegistrationBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("spAddOPDMedicalTestRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@patientId", objAddOPDMedicalTestRegistrationBO.patientId);
cmd.Parameters.Add("@medicalTestId", objAddOPDMedicalTestRegistrationBO.medicalTestId);
cmd.Parameters.Add("@testDate", objAddOPDMedicalTestRegistrationBO.testDate);
cmd.Parameters.Add("@testTime", objAddOPDMedicalTestRegistrationBO.testTime);
conn.Open();
int opdMedicalTestRegistrationId = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return opdMedicalTestRegistrationId;
}
public int Common_AddOPDMedicalTestRegistration(Common_AddOPDMedicalTestRegistrationBO objAddOPDMedicalTestRegistrationBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("spAddOPDMedicalTestRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@patientId", objAddOPDMedicalTestRegistrationBO.patientId);
cmd.Parameters.Add("@medicalTestId", objAddOPDMedicalTestRegistrationBO.medicalTestId);
cmd.Parameters.Add("@testDate", objAddOPDMedicalTestRegistrationBO.testDate);
cmd.Parameters.Add("@testTime", objAddOPDMedicalTestRegistrationBO.testTime);
conn.Open();
int opdMedicalTestRegistrationId = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return(opdMedicalTestRegistrationId);
}