public int PurchaseInvoiceHeaderExists(int purchaseOrderID) { PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData(); PurchaseInvoiceHeaderCollection col = new PurchaseInvoiceHeaderCollection(); string where = "[PurchaseOrderID]=" + purchaseOrderID; string orderBy = String.Empty; try { col = data.GetAllPurchaseInvoiceHeaderDynamicCollection(where, orderBy); if (col.Count > 0) { return(col[0].InvoiceID); } else { return(0); } } catch { return(0); } }
public PurchaseInvoiceHeaderCollection GetPurchaseInvoiceHeaders(string where, string orderBy) { PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData(); PurchaseInvoiceHeaderCollection col = new PurchaseInvoiceHeaderCollection(); try { col = data.GetAllPurchaseInvoiceHeaderDynamicCollection(where, orderBy); } catch (Exception ex) { throw (ex); } finally { data = null; } return(col); }