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