public Task <Common.Entity.Result <int> > Update(Common.Entity.Client client)
{
Common.Entity.Result <int> result = new Common.Entity.Result <int> {
};
try
{
using (var context = new BillingContext())
{
////truncate table
context.Client.RemoveRange(context.Client);
Log.Info($"Commercial transactions have been deleted in the database....");
////insert new values
context.Client.Add(client);
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));
}
/// <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 <bool> > Insert(IEnumerable <Common.Entity.InvoiceDetail> invoiceDetail)
{
Common.Entity.Result <bool> result = new Common.Entity.Result <bool> {
};
try
{
invoiceDetail.ToList().ForEach(detail =>
{
using (var context = new BillingContext())
{
//var IdInvoice = new System.Data.SqlClient.SqlParameter("@IdInvoice", 1);
//var RegistrationDate = new System.Data.SqlClient.SqlParameter("@RegistrationDate", DateTime.Now);
//var Unit = new System.Data.SqlClient.SqlParameter("@Unit", 1);
//var IdProduct = new System.Data.SqlClient.SqlParameter("@IdProduct",1);
var res = context.Database.SqlQuery <int>("exec sp_InsertInvoiceDetail @IdInvoice , @RegistrationDate , @Unit , @IdProduct",
new System.Data.SqlClient.SqlParameter("@IdInvoice", detail.IdInvoice),
new System.Data.SqlClient.SqlParameter("@RegistrationDate", detail.RegistrationDate),
new System.Data.SqlClient.SqlParameter("@Unit", detail.Unit),
new System.Data.SqlClient.SqlParameter("@IdProduct", detail.Product.IdProduct)
).SingleOrDefault();
}
});
result.StatusCode = System.Net.HttpStatusCode.OK;
result.Data = true;;
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));
}
public Task <Common.Entity.Result <IEnumerable <Common.Entity.Product> > > Get()
{
Common.Entity.Result <IEnumerable <Common.Entity.Product> > result = new Common.Entity.Result <IEnumerable <Common.Entity.Product> > {
};
using (var context = new BillingContext())
{
result.Data = context.Product.ToList();
}
return(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));
}
