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();
    }
Example #3
0
    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();
    }
Example #4
0
    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);
    }