public Task <Common.Entity.Result <bool> > Update(Common.Entity.Invoice invoice) { Common.Entity.Result <bool> result = new Common.Entity.Result <bool> { }; try { using (var context = new BillingContext()) { ////truncate table context.Invoice.RemoveRange(context.Invoice); Log.Info($"Commercial transactions have been deleted in the database...."); ////insert new values context.Invoice.Add(invoice); context.SaveChanges(); Log.Info($"new transactions were inserted...."); } } catch (Exception ex) { result.StatusCode = System.Net.HttpStatusCode.InternalServerError; Log.Exception(ex, $"{GetType().FullName}.Update"); } return(Task.FromResult(result)); }
public async Task <Common.Entity.Result <int> > Insert(Common.Entity.Invoice invoice) { Common.Entity.Result <int> result = new Common.Entity.Result <int> { }; try { result = await InvoiceService.Insert(invoice); } catch (Exception ex) { result.StatusCode = System.Net.HttpStatusCode.InternalServerError; Log.Exception(ex, $"{GetType().FullName}.Insert"); } return(await Task.FromResult(result)); }
/// <summary> /// Save commercial transactions to repository /// </summary> /// <param name="commercialTransactions"><see cref="Common.Entity.Invoice"/></param> /// <returns>bool confirmation</returns> /// <history> /// Version Author Date Description /// 1.0.0.0 David Vanegas 27/11/2021 Creation /// </history> public Task <Common.Entity.Result <int> > Insert(Common.Entity.Invoice invoices) { Common.Entity.Result <int> result = new Common.Entity.Result <int> { }; try { using (var context = new BillingContext()) { result.Data = context.Database.SqlQuery <int>("exec sp_InsertInvoice @RegistrationDate , @Total , @Iva , @IdClient", new SqlParameter("@RegistrationDate", DateTime.Now), new SqlParameter("@Total", invoices.Total), new SqlParameter("@Iva", invoices.Iva), new SqlParameter("@IdClient", invoices.Client.IdClient)).SingleOrDefault(); result.StatusCode = System.Net.HttpStatusCode.OK; Log.Info($"new transactions were inserted...."); } } catch (Exception ex) { result.StatusCode = System.Net.HttpStatusCode.InternalServerError; Log.Exception(ex, $"{GetType().FullName}.Insert"); } return(Task.FromResult(result)); }
// POST: api/invoice public async Task <IHttpActionResult> Post(Common.Entity.Invoice invoice) { var response = await InvoiceService.Insert(invoice); return(Content(response.StatusCode, response.Data)); }