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