public void Doctor_AddIPDObservationMedicine(string ipdObservationId, int ipdObservationReportId, int medicineTypeId, int medicineNameId, string medicineStrength, string medicineQuantity, string medicineStartDate, int numberOfRefills, string quantityOnRefills, string medicineInstructions) { Doctor_AddIPDObservationMedicineBO objDoctor_AddIPDObservationMedicineBO = new Doctor_AddIPDObservationMedicineBO(); objDoctor_AddIPDObservationMedicineBO.ipdObservationId = ipdObservationId; objDoctor_AddIPDObservationMedicineBO.ipdObservationReportId = ipdObservationReportId; objDoctor_AddIPDObservationMedicineBO.medicineTypeId = medicineTypeId; objDoctor_AddIPDObservationMedicineBO.medicineNameId = medicineNameId; objDoctor_AddIPDObservationMedicineBO.medicineStrength = medicineStrength; objDoctor_AddIPDObservationMedicineBO.medicineQuantity = medicineQuantity; objDoctor_AddIPDObservationMedicineBO.medicineStartDate = medicineStartDate; objDoctor_AddIPDObservationMedicineBO.numberOfRefills = numberOfRefills; objDoctor_AddIPDObservationMedicineBO.quantityOnRefills = quantityOnRefills; objDoctor_AddIPDObservationMedicineBO.medicineInstructions = medicineInstructions; Doctor_AddIPDObservationMedicineDL objDoctor_AddIPDObservationMedicineDL = new Doctor_AddIPDObservationMedicineDL(); objDoctor_AddIPDObservationMedicineDL.Doctor_AddIPDObservationMedicine(objDoctor_AddIPDObservationMedicineBO); }
public void Doctor_AddIPDObservationMedicine(Doctor_AddIPDObservationMedicineBO objDoctor_AddIPDObservationMedicineBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("sp_Doctor_AddIPDObservationMedicine", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ipdObservationId", objDoctor_AddIPDObservationMedicineBO.ipdObservationId); cmd.Parameters.Add("@ipdObservationReportId", objDoctor_AddIPDObservationMedicineBO.ipdObservationReportId); cmd.Parameters.Add("@medicineInstructions", objDoctor_AddIPDObservationMedicineBO.medicineInstructions); cmd.Parameters.Add("@medicineNameId", objDoctor_AddIPDObservationMedicineBO.medicineNameId); cmd.Parameters.Add("@medicineQuantity", objDoctor_AddIPDObservationMedicineBO.medicineQuantity); cmd.Parameters.Add("@medicineStartDate", objDoctor_AddIPDObservationMedicineBO.medicineStartDate); cmd.Parameters.Add("@medicineStrength", objDoctor_AddIPDObservationMedicineBO.medicineStrength); cmd.Parameters.Add("@medicineTypeId", objDoctor_AddIPDObservationMedicineBO.medicineTypeId); cmd.Parameters.Add("@numberOfRefills", objDoctor_AddIPDObservationMedicineBO.numberOfRefills); cmd.Parameters.Add("@quantityOnRefills", objDoctor_AddIPDObservationMedicineBO.quantityOnRefills); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public void Doctor_AddIPDObservationMedicine(Doctor_AddIPDObservationMedicineBO objDoctor_AddIPDObservationMedicineBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("sp_Doctor_AddIPDObservationMedicine", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ipdObservationId", objDoctor_AddIPDObservationMedicineBO.ipdObservationId); cmd.Parameters.Add("@ipdObservationReportId", objDoctor_AddIPDObservationMedicineBO.ipdObservationReportId); cmd.Parameters.Add("@medicineInstructions", objDoctor_AddIPDObservationMedicineBO.medicineInstructions); cmd.Parameters.Add("@medicineNameId", objDoctor_AddIPDObservationMedicineBO.medicineNameId); cmd.Parameters.Add("@medicineQuantity", objDoctor_AddIPDObservationMedicineBO.medicineQuantity); cmd.Parameters.Add("@medicineStartDate", objDoctor_AddIPDObservationMedicineBO.medicineStartDate); cmd.Parameters.Add("@medicineStrength", objDoctor_AddIPDObservationMedicineBO.medicineStrength); cmd.Parameters.Add("@medicineTypeId", objDoctor_AddIPDObservationMedicineBO.medicineTypeId); cmd.Parameters.Add("@numberOfRefills", objDoctor_AddIPDObservationMedicineBO.numberOfRefills); cmd.Parameters.Add("@quantityOnRefills", objDoctor_AddIPDObservationMedicineBO.quantityOnRefills); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public void Doctor_AddIPDObservationMedicine(string ipdObservationId, int ipdObservationReportId, int medicineTypeId, int medicineNameId, string medicineStrength, string medicineQuantity, string medicineStartDate, int numberOfRefills, string quantityOnRefills, string medicineInstructions) { Doctor_AddIPDObservationMedicineBO objDoctor_AddIPDObservationMedicineBO = new Doctor_AddIPDObservationMedicineBO(); objDoctor_AddIPDObservationMedicineBO.ipdObservationId = ipdObservationId; objDoctor_AddIPDObservationMedicineBO.ipdObservationReportId = ipdObservationReportId; objDoctor_AddIPDObservationMedicineBO.medicineTypeId = medicineTypeId; objDoctor_AddIPDObservationMedicineBO.medicineNameId = medicineNameId; objDoctor_AddIPDObservationMedicineBO.medicineStrength = medicineStrength; objDoctor_AddIPDObservationMedicineBO.medicineQuantity = medicineQuantity; objDoctor_AddIPDObservationMedicineBO.medicineStartDate = medicineStartDate; objDoctor_AddIPDObservationMedicineBO.numberOfRefills = numberOfRefills; objDoctor_AddIPDObservationMedicineBO.quantityOnRefills = quantityOnRefills; objDoctor_AddIPDObservationMedicineBO.medicineInstructions = medicineInstructions; Doctor_AddIPDObservationMedicineDL objDoctor_AddIPDObservationMedicineDL = new Doctor_AddIPDObservationMedicineDL(); objDoctor_AddIPDObservationMedicineDL.Doctor_AddIPDObservationMedicine(objDoctor_AddIPDObservationMedicineBO); }