public void Doctor_AddOPDTreatmentMedicine(string appointmentToken, int medicineTypeId, int medicineNameId, string medicineStrength, string medicineQuantity, string medicineStartDate, int numberOfRefills, string quantityOnRefills, string medicineInstructions) { Doctor_AddOPDTreatmentMedicineBO objAddOPDTreatmentMedicineBO = new Doctor_AddOPDTreatmentMedicineBO(); objAddOPDTreatmentMedicineBO.appointmentToken = appointmentToken; objAddOPDTreatmentMedicineBO.medicineInstructions = medicineInstructions; objAddOPDTreatmentMedicineBO.medicineNameId = medicineNameId; objAddOPDTreatmentMedicineBO.medicineQuantity = medicineQuantity; objAddOPDTreatmentMedicineBO.medicineStartDate = medicineStartDate; objAddOPDTreatmentMedicineBO.medicineStrength = medicineStrength; objAddOPDTreatmentMedicineBO.medicineTypeId = medicineTypeId; objAddOPDTreatmentMedicineBO.numberOfRefills = numberOfRefills; objAddOPDTreatmentMedicineBO.quantityOnRefills = quantityOnRefills; AddOPDTreatmentMedicineDL objAddOPDTreatmentMedicineDL = new AddOPDTreatmentMedicineDL(); objAddOPDTreatmentMedicineDL.AddOPDTreatmentMedicine(objAddOPDTreatmentMedicineBO); }
public void AddOPDTreatmentMedicine(Doctor_AddOPDTreatmentMedicineBO objAddOPDTreatmentMedicineBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddOPDTreatmentMedicine", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@appointmentToken", objAddOPDTreatmentMedicineBO.appointmentToken); cmd.Parameters.Add("@medicineInstructions", objAddOPDTreatmentMedicineBO.medicineInstructions); cmd.Parameters.Add("@medicineNameId", objAddOPDTreatmentMedicineBO.medicineNameId); cmd.Parameters.Add("@medicineQuantity", objAddOPDTreatmentMedicineBO.medicineQuantity); cmd.Parameters.Add("@medicineStartDate", objAddOPDTreatmentMedicineBO.medicineStartDate); cmd.Parameters.Add("@medicineStrength", objAddOPDTreatmentMedicineBO.medicineStrength); cmd.Parameters.Add("@medicineTypeId", objAddOPDTreatmentMedicineBO.medicineTypeId); cmd.Parameters.Add("@numberOfRefills", objAddOPDTreatmentMedicineBO.numberOfRefills); cmd.Parameters.Add("@quantityOnRefills", objAddOPDTreatmentMedicineBO.quantityOnRefills); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public void AddOPDTreatmentMedicine(Doctor_AddOPDTreatmentMedicineBO objAddOPDTreatmentMedicineBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddOPDTreatmentMedicine", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@appointmentToken", objAddOPDTreatmentMedicineBO.appointmentToken); cmd.Parameters.Add("@medicineInstructions", objAddOPDTreatmentMedicineBO.medicineInstructions); cmd.Parameters.Add("@medicineNameId", objAddOPDTreatmentMedicineBO.medicineNameId); cmd.Parameters.Add("@medicineQuantity", objAddOPDTreatmentMedicineBO.medicineQuantity); cmd.Parameters.Add("@medicineStartDate", objAddOPDTreatmentMedicineBO.medicineStartDate); cmd.Parameters.Add("@medicineStrength", objAddOPDTreatmentMedicineBO.medicineStrength); cmd.Parameters.Add("@medicineTypeId", objAddOPDTreatmentMedicineBO.medicineTypeId); cmd.Parameters.Add("@numberOfRefills", objAddOPDTreatmentMedicineBO.numberOfRefills); cmd.Parameters.Add("@quantityOnRefills", objAddOPDTreatmentMedicineBO.quantityOnRefills); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public void Doctor_AddOPDTreatmentMedicine(string appointmentToken, int medicineTypeId, int medicineNameId, string medicineStrength, string medicineQuantity, string medicineStartDate, int numberOfRefills, string quantityOnRefills, string medicineInstructions) { Doctor_AddOPDTreatmentMedicineBO objAddOPDTreatmentMedicineBO = new Doctor_AddOPDTreatmentMedicineBO(); objAddOPDTreatmentMedicineBO.appointmentToken = appointmentToken; objAddOPDTreatmentMedicineBO.medicineInstructions = medicineInstructions; objAddOPDTreatmentMedicineBO.medicineNameId = medicineNameId; objAddOPDTreatmentMedicineBO.medicineQuantity = medicineQuantity; objAddOPDTreatmentMedicineBO.medicineStartDate = medicineStartDate; objAddOPDTreatmentMedicineBO.medicineStrength = medicineStrength; objAddOPDTreatmentMedicineBO.medicineTypeId = medicineTypeId; objAddOPDTreatmentMedicineBO.numberOfRefills = numberOfRefills; objAddOPDTreatmentMedicineBO.quantityOnRefills = quantityOnRefills; AddOPDTreatmentMedicineDL objAddOPDTreatmentMedicineDL = new AddOPDTreatmentMedicineDL(); objAddOPDTreatmentMedicineDL.AddOPDTreatmentMedicine(objAddOPDTreatmentMedicineBO); }