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