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