Ejemplo n.º 1
0
    public static OfferingOrder[] GetAll(DateTime startOrderedDate, DateTime endOrderedDate, int offering_id = -1, int organisation_id = 0, int patient_id = -1, int staff_id = -1, bool is_filled_or_cancelled = false, bool is_not_filled_or_cancelled = false)
    {
        DataTable tbl = GetDataTable(startOrderedDate, endOrderedDate, offering_id, organisation_id, patient_id, staff_id, is_filled_or_cancelled, is_not_filled_or_cancelled);

        OfferingOrder[] o = new OfferingOrder[tbl.Rows.Count];
        for (int i = 0; i < tbl.Rows.Count; i++)
        {
            o[i] = LoadAll(tbl.Rows[i]);
        }

        return(o);
    }
Ejemplo n.º 2
0
 public InvoiceLine(int invoice_line_id, int invoice_id, int patient_id, int offering_id, decimal quantity, decimal price, decimal tax, string area_treated, string service_reference, int offering_order_id)
 {
     this.invoice_line_id   = invoice_line_id;
     this.invoice_id        = invoice_id;
     this.patient           = new Patient(patient_id);
     this.offering          = offering_id == -1 ? null : new Offering(offering_id);
     this.quantity          = quantity;
     this.price             = price;
     this.tax               = tax;
     this.area_treated      = area_treated;
     this.service_reference = service_reference;
     this.offering_order    = offering_order_id == -1 ? null : new OfferingOrder(offering_order_id);
 }
Ejemplo n.º 3
0
    public static OfferingOrder LoadAll(DataRow row)
    {
        OfferingOrder o = Load(row, "offeringorder_");

        if (row["organisation_organisation_id"] != DBNull.Value)
        {
            o.Organisation = OrganisationDB.Load(row, "organisation_");
            o.Organisation.OrganisationType = OrganisationTypeDB.Load(row, "org_type_");
            o.Organisation.OrganisationType.OrganisationTypeGroup = IDandDescrDB.Load(row, "typegroup_organisation_type_group_id", "typegroup_descr");
        }
        if (row["staff_staff_id"] != DBNull.Value)
        {
            o.Staff = StaffDB.Load(row, "staff_");
        }
        if (row["staff_staff_id"] != DBNull.Value)
        {
            o.Staff.Person       = PersonDB.Load(row, "person_staff_");
            o.Staff.Person.Title = IDandDescrDB.Load(row, "title_staff_title_id", "title_staff_descr");
        }
        if (row["patient_patient_id"] != DBNull.Value)
        {
            o.Patient = PatientDB.Load(row, "patient_");
        }
        if (row["patient_patient_id"] != DBNull.Value)
        {
            o.Patient.Person       = PersonDB.Load(row, "person_patient_");
            o.Patient.Person.Title = IDandDescrDB.Load(row, "title_patient_title_id", "title_patient_descr");
        }
        if (row["offering_offering_id"] != DBNull.Value)
        {
            o.Offering = OfferingDB.Load(row, "offering_");
        }
        if (row["offeringfield_field_id"] != DBNull.Value)
        {
            o.Offering.Field = IDandDescrDB.Load(row, "offeringfield_field_id", "offeringfield_descr");
        }


        return(o);
    }
Ejemplo n.º 4
0
    public static OfferingOrder[] GetAll(DateTime startOrderedDate, DateTime endOrderedDate, int offering_id = -1, int organisation_id = 0, int patient_id = -1, int staff_id = -1, bool is_filled_or_cancelled = false, bool is_not_filled_or_cancelled = false)
    {
        DataTable tbl = GetDataTable(startOrderedDate, endOrderedDate, offering_id, organisation_id, patient_id, staff_id, is_filled_or_cancelled, is_not_filled_or_cancelled);

        OfferingOrder[] o = new OfferingOrder[tbl.Rows.Count];
        for (int i = 0; i < tbl.Rows.Count; i++)
            o[i] = LoadAll(tbl.Rows[i]);

        return o;
    }