public static DataTable GetList()
{
Supplier supp = new Supplier();
string query = HCMIS.Repository.Queries.Supplier.SelectGetList();
supp.LoadFromRawSql(query);
return(supp.DataTable);
}
/// <summary>
/// Gets all suppliers for.
/// </summary>
/// <param name="ItemID">The item ID.</param>
/// <param name="unitID">The unit ID.</param>
/// <returns></returns>
public static DataTable GetAllSuppliersFor(int ItemID, int unitID)
{
Supplier supp = new Supplier();
string query = HCMIS.Repository.Queries.Supplier.SelectGetAllSuppliersFor(ItemID, unitID);
supp.LoadFromRawSql(query);
return(supp.DataTable);
}
public DataTable GetHubHeadOffice()
{
var supplier = new Supplier();
var query = HCMIS.Repository.Queries.Supplier.SelectGetHubHeadOffice();
supplier.LoadFromRawSql(query);
return(supplier.DataTable);
}
public static DataTable GetSuppliersByPOType(int poTypeID)
{
var supplier = new Supplier();
string query = HCMIS.Repository.Queries.Supplier.SelectSuppliersByPOType(poTypeID);
supplier.LoadFromRawSql(query);
return(supplier.DataTable);
}
public static DataTable GetDirectVendorSuppliers()
{
var supp = new Supplier();
string query = HCMIS.Repository.Queries.Supplier.SelectDirectDeliverySuppliers();
supp.LoadFromRawSql(query);
return(supp.DataTable);
}
public int GetVaccineHomeOfficeSupplierID()
{
var supplier = new Supplier();
string query = HCMIS.Repository.Queries.Supplier.SelectHomeOffice("VAC");
supplier.LoadFromRawSql(query);
return(Convert.ToInt32(supplier.DataTable.Rows[0]["SupplierID"]));
}