public HttpResponseMessage PostAPCAInvoice(string recordnumber, string invoicedate, string invoicenumber, string vendornumber, string vendorname, string ponumber, string invoicetypecd) { try { if (!String.IsNullOrEmpty(recordnumber)) { if (db.APCAInvoices.Count(x => x.Record_Number == recordnumber) > 0) { return Request.CreateResponse(HttpStatusCode.Conflict); } var apcainvoicerecord = new APCAInvoice { Record_Number = recordnumber, Invoice_Date = Convert.ToDateTime(invoicedate), Invoice_Number = invoicenumber, Vendor_Number = vendornumber, Vendor_Name = vendorname, PO_Number = ponumber, Invoice_Type_cd = invoicetypecd }; db.APCAInvoices.Add(apcainvoicerecord); db.SaveChanges(); return Request.CreateResponse<APCAInvoice>(HttpStatusCode.Created, apcainvoicerecord); } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } } catch (Exception ex) { throw new HttpResponseException(HttpStatusCode.InternalServerError); } }
public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } APCAInvoice apinvoice = await db.APCAInvoices.FindAsync(id); if (apinvoice == null) { return(HttpNotFound()); } return(View(apinvoice)); }
public async Task <ActionResult> DeleteConfirmed(int id) { APCAInvoice apinvoice = await db.APCAInvoices.FindAsync(id); // Delete blob CloudStorageAccount storageAccount = CloudStorageAccount.Parse( ConfigurationManager.ConnectionStrings["APStorageConnectionString"].ConnectionString); String containerName = ConfigurationManager.ConnectionStrings["APContainerConnectionString"].ConnectionString; // Create the blob client. CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); CloudBlobContainer container = blobClient.GetContainerReference(containerName); // Retrieve reference to a blob named blobName CloudBlockBlob blockBlob = container.GetBlockBlobReference(apinvoice.Record_Number.Trim()); blockBlob.DeleteIfExists(); db.APCAInvoices.Remove(apinvoice); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }