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