private void modifyOrder()
{
using (metaGamesInventoryAlterEntities DB = new metaGamesInventoryAlterEntities())
{
orderToModify.order_date = dtpSellDate.Value;
orderToModify.amount_untaxed = double.Parse(txtUntaxed.Text);
orderToModify.amount_tax = double.Parse(txtTaxes.Text);
orderToModify.amount_total = double.Parse(txtTotal.Text);
orderToModify.transaction_type = "Venta";
orderToModify.order_state = "Borrador";
orderToModify.third = txtCustomer.Text;
//Reemplazar con el id del empleado logeado
orderToModify.id_employee = 6;
DB.Entry(orderToModify).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
List <orders_product> dborders = DB.orders_product.ToList <orders_product>().Where(d => d.id_order == orderToModify.id).ToList <orders_product>();
List <orders_tax> orderTaxesRegisted = DB.orders_tax.ToList <orders_tax>().Where(d => d.id_order == orderToModify.id).ToList <orders_tax>();
foreach (var h in dborders)
{
DB.Entry(h).State = System.Data.Entity.EntityState.Deleted;
}
foreach (var h in orderTaxesRegisted)
{
DB.Entry(h).State = System.Data.Entity.EntityState.Deleted;
}
DB.SaveChanges();
foreach (var op in order)
{
op.id_order = orderToModify.id;
DB.orders_product.Add(op);
}
foreach (var t in taxesSelected)
{
orders_tax g = new orders_tax();
g.id_order = orderToModify.id;
g.id_tax = t.id;
DB.orders_tax.Add(g);
}
DB.SaveChanges();
MessageBox.Show("Venta fue modificada exitoxamente.", "Venta modificada", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void createCompra()
{
using (metaGamesInventoryAlterEntities DB = new metaGamesInventoryAlterEntities())
{
orders oc = new orders();
oc.order_date = dtpfecha.Value;
oc.amount_untaxed = double.Parse(txttotalsinimp.Text);
oc.amount_tax = double.Parse(txtimpuesto.Text);
oc.amount_total = double.Parse(txttotal.Text);
oc.transaction_type = "Compra";
oc.order_state = "Borrador";
// oc.third = txtcliente.Text; //aqui se debe guardar el provedor
//Reemplazar con el id del empleado logeado
oc.id_employee = 7;
//-----------------------
//-----------------------
DB.orders.Add(oc);
DB.SaveChanges();
oc = DB.orders.ToList <orders>().Last();
foreach (var op in order)
{
op.id_order = oc.id;
DB.orders_product.Add(op);
}
foreach (var t in taxesSelected)
{
orders_tax g = new orders_tax();
g.id_order = oc.id;
g.id_tax = t.id;
DB.orders_tax.Add(g);
}
DB.SaveChanges();
MessageBox.Show("Compra registrada exitoxamente en estado borrador.", "Compra registrada", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void createSell()
{
using (metaGamesInventoryAlterEntities DB = new metaGamesInventoryAlterEntities())
{
orders o = new orders();
o.order_date = dtpSellDate.Value;
o.amount_untaxed = double.Parse(txtUntaxed.Text);
o.amount_tax = double.Parse(txtTaxes.Text);
o.amount_total = double.Parse(txtTotal.Text);
o.transaction_type = "Venta";
o.order_state = "Borrador";
o.third = txtCustomer.Text;
//Reemplazar con el id del empleado logeado
o.id_employee = 6;
DB.orders.Add(o);
DB.SaveChanges();
o = DB.orders.ToList <orders>().Last();
foreach (var op in order)
{
op.id_order = o.id;
DB.orders_product.Add(op);
}
foreach (var t in taxesSelected)
{
orders_tax g = new orders_tax();
g.id_order = o.id;
g.id_tax = t.id;
DB.orders_tax.Add(g);
}
DB.SaveChanges();
MessageBox.Show("Venta registrada exitoxamente en estado borrador.", "Venta registrada", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
