private void restartControls() { btn_modificar.Enabled = false; // btn_Eliminar.Enabled = false; btn_Aprobar.Enabled = false; compraSelected = new orders(); // txtcliente.Text = ""; txtEmpleado.Text = ""; txtImpuestos.Text = ""; txtTotal.Text = ""; txttotalSinImpuesto.Text = ""; dtpfecha.Value = DateTime.Today; }
private void restartControls() { btnModify.Enabled = false; btnDelete.Enabled = false; btnApprove.Enabled = false; orderProducts = new List <orders_product>(); taxes = new List <tax>(); sellSelected = new orders(); txtCustomer.Text = ""; txtEmployee.Text = ""; txtTaxes.Text = ""; txtTotal.Text = ""; txtUntaxed.Text = ""; dtpDate.Value = DateTime.Today; }
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 dgvCompra_CellClick(object sender, DataGridViewCellEventArgs e) //Creo que aqui podria cargar la lsita de proveedor { try { compraSelected = compras.ElementAt <orders>(e.RowIndex); List <orders_tax> tax_order; List <tax> allTaxes; using (metaGamesInventoryAlterEntities DB = new metaGamesInventoryAlterEntities()) { orderProducts = DB.orders_product.ToList <orders_product>().Where(d => d.id_order == compraSelected.id).ToList <orders_product>(); tax_order = DB.orders_tax.ToList <orders_tax>().Where(d => d.id_order == compraSelected.id).ToList <orders_tax>(); allTaxes = DB.tax.ToList <tax>(); } taxes = new List <tax>(); foreach (var t in tax_order) { foreach (var tt in allTaxes) { if (t.id_tax == tt.id) { taxes.Add(tt); } } } refreshDGV(); fillTextBox(); if (compraSelected.order_state == "Borrador") { btn_modificar.Enabled = true; botoneliminar.Enabled = true; btn_Aprobar.Enabled = true; } else { btn_modificar.Enabled = false; btn_Aprobar.Enabled = false; botoneliminar.Enabled = false; } } catch { return; } }
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); } }
private void dgvSell_CellClick(object sender, DataGridViewCellEventArgs e) { try { sellSelected = sells.ElementAt <orders>(e.RowIndex); List <orders_tax> tax_order; List <tax> allTaxes; using (metaGamesInventoryAlterEntities DB = new metaGamesInventoryAlterEntities()) { orderProducts = DB.orders_product.ToList <orders_product>().Where(d => d.id_order == sellSelected.id).ToList <orders_product>(); tax_order = DB.orders_tax.ToList <orders_tax>().Where(d => d.id_order == sellSelected.id).ToList <orders_tax>(); allTaxes = DB.tax.ToList <tax>(); } taxes = new List <tax>(); foreach (var t in tax_order) { foreach (var tt in allTaxes) { if (t.id_tax == tt.id) { taxes.Add(tt); } } } refreshDGV(); fillTextBox(); if (sellSelected.order_state == "Borrador") { btnModify.Enabled = true; btnDelete.Enabled = true; btnApprove.Enabled = true; } } catch { return; } }