/// <summary> /// Find matching PO number from database /// </summary> /// <param name="PONumber">a string parameter</param> /// <returns>return a model</returns> public POViwerModel GetPODocument(string PONumber) { POViwerModel po = _db.InvoiceDocuments .Where(w => w.invoice_PO == PONumber) .Select(x => new POViwerModel { PONumber = x.invoice_PO, InvoiceID = x.invoice_id, InvoiceMIME = x.invoice_MIME, InvoiceDocument = x.invoice_document, }).FirstOrDefault(); return(po); }
public ActionResult Index(POViwerModel model) { if (ModelState.IsValid) { POViewerServices PSvc = new POViewerServices(); model = PSvc.GetPODocument(model.PONumber); if (model == null) { ModelState.AddModelError("PONumber", "Purchase order not found or matched"); return(View("Index", model)); } } return(View("Index", model)); }
/// <summary> /// Get purchase order /// </summary> /// <param name="PONumber">a string parameter</param> /// <returns>return purchase order file</returns> public ActionResult GetPOFile(string PONumber) { POViwerModel POViewModel = new POViwerModel(); try { POViewerServices PSvc = new POViewerServices(); POViewModel = PSvc.GetPODocument(PONumber); if (POViewModel.InvoiceDocument.Length > 0) { return(File(POViewModel.InvoiceDocument, POViewModel.InvoiceMIME)); } } catch (Exception ex) { Console.Write(ex); } return(View("Index", POViewModel)); }