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); } }