public void Insert(Tables.Client client, DateTime date, decimal totalBruto, decimal desconto, decimal total, string pagamento, ObservableCollection <Item> items)
{
Tables.Sale sale = new Tables.Sale(date, totalBruto, desconto, total, pagamento);
con.Sales.Add(sale);
con.SaveChanges();
int saleId = con.Sales.Max(x => x.Id);
con.SaleDeliveries.Add(new Tables.SaleDelivery(saleId, client.Name, client.Street + ", Nº" + client.Number + ", " + client.District + ", " + client.Complement));
con.SaveChanges();
for (int i = 0; i < items.Count; i++)
{
items[i].Name = new Product().GetProduct(items[i].Id).Name;
for (int j = i + 1; j < items.Count; j++)
{
if (items[i].Id == items[j].Id)
{
items[i].Quantity += items[j].Quantity;
items.RemoveAt(j);
j--;
}
}
}
foreach (Item it in items)
{
Tables.ProductSale productSale = new Tables.ProductSale(saleId, it.Id, it.Name, it.Price, it.Quantity, it.Total);
con.ProductSales.Add(productSale);
}
con.SaveChanges();
}
public void Insert(DateTime date, decimal totalBruto, decimal desconto, decimal total, string pagamento, ObservableCollection <Item> items)
{
Tables.Sale sale = new Tables.Sale(date, totalBruto, desconto, total, pagamento);
con.Sales.Add(sale);
con.SaveChanges();
int saleId = con.Sales.Max(x => x.Id);
con.SaleTables.Add(new Tables.SaleTable(saleId, -1));
con.SaveChanges();
foreach (Item it in items)
{
Tables.ProductSale productSale = new Tables.ProductSale(saleId, it.Id, it.Name, it.Price, it.Quantity, it.Total);
con.ProductSales.Add(productSale);
}
con.SaveChanges();
}
