public static Offering GetOfferingByOrgAndOffering(int organisation_id, int offering_id) { string sql = JoinedSql_Offerings + " AND OrganisationOfferings.date_active <= GETDATE() AND OrganisationOfferings.organisation_id = " + organisation_id.ToString() + " AND OrganisationOfferings.offering_id = " + offering_id.ToString() + " ORDER BY OrganisationOfferings.date_active DESC"; DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; return((tbl.Rows.Count == 0) ? null : OfferingDB.LoadAll(tbl.Rows[0])); }
public static Offering[] GetOfferingsByOrg(bool only_active, string organisation_ids, string offering_invoice_type_ids = null, string offering_type_ids = null) { DataTable tbl = GetDataTable_OfferingsByOrg(only_active, organisation_ids, offering_invoice_type_ids, offering_type_ids); Offering[] list = new Offering[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = OfferingDB.LoadAll(tbl.Rows[i]); } return(list); }
public static Offering[] GetOfferingsByOrg(string organisation_ids) { DataTable tbl = GetDataTable_OfferingsByOrg(organisation_ids); Offering[] list = new Offering[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = OfferingDB.LoadAll(tbl.Rows[i]); } return(list); }
public static Hashtable GetHashtableByOrg(Organisation organisation) { Hashtable hash = new Hashtable(); DataTable dt_offering = GetDataTableByOrg(organisation); for (int i = 0; i < dt_offering.Rows.Count; i++) { Offering offering = OfferingDB.LoadAll(dt_offering.Rows[i]); hash[offering.OfferingID] = offering; } return(hash); }