private void button3_Click(object sender, EventArgs e)
{
bool encontrecambios = false;
Conexion.abrir();
DataTable refresh = Conexion.Consultar("idarticulo,stockactual", "Articulos", "where eliminado != 'Eliminado'", "", new SqlCeCommand());
Conexion.cerrar();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string id = dataGridView1.Rows[i].Cells[0].Value.ToString();
for (int j = 0; j < refresh.Rows.Count; j++)
{
if (id == refresh.Rows[j][0].ToString())
{
//MessageBox.Show("encontre el id ahora me fijo si el stock cambió o no");
string stock = dataGridView1.Rows[i].Cells[5].Value.ToString();
int stockactual = int.Parse(stock);
int stockrefresh = int.Parse(refresh.Rows[j][1].ToString());
if (stockactual != stockrefresh)
{
dataGridView1.Rows[i].Cells[5].Value = stockrefresh.ToString();
dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
encontrecambios = true;
}
}
}
}
if (encontrecambios == true)
{
MessageBox.Show("Se encontraron cambios en el stock actual de productos, por favor revise las lineas de color amarillo y controle el stock nuevamente acorde al nuevo stock", "Se encontraron cambios", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
int rowIndex = dataGridView1.CurrentCell.RowIndex;
var row = this.dataGridView1.Rows[rowIndex];
string name = row.Cells[2].Value.ToString();
string id = row.Cells[0].Value.ToString();
DialogResult borrar = MessageBox.Show("Está seguro de borrar este artículo?\n" + name, "Borrar?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (borrar == DialogResult.Yes)
{
Conexion.abrir();
SqlCeCommand del = new SqlCeCommand();
del.Parameters.AddWithValue("@id", id);
del.Parameters.AddWithValue("@el", "Eliminado");
Conexion.Actualizar("Articulos", "eliminado = @el", "WHERE idarticulo = @id", "", del);
Conexion.cerrar();
}
getarts();
}
else
{
MessageBox.Show("No hay articulo seleccionado para borrar");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
int rowIndex = dataGridView1.CurrentCell.RowIndex;
var row = this.dataGridView1.Rows[rowIndex];
string name = row.Cells["Nombre Real"].Value.ToString();
string id = row.Cells["iduser"].Value.ToString();
string level = row.Cells["Jerarquía"].Value.ToString();
if (level != "Admin")
{
DialogResult borrar = MessageBox.Show("Está segudo de borrar este Usuario?\n" + name, "Borrar?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (borrar == DialogResult.Yes)
{
Conexion.abrir();
SqlCeCommand del = new SqlCeCommand();
del.Parameters.AddWithValue("@id", id);
del.Parameters.AddWithValue("@bo", "Eliminado");
Conexion.Actualizar("Usuarios", "eliminado = @bo", "WHERE iduser = @id", "", del);
this.Close();
CrearEmpleados showagn = new CrearEmpleados();
showagn.Show();
}
}
else
{
MessageBox.Show("Este usuario está protegido");
}
}
else
{
MessageBox.Show("No hay ningun usuario seleccionado para borrar");
}
}
private void closeturno(string id, string nombre)
{
SqlCeCommand cierro = new SqlCeCommand();
cierro.Parameters.AddWithValue("id", id);
cierro.Parameters.AddWithValue("ff", app.hoy + " " + DateTime.Now.ToShortTimeString());
string total = "";
Conexion.abrir();
SqlCeCommand paraeltotal = new SqlCeCommand();
paraeltotal.Parameters.Add("ven", nombre);
paraeltotal.Parameters.Add("fecA", app.hoy + " 00:00:00");
paraeltotal.Parameters.Add("fecB", app.hoy + " " + DateTime.Now.ToShortTimeString());
DataTable totalvendido = Conexion.Consultar("SUM(total)", "Ventas", "Where vendedor = @ven and estadoventa = 'Finalizado' and fechaventa between @fecA and @fecB", "", paraeltotal);
if (totalvendido.Rows.Count > 0)
{
try
{
total = float.Parse(totalvendido.Rows[0][0].ToString()).ToString();
}
catch (Exception)
{
total = "0";
}
cierro.Parameters.AddWithValue("tot", float.Parse(total));
Conexion.Actualizar("Turnos", "FechaFin = @ff, TotalVendido = @tot", "WHERE idturno = @id", "", cierro);
Conexion.Actualizar("Ventas", "estadoventa='Cerrado' ", "WHERE vendedor = @ven and fechaventa between @fecA and @fecB and estadoventa = 'Finalizado' ", "", paraeltotal);
Conexion.cerrar();
}
}
private void button2_Click(object sender, EventArgs e)
{
DialogResult seguro = MessageBox.Show("Está seguro de poner faltantes y sobrantes en cero?", "Seguro?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (seguro == DialogResult.Yes)
{
if (dataGridView1.Rows.Count > 0 && comboBox1.SelectedIndex >= 0)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
SqlCeCommand id = new SqlCeCommand();
id.Parameters.AddWithValue("id", dataGridView1.Rows[i].Cells[0].Value.ToString());
Conexion.abrir();
Conexion.Actualizar("Articulos", "faltante = '0', sobrante = '0'", "where idarticulo = @id", "", id);
Conexion.cerrar();
}
if (Application.OpenForms.OfType <DiferenciaStock>().Count() == 1)
{
Application.OpenForms.OfType <DiferenciaStock>().First().Close();
}
DiferenciaStock frm = new DiferenciaStock();
frm.Show();
frm.BringToFront();
}
else
{
MessageBox.Show("Debe elegir un provedor y asegurarse de que posea articulos");
}
}
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
SqlCeCommand dates = new SqlCeCommand();
dates.Parameters.AddWithValue("d2", Convert.ToDateTime(maskedTextBox1).Month);
dates.Parameters.AddWithValue("d3", Convert.ToDateTime(maskedTextBox1).Year);
Conexion.abrir();
DataTable showdebe = Conexion.Consultar("area as [Area], descripcion as Motivo, importe as Total", "Gastos", "WHERE DATEPART(month,fecha) = @d2 AND DATEPART(year,fecha) = @d3;", "", dates);
Conexion.cerrar();
if (showdebe.Rows.Count > 0)
{
float toto = 0;
for (int i = 0; i < showdebe.Rows.Count; i++)
{
toto += float.Parse(showdebe.Rows[i][2].ToString());
}
textBox3.Text = toto.ToString("$0.00");
}
else
{
float tot = 0;
textBox3.Text = tot.ToString("$0.00");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex >= 0 && textBox1.Text.Length > 0 && textBox2.Text.Length > 0)
{
string fechaingresada = maskedTextBox1.Text;
SqlCeCommand gasto = new SqlCeCommand();
gasto.Parameters.AddWithValue("fe", Convert.ToDateTime(fechaingresada + " 00:00:00"));
gasto.Parameters.AddWithValue("ti", comboBox1.SelectedItem.ToString());
gasto.Parameters.AddWithValue("mo", textBox1.Text);
gasto.Parameters.AddWithValue("im", textBox2.Text.Replace("$", ""));
Conexion.abrir();
Conexion.Insertar("Gastos", "fecha,area,descripcion,importe", "@fe,@ti,@mo,@im", gasto);
Conexion.cerrar();
if (Application.OpenForms.OfType <Gastos>().Count() == 1)
{
Application.OpenForms.OfType <Gastos>().First().Close();
}
Gastos frm = new Gastos();
frm.Show();
}
else
{
MessageBox.Show("Debe completar todos los datos para poder agregar el gasto");
}
}
private void NuevoCliente_Load(object sender, EventArgs e)
{
if (createorupdate.status == "update")
{
SqlCeCommand idprod = new SqlCeCommand();
idprod.Parameters.AddWithValue("id", createorupdate.itemid);
Conexion.abrir();
DataTable datosprod = Conexion.Consultar("*", "Clientes", "WHERE idcliente = @id", "", idprod);
Conexion.cerrar();
button1.Text = "Guardar cambios";
if (datosprod.Rows.Count > 0)
{
textBox2.Text = datosprod.Rows[0][1].ToString();
textBox3.Text = datosprod.Rows[0][2].ToString();
textBox4.Text = datosprod.Rows[0][3].ToString();
textBox5.Text = datosprod.Rows[0][4].ToString();
textBox6.Text = datosprod.Rows[0][5].ToString();
textBox7.Text = datosprod.Rows[0][6].ToString();
textBox8.Text = datosprod.Rows[0][7].ToString();
textBox9.Text = datosprod.Rows[0][8].ToString();
textBox1.Text = datosprod.Rows[0][9].ToString();
comboBox2.SelectedItem = datosprod.Rows[0][10].ToString();
}
}
}
private void Clientes_Load(object sender, EventArgs e)
{
this.Focus();
Conexion.abrir();
DataTable showacls = Conexion.Consultar("idcliente,nombre as [Nombre del cliente],atencion as [Atencion],direccion as Domicilio,telefono as Telefono,mail as Email, cuit as CUIT", "Clientes", "where eliminado != 'Eliminado'", "", new SqlCeCommand());
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showacls;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showacls;
dataGridView1.Columns[0].Visible = false;
dataGridView1.DataSource = SBind;
dataGridView1.Refresh();
if (showacls.Rows.Count > 0)
{
button2.Enabled = true;
button9.Enabled = true;
}
else
{
button2.Enabled = false;
button9.Enabled = false;
}
}
private void ControlStockVendedores_Load(object sender, EventArgs e)
{
Conexion.abrir();
DataTable arts = Conexion.Consultar("idarticulo,codigoart as [Codigo],descripcion as [Nombre],marca as [Marca],proveedor as [Proveedor],stockactual as [Stock]", "Articulos", "WHERE eliminado != 'Eliminado' and tipo LIKE 'Producto%'", "order by proveedor", new SqlCeCommand());
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = arts;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = arts;
dataGridView1.Columns[0].Visible = false;
dataGridView1.DataSource = SBind;
dataGridView1.Refresh();
dataGridView1.Columns.Add("stockreal", "[F2] StockReal");
foreach (DataGridViewColumn dc in dataGridView1.Columns)
{
if (dc.Index.Equals(6))
{
dc.ReadOnly = false;
}
else
{
dc.ReadOnly = true;
}
}
if (arts.Rows.Count < 1)
{
button2.Enabled = false;
}
}
private void Ventas_Load(object sender, EventArgs e)
{
totalventa.compraoventa = "ND";
if (dataGridView1.Rows.Count == 0)
{
float cero = 0;
textBox5.Text = cero.ToString("$0.00");
}
textBox3.Text = app.hoy;
Conexion.abrir();
DataTable nextid = new DataTable();
nextid = Conexion.Consultar("AUTOINC_NEXT", "INFORMATION_SCHEMA.COLUMNS", " WHERE (TABLE_NAME = 'NotaDebs') AND (COLUMN_NAME = 'idventa')", "", new SqlCeCommand());
Conexion.cerrar();
textBox1.Text = nextid.Rows[0][0].ToString();
totalventa.idnotadeb = Convert.ToInt32(nextid.Rows[0][0].ToString());
if (Demo.EsDemo == true)
{
textBox2.Text = Demo.demouser;
}
else
{
textBox2.Text = registereduser.reguser;
}
float idv = float.Parse(textBox1.Text);
if (idv >= 100 && Demo.EsDemo == true)
{
this.Close();
MessageBox.Show("Lo sentimos pero esta es la versión demo del producto y solo se permiten ingresar hasta 100 registros de venta. Si quiere habilitar esta opcion debe comprar la licencia.");
}
}
public static string getRegLicense()
{
Conexion.abrir();
DataTable license= Conexion.Consultar("NombreEmpresa","Configuracion","","",new SqlCeCommand());
Conexion.cerrar();
string reglicense = license.Rows[0][0].ToString();
return reglicense;
}
void getarts()
{
SqlCeCommand elim = new SqlCeCommand();
elim.Parameters.AddWithValue("el", "Eliminado");
Conexion.abrir();
DataTable showarts = Conexion.Consultar("idarticulo,codigoart as [Codigo prod.],descripcion as [Descripcion del Articulo],proveedor as Proveedor,precio as [Pr Venta],costo as [Pr Compra],stockactual as Stock,stockminimo as [Stock Minimo],iva as IVA", "Articulos", "WHERE eliminado != @el", "", elim);
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showarts;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showarts;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[4].DefaultCellStyle.Format = "c";
dataGridView1.Columns[5].DefaultCellStyle.Format = "c";
dataGridView1.DataSource = SBind;
dataGridView1.Refresh();
if (showarts.Rows.Count > 0)
{
label2.Visible = false; //sacamos label
dataGridView1.DataSource = showarts; //mostramos lo que hay
button2.Enabled = true;
button5.Enabled = true;
//button6.Enabled = true;
button9.Enabled = true;
Conexion.abrir();
DataTable valorizacion = Conexion.Consultar("precio,costo,stockactual", "Articulos", "WHERE eliminado != 'Eliminado'", "", new SqlCeCommand());
Conexion.cerrar();
float precio = 0;
float costo = 0;
for (int i = 0; i < valorizacion.Rows.Count; i++)
{
precio += float.Parse(valorizacion.Rows[i][0].ToString()) * float.Parse(valorizacion.Rows[i][2].ToString());
costo += float.Parse(valorizacion.Rows[i][1].ToString()) * float.Parse(valorizacion.Rows[i][2].ToString());
}
textBox3.Text = precio.ToString("$0.00");
textBox2.Text = costo.ToString("$0.00");
}
else
{
textBox2.Text = "$0.00";
textBox3.Text = "$0.00";
label2.Visible = true; //mostramos que no hay registros
button2.Enabled = false;
button9.Enabled = false;
button5.Enabled = false;
//button6.Enabled = false;
}
}
private void DiferenciaStock_Load(object sender, EventArgs e)
{
Conexion.abrir();
DataTable proveedores = Conexion.Consultar("nombre", "Proveedores", "WHERE Eliminado != 'Eliminado'", "", new SqlCeCommand());
Conexion.cerrar();
for (int i = 0; i < proveedores.Rows.Count; i++)
{
comboBox1.Items.Add(proveedores.Rows[i][0].ToString());
}
}
private void comboBox1_DropDown(object sender, EventArgs e)
{
comboBox1.Items.Clear();
Conexion.abrir();
DataTable rubros = Conexion.Consultar("nombrerubro", "Rubros", "where eliminado = 'Activo'", "", new SqlCeCommand());
Conexion.cerrar();
for (int i = 0; i < rubros.Rows.Count; i++)
{
comboBox1.Items.Add(rubros.Rows[i][0].ToString());
}
}
private void addturno(string user)
{
SqlCeCommand usr = new SqlCeCommand();
usr.Parameters.AddWithValue("u", user);
usr.Parameters.AddWithValue("fi", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString());
usr.Parameters.AddWithValue("tot", "0");
Conexion.abrir();
Conexion.Insertar("Turnos", "Usuario,FechaInicio,TotalVendido", "@u,@fi,@tot", usr);
Conexion.cerrar();
}
private void Consultas_Load(object sender, EventArgs e)
{
if (ConfigFiscal.usaImpFiscal == "no" || Demo.EsDemo == true)
{
this.Focus();
label1.Text = "Listado de Ventas de hoy";
Conexion.abrir();
SqlCeCommand fechahoy = new SqlCeCommand();
fechahoy.Parameters.AddWithValue("hoy", app.hoy);
if (Demo.EsDemo == true)
{
fechahoy.Parameters.AddWithValue("ven", Demo.demouser);
}
else
{
fechahoy.Parameters.AddWithValue("ven", registereduser.reguser);
}
fechahoy.Parameters.AddWithValue("anulada", "Anulada");
DataTable showv = new DataTable();
if (Demo.EsDemo == true || registereduser.level == "Admin" || registereduser.level == "Supervisor")
{
showv = Conexion.Consultar("nfactura as [N° Fact.], vendedor as Usuario, fechaventa as Fecha, total as Importe, estadoventa as Estado, tipoFactura as Factura", "Ventas", "WHERE datediff(day,fechaventa,@hoy) = 0 AND estadoventa = 'Finalizado' ", " order by nfactura desc", fechahoy);
}
else
{
showv = Conexion.Consultar("nfactura as [N° Fact.], vendedor as Usuario, fechaventa as Fecha, total as Importe, estadoventa as Estado, tipoFactura as Factura", "Ventas", "WHERE datediff(day,fechaventa,@hoy) = 0 AND estadoventa = 'Finalizado' and vendedor =@ven ", " order by nfactura desc", fechahoy);
}
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showv;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showv;
dataGridView1.DataSource = SBind;
dataGridView1.Columns[4].DefaultCellStyle.Format = "c";
dataGridView1.Refresh();
if (showv.Rows.Count > 0)
{
dataGridView1.DataSource = showv; //mostramos lo que hay
}
textBox1.Focus();
if (dataGridView1.Rows.Count < 1)
{
button2.Enabled = false;
}
}
else
{
MessageBox.Show("Solo se pueden anular ventas cuando el sistema no hace uso de la facturación fiscal");
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex >= 0)
{
SqlCeCommand saconombre = new SqlCeCommand();
saconombre.Parameters.AddWithValue("pr", comboBox1.SelectedItem.ToString());
Conexion.abrir();
Conexion.Actualizar("Configuracion", "nombreimpnofiscal = @pr", "", "", saconombre);
Conexion.cerrar();
ImpresionNOFISCAL.NONFISCALPRINTERNAME = comboBox1.SelectedItem.ToString();
MessageBox.Show("Impresora seleccionada:\n" + comboBox1.SelectedItem.ToString());
this.Close();
}
}
void vender()
{
//guardo en base de datos
SqlCeCommand item = new SqlCeCommand();
Conexion.abrir();
for (int i = 0; i < totalventa.detalle.Rows.Count; i++)
{
item.Parameters.Clear();
item.Parameters.AddWithValue("nf", totalventa.idventa);
item.Parameters.AddWithValue("idprod", totalventa.detalle.Rows[i][0].ToString());
item.Parameters.AddWithValue("cp", totalventa.detalle.Rows[i][2].ToString());
item.Parameters.AddWithValue("dp", totalventa.detalle.Rows[i][3].ToString());
item.Parameters.AddWithValue("mc", totalventa.detalle.Rows[i][4].ToString());
item.Parameters.AddWithValue("ca", totalventa.detalle.Rows[i][1].ToString());
item.Parameters.AddWithValue("pp", totalventa.detalle.Rows[i][5].ToString().Replace("$", ""));
item.Parameters.AddWithValue("to", totalventa.detalle.Rows[i][6].ToString().Replace("$", ""));
item.Parameters.AddWithValue("ti", totalventa.detalle.Rows[i][7].ToString().Replace("$", ""));
string prodser = totalventa.detalle.Rows[i][7].ToString();
Conexion.Insertar("DetalleVentas", "nfactura,idproducto, codigoproducto , descripproducto, marcaproducto, cantidproducto, precioproducto, totalproducto,tipo", "@nf,@idprod,@cp,@dp,@mc,@ca,@pp,@to,@ti", item);
if (prodser.Contains("Producto"))
{
Conexion.Actualizar("Articulos", "stockactual = stockactual - @ca", "WHERE idarticulo = @idprod", "", item);
}
}
if (Demo.EsDemo == true)
{
item.Parameters.AddWithValue("ve", Demo.demouser);
}
else
{
item.Parameters.AddWithValue("ve", registereduser.reguser);
}
if (Demo.EsDemo == true)
{
item.Parameters.AddWithValue("fv", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString());
}
else
{
item.Parameters.AddWithValue("fv", app.hoy + " " + DateTime.Now.ToShortTimeString());
}
item.Parameters.AddWithValue("tt", totalventa.totventa.Replace("$", ""));
item.Parameters.AddWithValue("ev", "Finalizado");
item.Parameters.AddWithValue("tf", "FC");
Conexion.Insertar("Ventas", "nfactura, vendedor, fechaventa, total , estadoventa , tipoFactura ", "@nf,@ve,@fv,@tt,@ev,@tf", item);
Conexion.cerrar();
this.Close();
}
private void cargadata()
{
if (Demo.EsDemo == false)
{
Conexion.abrir();
DataTable datos = Conexion.Consultar("*", "Configuracion", "", "", new SqlCeCommand());
Conexion.cerrar();
if (datos.Rows.Count > 0)
{
textBox1.Text = datos.Rows[0][2].ToString();
textBox2.Text = datos.Rows[0][3].ToString();
textBox3.Text = datos.Rows[0][4].ToString();
textBox4.Text = datos.Rows[0][5].ToString();
textBox5.Text = datos.Rows[0][6].ToString();
textBox6.Text = datos.Rows[0][8].ToString();
textBox7.Text = float.Parse(datos.Rows[0][0].ToString()).ToString("$0.00");
textBox14.Text = datos.Rows[0][17].ToString();
textBox13.Text = datos.Rows[0][18].ToString();
textBox12.Text = datos.Rows[0][19].ToString();
textBox11.Text = datos.Rows[0][20].ToString();
textBox10.Text = datos.Rows[0][21].ToString();
textBox9.Text = datos.Rows[0][22].ToString();
textBox8.Text = datos.Rows[0][23].ToString();
textBox16.Text = datos.Rows[0][24].ToString();
numericUpDown1.Value = decimal.Parse(datos.Rows[0][27].ToString());
if (datos.Rows[0][28].ToString() == "si")
{
checkBox1.Checked = true;
}
if (datos.Rows[0][29].ToString() == "si")
{
checkBox2.Checked = true;
}
if (datos.Rows[0][30].ToString() == "si")
{
checkBox3.Checked = true;
}
if (datos.Rows[0][31].ToString() == "si")
{
checkBox4.Checked = true;
}
}
}
else
{
MessageBox.Show("Esta opcion es para usuarios de licencia solamente");
this.Close();
}
}
private void IngreseFecha_Load(object sender, EventArgs e)
{
Conexion.abrir();
DataTable fechasdb = Conexion.Consultar("ultimafechatrabajo", "Configuracion", "", "", new SqlCeCommand());
Conexion.cerrar();
ulfecha = fechasdb.Rows[0][0].ToString();
if (ulfecha.Length < 1)
{
ulfecha = DateTime.Now.ToShortDateString();
}
label3.Text = "Ultima fecha de trabajo: " + Convert.ToDateTime(ulfecha).ToShortDateString();
maskedTextBox1.Text = Convert.ToDateTime(ulfecha).ToShortDateString();
}
void getdebehaber()
{
SqlCeCommand dates = new SqlCeCommand();
dates.Parameters.Clear();
dates.Parameters.AddWithValue("d1", Convert.ToDateTime(maskedTextBox1.Text + " 00:00:00"));
dates.Parameters.AddWithValue("d2", Convert.ToDateTime(maskedTextBox2.Text + " 23:59:59"));
dates.Parameters.AddWithValue("an", "Anulada");
Conexion.abrir();
DataTable showdebe = Conexion.Consultar("area as [Tipo], descripcion as Motivo, importe as Total", "Gastos", "WHERE fecha BETWEEN @d1 AND @d2;", "", dates);
DataTable showhaber = Conexion.Consultar("tipoFactura as [Tipo], nfactura as [N°] ,total as [Importe]", "Ventas", " WHERE estadoventa != @an AND fechaventa BETWEEN @d1 AND @d2 ;", "", dates);
DataTable addIngresos = Conexion.Consultar("tipo,motivo,total", "EntradaCaja", "WHERE fecha BETWEEN @d1 AND @d2;", "", dates);
DataTable addSalidas = Conexion.Consultar("tipo,motivo,total", "SalidaCaja", " WHERE fecha BETWEEN @d1 AND @d2;", "", dates);
Conexion.cerrar();
for (int i = 0; i < addIngresos.Rows.Count; i++)
{
string tipo = addIngresos.Rows[i][0].ToString();
string motivo = addIngresos.Rows[i][1].ToString();
string importe = addIngresos.Rows[i][2].ToString();
showhaber.Rows.Add(tipo + "(" + motivo + ")", 0, importe);
}
BindingSource SBind = new BindingSource();
SBind.DataSource = showhaber;
dataGridView2.AutoGenerateColumns = true;
dataGridView2.DataSource = showhaber;
dataGridView2.Columns[2].DefaultCellStyle.Format = "c";
dataGridView2.DataSource = SBind;
dataGridView2.Refresh();
for (int i = 0; i < addSalidas.Rows.Count; i++)
{
string tipo = addSalidas.Rows[i][0].ToString();
string motivo = addSalidas.Rows[i][1].ToString();
float importe = float.Parse(addSalidas.Rows[i][2].ToString());
showdebe.Rows.Add(tipo, motivo, importe.ToString("0.00"));
}
BindingSource SBind2 = new BindingSource();
SBind2.DataSource = showdebe;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showdebe;
dataGridView1.Columns[2].DefaultCellStyle.Format = "c";
dataGridView1.DataSource = SBind2;
dataGridView1.Refresh();
}
void getarts(string prov)
{
float faltante, sobrante, diferencia;
Conexion.abrir();
SqlCeCommand proveedor = new SqlCeCommand();
proveedor.Parameters.AddWithValue("pr", prov);
DataTable showarts = Conexion.Consultar("idarticulo,descripcion as [Descripcion del Articulo],proveedor as Proveedor,precio as Precio,costo as Costo,stockactual as Stock,faltante as [Faltante],sobrante as Sobrante", "Articulos", " WHERE proveedor = @pr and eliminado != 'Eliminado' and tipo LIKE 'Producto%'", "", proveedor);
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showarts;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showarts;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[3].DefaultCellStyle.Format = "c";
dataGridView1.Columns[4].DefaultCellStyle.Format = "c";
dataGridView1.DataSource = SBind;
dataGridView1.Refresh();
if (showarts.Rows.Count > 0)
{
button2.Enabled = true; //mostramos que no hay registros
button1.Enabled = true;
float tsob, tfal;
sobrante = 0;
faltante = 0;
tsob = 0;
tfal = 0;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
tfal += float.Parse(dataGridView1.Rows[i].Cells[3].Value.ToString().Replace("$", "")) * int.Parse(dataGridView1.Rows[i].Cells[6].Value.ToString());
tsob += float.Parse(dataGridView1.Rows[i].Cells[3].Value.ToString().Replace("$", "")) * int.Parse(dataGridView1.Rows[i].Cells[7].Value.ToString());
}
textBox1.Text = tfal.ToString("$0.00");
textBox2.Text = tsob.ToString("$0.00");
textBox3.Text = (tsob - tfal).ToString("$0.00");
}
else
{
button2.Enabled = false; //mostramos que no hay registros
button1.Enabled = false;
faltante = 0;
sobrante = 0;
diferencia = faltante - sobrante;
}
}
private void textBox1_Leave(object sender, EventArgs e)
{
if (textBox1.Text.Length > 0)
{
SqlCeCommand checkexistance = new SqlCeCommand();
checkexistance.Parameters.AddWithValue("code", textBox1.Text);
Conexion.abrir();
DataTable existira = Conexion.Consultar("login", "Usuarios", "where login = @code and eliminado != 'Eliminado'", "", checkexistance);
Conexion.cerrar();
if (existira.Rows.Count > 0 && createorupdate.status == "create")
{
MessageBox.Show("Ese usuario ya existe, use otro nombre de usuario por favor");
textBox1.Text = "";
}
}
}
private void Clientes_Load(object sender, EventArgs e)
{
this.Focus();
Conexion.abrir();
DataTable showacls = Conexion.Consultar("idab,fecha as Fecha,codigo as Codigo,descripcion as Descripcion,altas as Altas,bajas as Bajas,motivo as Motivo,vendedor as Vendedor", "Altasbajas", "", "", new SqlCeCommand());
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showacls;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showacls;
dataGridView1.Columns[0].Visible = false;
dataGridView1.DataSource = SBind;
dataGridView1.Refresh();
}
private void textBox1_Leave(object sender, EventArgs e)
{
if (textBox1.Text.Length > 0 && createorupdate.status == "create")
{
SqlCeCommand existe = new SqlCeCommand();
existe.Parameters.AddWithValue("cuitx", textBox1.Text);
Conexion.abrir();
DataTable existira = Conexion.Consultar("numcuit", "Proveedores", "Where numcuit = @cuitx", "", existe);
Conexion.cerrar();
if (existira.Rows.Count > 0)
{
MessageBox.Show("Ese CUIT de proveedor ya existe, no se admiten clientes duplicados en el sistema.");
textBox1.Text = "";
textBox1.Focus();
}
}
}
private void textBox2_Leave(object sender, EventArgs e)
{
if (textBox2.Text.Length > 0 && createorupdate.status == "create")
{
SqlCeCommand existe = new SqlCeCommand();
existe.Parameters.AddWithValue("nombrex", textBox2.Text);
Conexion.abrir();
DataTable existira = Conexion.Consultar("nombre", "Proveedores", "Where nombre = @nombrex and Eliminado != 'Eliminado'", "", existe);
Conexion.cerrar();
if (existira.Rows.Count > 0)
{
MessageBox.Show("Ese nombre de proveedor ya existe, intente con otro nombre");
textBox2.Text = "";
textBox2.Focus();
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
int rowIndex = dataGridView1.CurrentCell.RowIndex;
var row = this.dataGridView1.Rows[rowIndex];
string name = row.Cells["Nombre del cliente"].Value.ToString();
string id = row.Cells["idcliente"].Value.ToString();
DialogResult borrar = MessageBox.Show("Está seguro de borrar este Cliente?\n" + name, "Borrar?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (borrar == DialogResult.Yes)
{
Conexion.abrir();
SqlCeCommand del = new SqlCeCommand();
del.Parameters.AddWithValue("@id", id);
del.Parameters.AddWithValue("@el", "Eliminado");
//Conexion.Eliminar("Clientes", "idcliente = @id", del);
Conexion.Actualizar("Clientes", "eliminado = @el", "where idcliente = @id", "", del);
Conexion.abrir();
DataTable showacls = Conexion.Consultar("idcliente,nombre as [Nombre del cliente],atencion as [Atencion],direccion as Domicilio,telefono as Telefono,mail as Email, cuit as CUIT", "Clientes", "where eliminado != 'Eliminado'", "", new SqlCeCommand());
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showacls;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = showacls;
dataGridView1.Columns[0].Visible = false;
dataGridView1.DataSource = SBind;
dataGridView1.Refresh();
if (showacls.Rows.Count > 0)
{
button2.Enabled = true;
button9.Enabled = true;
}
else
{
button2.Enabled = false;
button9.Enabled = false;
}
}
}
else
{
MessageBox.Show("No hay ningun cliente seleccionado para borrar");
}
}
private void NuevoProveedor_Load(object sender, EventArgs e)
{
if (createorupdate.status == "create")
{
comboBox1.Items.Clear();
Conexion.abrir();
DataTable rubros = Conexion.Consultar("nombrerubro", "Rubros", "where eliminado = 'Activo'", "", new SqlCeCommand());
Conexion.cerrar();
for (int i = 0; i < rubros.Rows.Count; i++)
{
comboBox1.Items.Add(rubros.Rows[i][0].ToString());
}
}
if (createorupdate.status == "update")
{
comboBox1.Items.Clear();
button1.Text = "Guardar cambios";
SqlCeCommand id = new SqlCeCommand();
id.Parameters.AddWithValue("id", createorupdate.itemid);
Conexion.abrir();
DataTable data = Conexion.Consultar("*", "Proveedores", "WHERE idproveedor = @id", "", id);
DataTable rubros = Conexion.Consultar("nombrerubro", "Rubros", "where eliminado = 'Activo'", "", new SqlCeCommand());
Conexion.cerrar();
for (int i = 0; i < rubros.Rows.Count; i++)
{
comboBox1.Items.Add(rubros.Rows[i][0].ToString());
}
if (data.Rows.Count > 0)
{
textBox2.Text = data.Rows[0][1].ToString(); //nombre
textBox3.Text = data.Rows[0][3].ToString(); //atenc
comboBox1.SelectedItem = data.Rows[0][2].ToString(); //rubro
textBox4.Text = data.Rows[0][4].ToString(); //direc
textBox5.Text = data.Rows[0][5].ToString(); //locali
textBox6.Text = data.Rows[0][6].ToString(); //prov
textBox7.Text = data.Rows[0][11].ToString(); //cp
textBox8.Text = data.Rows[0][7].ToString(); //tel
textBox9.Text = data.Rows[0][8].ToString(); //email
textBox1.Text = data.Rows[0][10].ToString(); //cuitno
comboBox2.SelectedItem = data.Rows[0][9].ToString(); //cuittype
nombreviejo = textBox2.Text;
}
}
}
void get(string what1, string fromwhere1, string where, string valuedata, DataGridView whatview1)
{
Conexion.abrir();
DataTable showv = Conexion.Consultar(what1, fromwhere1, where, "", new SqlCeCommand());
Conexion.cerrar();
BindingSource SBind = new BindingSource();
SBind.DataSource = showv;
whatview1.AutoGenerateColumns = true;
whatview1.DataSource = showv;
whatview1.DataSource = SBind;
//whatview1.Columns[3].DefaultCellStyle.Format = "c";
whatview1.Refresh();
if (showv.Rows.Count > 0)
{
whatview1.DataSource = showv; //mostramos lo que hay
}
}
