private void cmbDepartamento_SelectionChangeCommitted_1(object sender, EventArgs e) { int indice = int.Parse(cmbDepartamento.SelectedItem.ToString().Substring(0, 1)); using (abcEntities db = new abcEntities()) { string numero; string nombre; var lstClase = from d in db.Clase select d; cmbClase.Items.Clear(); foreach (var element in lstClase) { if (element.IdDepartamento == indice) { numero = element.IdClase.ToString(); nombre = element.NombreClase; cmbClase.Items.Add(numero + " - " + nombre); } } } cmbClase.Enabled = true; }
private void cmbOptions_SelectionChangeCommitted(object sender, EventArgs e) { pnlSku.Visible = false; pnlArticulo.Visible = false; pnlDCF.Visible = false; switch (cmbOptions.SelectedItem) { case "Sku": pnlSku.Visible = true; break; case "Articulo": pnlArticulo.Visible = true; break; case "DCF": pnlDCF.Visible = true; using (abcEntities db = new abcEntities()) { string numero; string nombre; var lst = from d in db.Departamento select d; cmbDepartamento.Items.Clear(); foreach (var element in lst) { numero = element.IdDepartamento.ToString(); nombre = element.NombreDepartamento; cmbDepartamento.Items.Add(numero + "-" + nombre); } }; break; } }
private void cmbClase_SelectionChangeCommitted(object sender, EventArgs e) { int indice = int.Parse(cmbClase.SelectedItem.ToString().Substring(0, 1)); int indice2 = int.Parse(cmbDepartamento.SelectedItem.ToString().Substring(0, 1)); using (abcEntities db = new abcEntities()) { string numero; string nombre; var lstClase = from d in db.Familia select d; cmbFamilia.Items.Clear(); foreach (var element in lstClase) { if (element.IdClase == indice && element.IdDepartamento == indice2) { numero = element.IdFamilia; nombre = element.NombreFamilia; cmbFamilia.Items.Add(numero + " - " + nombre); } } var lst = from d in db.ABCC.Where(p => p.Departamento.ToString().Contains(indice2.ToString()) && p.Clase.ToString().Contains(indice.ToString())) select d; dataGridView1.DataSource = lst.ToList(); EstiloFila(dataGridView1); } cmbFamilia.Enabled = true; }
private void btnEditar_Click(object sender, EventArgs e) { txtArticulo.Enabled = true; txtMarca.Enabled = true; txtModelo.Enabled = true; cmbDepartamento.Enabled = true; txtCantidad.Enabled = true; txtStock.Enabled = true; btnAceptar.Enabled = true; cbxDescontinuado.Enabled = true; using (abcEntities db = new abcEntities()) { string numero; string nombre; var lst2 = from d in db.Departamento select d; cmbDepartamento.Items.Clear(); foreach (var element in lst2) { numero = element.IdDepartamento.ToString(); nombre = element.NombreDepartamento; cmbDepartamento.Items.Add(numero + "-" + nombre); } } bandera = "cambio"; }
private void Baja(int id) { using (abcEntities db = new abcEntities()) { db.spBaja(id); } }
private void txtModelo_KeyDown(object sender, KeyEventArgs e) { using (abcEntities db = new abcEntities()) { var lst = from d in db.ABCC.Where(p => p.Modelo.Contains(txtModelo.Text)) select d; dataGridView1.DataSource = lst.ToList(); EstiloFila(dataGridView1); } }
private void txtSku_KeyDown(object sender, KeyEventArgs e) { if (e.KeyData == Keys.Enter) { using (abcEntities db = new abcEntities()) { var lst = from d in db.ABCC.Where(p => p.Sku.ToString().Contains(txtSku.Text)) select d; dataGridView1.DataSource = lst.ToList(); EstiloFila(dataGridView1); } } }
private void cmbFamilia_SelectionChangeCommitted(object sender, EventArgs e) { int indice = int.Parse(cmbClase.SelectedItem.ToString().Substring(0, 1)); int indice2 = int.Parse(cmbDepartamento.SelectedItem.ToString().Substring(0, 1)); string indice3 = cmbFamilia.SelectedItem.ToString().Substring(0, 2); using (abcEntities db = new abcEntities()) { var lst = from d in db.ABCC.Where(p => p.Departamento.ToString().Contains(indice2.ToString()) && p.Clase.ToString().Contains(indice.ToString()) && p.Familia.Contains(indice3)) select d; dataGridView1.DataSource = lst.ToList(); EstiloFila(dataGridView1); } }
private void Cambio(int id) { using (abcEntities db = new abcEntities()) { ABCC.Models.ABCC oTabla = new Models.ABCC(); string d = "0"; if (cbxDescontinuado.Checked == true) { d = "1"; db.spCambio( int.Parse(txtSku.Text), txtArticulo.Text, txtMarca.Text, txtModelo.Text, int.Parse(cmbDepartamento.Text.Substring(0, 1)), int.Parse(cmbClase.Text.Substring(0, 1)), cmbFamilia.Text.Substring(0, 2), int.Parse(txtStock.Text), int.Parse(txtCantidad.Text), dtpFA.Value, dtpFA.Value, d ); } else { db.spCambio( int.Parse(txtSku.Text), txtArticulo.Text, txtMarca.Text, txtModelo.Text, int.Parse(cmbDepartamento.Text.Substring(0, 1)), int.Parse(cmbClase.Text.Substring(0, 1)), cmbFamilia.Text.Substring(0, 2), int.Parse(txtStock.Text), int.Parse(txtCantidad.Text), dtpFA.Value, dtpFB.Value, d ); } } }
public void Consulta(int?id) { using (abcEntities db = new abcEntities()) { var lst = db.spConsulta(id); foreach (var element in lst) { cmbDepartamento.DropDownStyle = ComboBoxStyle.DropDown; cmbClase.DropDownStyle = ComboBoxStyle.DropDown; cmbFamilia.DropDownStyle = ComboBoxStyle.DropDown; txtArticulo.Text = element.Articulo; txtMarca.Text = element.Marca; txtModelo.Text = element.Modelo; txtStock.Text = element.Stock.ToString(); txtCantidad.Text = element.Cantidad.ToString(); dtpFA.Value = element.Fecha_Alta; dtpFB.Value = element.Fecha_Baja.Value; var lst2 = db.Departamento.Single(p => p.IdDepartamento.ToString().Contains(element.Departamento.ToString())); var lst3 = db.Clase.Single(p => p.IdClase.ToString().Contains(element.Clase.ToString()) && p.IdDepartamento.ToString().Contains(element.Departamento.ToString())); var lst4 = db.Familia.Single(p => p.IdClase.ToString().Contains(element.Clase.ToString()) && p.IdDepartamento.ToString().Contains(element.Departamento.ToString()) && p.IdFamilia.Contains(element.Familia.ToString())); cmbDepartamento.Text = lst2.IdDepartamento.ToString() + " - " + lst2.NombreDepartamento.ToString(); cmbClase.Text = lst3.IdClase.ToString() + " - " + lst3.NombreClase.ToString(); cmbFamilia.Text = lst4.IdFamilia.ToString() + " - " + lst4.NombreFamilia.ToString(); if (element.Descontinuado == "1") { cbxDescontinuado.Checked = true; } else { cbxDescontinuado.Checked = false; } btnEliminar.Enabled = true; btnEditar.Enabled = true; } } }
private void Alta() { using (abcEntities db = new abcEntities()) { ABCC.Models.ABCC oTabla = new Models.ABCC(); db.spAlta( int.Parse(txtSku.Text), txtArticulo.Text, txtMarca.Text, txtModelo.Text, int.Parse(cmbDepartamento.Text.Substring(0, 1)), int.Parse(cmbClase.Text.Substring(0, 1)), cmbFamilia.Text.Substring(0, 2), int.Parse(txtStock.Text), int.Parse(txtCantidad.Text), dtpFA.Value, dtpFB.Value, "0" ); db.SaveChanges(); } }
private void btnOk_Click(object sender, EventArgs e) { using (abcEntities db = new abcEntities()) { ABCC.Models.ABCC oTabla = new Models.ABCC(); var lst = from d in db.ABCC.Where(p => p.Sku.ToString().Contains(txtSku.Text)) select d; if (lst.Count() > 0) { Consulta(int.Parse(txtSku.Text)); bandera = "consulta"; } else { txtArticulo.Enabled = true; txtMarca.Enabled = true; txtModelo.Enabled = true; cmbDepartamento.Enabled = true; txtCantidad.Enabled = true; txtStock.Enabled = true; btnAceptar.Enabled = true; string numero; string nombre; var lst2 = from d in db.Departamento select d; cmbDepartamento.Items.Clear(); foreach (var element in lst2) { numero = element.IdDepartamento.ToString(); nombre = element.NombreDepartamento; cmbDepartamento.Items.Add(numero + "-" + nombre); } bandera = "nuevo"; } } }