/// <summary> /// Robert Forbes /// 2017/03/30 /// /// Updates the old invoice in the database so that it has the values of the new invoice /// </summary> /// <param name="oldInvoice">The original invoice</param> /// <param name="newInvoice">The invoice with updated values</param> /// <returns></returns> public bool UpdateSupplierInvoice(SupplierInvoice oldInvoice, SupplierInvoice newInvoice) { try { return(1 == SupplierInvoiceAccessor.UpdateSupplierInvoice(oldInvoice, newInvoice)); } catch (Exception) { throw; } }
/// <summary> /// Victor Algarin /// 2017/04/06 /// </summary> /// /// <param name="invoice">The selected invoice to be deleted</param> /// <returns>true (if query from accessor is successful)</returns> public bool DeleteSupplierInvoice(SupplierInvoice invoice) { try { return(SupplierInvoiceAccessor.DeleteSupplierInvoice(invoice) == 1); } catch (Exception) { return(false); throw new ApplicationException("There was a problem deleting the specified supplier invoice"); } }
/// <summary> /// Christian Lopez /// 2017/03/22 /// /// Attempts to retrieve a list of invoice lines by the given id /// </summary> /// <param name="invoiceId"></param> /// <returns></returns> public List <SupplierInvoiceLine> RetrieveSupplierInvoiceLinesByInvoiceId(int invoiceId) { try { return(SupplierInvoiceAccessor.RetrieveInvoiceLinesByInvoiceId(invoiceId)); } catch (SqlException ex) { throw new ApplicationException("There was a database error.", ex); } catch (Exception ex) { throw new ApplicationException("There was an unknown error.", ex); } }
/// <summary> /// Bobby Thorne /// 2017/04/14 /// /// Retrieve the invoices by the supplier Id /// </summary> /// <param name="supplierID"></param> /// <returns>List of the supplier invoices</returns> public List <SupplierInvoice> RetrieveAllSupplierInvoicesBySupplierId(int supplierID) { try { return(SupplierInvoiceAccessor.RetrieveSupplierInvoicesBySupplierID(supplierID)); } catch (SqlException ex) { throw new ApplicationException("There was a database error.", ex); } catch (Exception ex) { throw new ApplicationException("There was an unknown error.", ex); } }
/// <summary> /// Christian Lopez /// 2017/03/29 /// /// Adds a supplier invoice line /// </summary> /// <param name="line"></param> /// <returns></returns> public bool CreateSupplierInvoiceLine(SupplierInvoiceLine line) { try { return(1 == SupplierInvoiceAccessor.CreateSupplierInvoiceLine(line)); } catch (SqlException ex) { throw new ApplicationException("There was a database error.", ex); } catch (Exception ex) { throw new ApplicationException("There was an unknown error.", ex); } }
/// <summary> /// Christian Lopez /// 2017/03/23 /// /// Attempts to approve the invoice with the given invoice id /// </summary> /// <param name="invoiceId"></param> /// <returns></returns> public bool ApproveSupplierInvoice(int invoiceId) { bool result = false; try { if (1 == SupplierInvoiceAccessor.UpdateApproveSupplierInvoice(invoiceId)) { result = true; } } catch (SqlException ex) { throw new ApplicationException("There was a database error.", ex); } catch (Exception ex) { throw new ApplicationException("There was an unknown error.", ex); } return(result); }
/// <summary> /// Christian Lopez /// 2017/03/29 /// /// Creates an invoice and returns the id associated /// </summary> /// <param name="invoice"></param> /// <returns></returns> public int CreateSupplierInvoice(SupplierInvoice invoice) { int id = 1; try { id = SupplierInvoiceAccessor.CreateSupplierInvoice(invoice); if (id == 0) { // We were not able to capture the new id throw new ApplicationException("Unable to retrieve the new id number."); } } catch (SqlException ex) { throw new ApplicationException("There was a database error.", ex); } catch (Exception ex) { throw new ApplicationException("There was an unknown error.", ex); } return(id); }