public IActionResult Add(SaleRequest model)
{
var response = new Response();
try
{
using var db = new salesSystemContext();
using var transaction = db.Database.BeginTransaction();
try
{
var sale = new Models.Sale
{
Total = model.Concepts.Sum(d => d.Amount * d.PriceUnit),
CreatedAt = DateTime.Now,
FkClientId = model.IdClient
};
db.Sales.Add(sale);
db.SaveChanges();
foreach (var concept in model.Concepts.Select(rowConcept => new Concept
{
FkProductId = rowConcept.IdProduct,
PriceUnit = rowConcept.PriceUnit,
Amount = rowConcept.Amount,
Total = rowConcept.Total,
FkSaleId = sale.Id
}))
{
db.Concepts.Add(concept);
db.SaveChanges();
}
response.Success = true;
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine(e);
transaction.Rollback();
}
}
catch (Exception e)
{
Console.WriteLine(e);
response.Message = e.Message;
return(BadRequest(response));
}
return(Ok(response));
}
public void Remove(long id)
{
using var db = new salesSystemContext();
var business = db.Businesses.Find(id);
business.DeletedAt = DateTime.Now;
db.Entry(business).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
public void Remove(long id)
{
using var db = new salesSystemContext();
var client = db.Clients.Find(id);
client.DeletedAt = DateTime.Now;
db.Entry(client).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
public void Update(BusinessUpdateRequest model)
{
using var db = new salesSystemContext();
var business = db.Businesses.Find(model.Id);
business.Address = model.Address;
business.BusinessName = model.BusinessName;
db.Entry(business).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
public void Create(ClientCreateRequest model)
{
using var db = new salesSystemContext();
var client = new Models.Client()
{
ClientName = model.Name
};
db.Clients.Add(client);
db.SaveChanges();
}
public void Update(ClientUpdateRequest model)
{
using var db = new salesSystemContext();
var client = db.Clients.Find(model.Id);
// product.UpdatedAt = DateTime.Now;
client.ClientName = model.Name;
client.UpdatedAt = DateTime.Now;
db.Entry(client).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
public void Update(SuppliersUpdateRequest model)
{
using var db = new salesSystemContext();
var supplier = db.Suppliers.Find(model.Id);
supplier.Email = model.Email;
supplier.SupplierName = model.SupplierName;
supplier.Phone = model.Phone;
supplier.UpdatedAt = DateTime.Now;
db.Entry(supplier).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
public void Create(BusinessCreateRequest model)
{
using var db = new salesSystemContext();
var business = new Models.Business
{
Address = model.Address,
BusinessName = model.BusinessName,
FkUserId = model.FkUserId
};
db.Businesses.Add(business);
db.SaveChanges();
}
public void Create(ProductCreateRequest model)
{
using var db = new salesSystemContext();
var product = new Models.Product()
{
Amount = model.Amount,
Description = model.Description,
ProductName = model.ProductName,
UnitPrice = model.UnitPrice
};
db.Products.Add(product);
db.SaveChanges();
}
public void Update(ProductUpdateRequest model)
{
using var db = new salesSystemContext();
var product = db.Products.Find(model.Id);
// product.UpdatedAt = DateTime.Now;
product.Amount = model.Amount;
product.Description = model.Description;
product.ProductName = model.ProductName;
product.UnitPrice = model.UnitPrice;
product.UpdatedAt = DateTime.Now;
db.Entry(product).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
public void Create(SuppliersCreateRequest model)
{
using var db = new salesSystemContext();
var supplier = new Supplier()
{
Email = model.Email,
Phone = model.Phone,
SupplierName = model.SupplierName,
FkUserId = model.FkUserId
};
db.Suppliers.Add(supplier);
db.SaveChanges();
}