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);
}
