private void Refresh() { DataSet1TableAdapters.MaterialTableAdapter ta = new DataSet1TableAdapters.MaterialTableAdapter(); DataSet1.MaterialDataTable dt = ta.GetDataMaterial(); dataGridView1.DataSource = dt; dataGridView1.Columns[0].HeaderText = "Id"; dataGridView1.Columns[1].HeaderText = "Nombre"; dataGridView1.Columns[2].HeaderText = "Cantidad"; dataGridView1.Columns[3].HeaderText = "Presentacion"; dataGridView1.Columns[4].HeaderText = "Unidades"; dataGridView1.Columns[5].HeaderText = "Caducidad"; dataGridView1.Columns[6].HeaderText = "Proveedor"; }
private void txtBuscarMat_KeyPress(object sender, KeyPressEventArgs e) { try { DataSet1TableAdapters.MaterialTableAdapter ta = new DataSet1TableAdapters.MaterialTableAdapter(); DataSet1.MaterialDataTable dt = ta.GetDataByMaterialFiltering(txtBuscarMat.Text//,//string , txtBuscarMat.Text , txtBuscarMat.Text , txtBuscarMat.Text , txtBuscarMat.Text , txtBuscarMat.Text // ,txtBuscarMat.Text,// clnFechaExp.SelectionRange.Start.ToShortDateString(), // , Convert.ToDecimal(txtBuscarMat.Text),//decimal // , Convert.ToInt32(txtBuscarMat.Text)//int //,Convert.ToInt32(txtBuscarMat.Text)//int // ,txtBuscarMat.Text,// clnFechaExp.SelectionRange.Start.ToShortDateString(), // , Convert.ToDecimal(txtBuscarMat.Text),//decimal // , Convert.ToInt32(txtBuscarMat.Text)//int ); // (txtNombre.Text.Trim(), (int)udCantidad.Value, // clnFechaExp.SelectionRange.Start.ToShortDateString(), (decimal)udUnidades.Value, // valorIdSupplier // , (int)idd); ta.FillByMaterialFiltering(dt, txtBuscarMat.Text//, , txtBuscarMat.Text , txtBuscarMat.Text , txtBuscarMat.Text , txtBuscarMat.Text , txtBuscarMat.Text ); dataGridView1.DataSource = dt; } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void btnEliminar_Click(object sender, EventArgs e) { string message = "Esta seguro que desea eliminar este registro?"; string title = "Advertencia"; MessageBoxButtons buttons = MessageBoxButtons.YesNo; // int?id = GetId(); if (id == null) { MessageBox.Show("No hay registros"); } else { DialogResult result = MessageBox.Show(message, title, buttons); if (result == DialogResult.Yes) { if (id != null) { DataSet1TableAdapters.MaterialTableAdapter ta = new DataSet1TableAdapters.MaterialTableAdapter(); try { ta.DeleteQueryMaterial((int)id); Refresh(); } catch (Exception mensaje) { MessageBox.Show(mensaje.ToString()); } } } else { // Do something } } }
private void btnEditar_Click(object sender, EventArgs e) { int?id = GetId(); int valorcillo; //MessageBox.Show(id.ToString()); if (id != null) { DataSet1TableAdapters.MaterialTableAdapter ta = new DataSet1TableAdapters.MaterialTableAdapter(); DataSet1.MaterialDataTable pt = ta.GetDataByIdMaterial((int)id); DataSet1.MaterialRow row = (DataSet1.MaterialRow)pt.Rows[0]; txtNombre.Text = row.MaterialName; udCantidad.Value = row.MaterialQuantity; udUnidades.Value = row.MaterialUnits; // txtTipoUnidad.Text = row.MaterialUnitType; clnFechaExp.SetDate(row.MaterialExpDate); valorcillo = row.idSupplier; // MessageBox.Show(valorcillo.ToString()); //from here DataSet1TableAdapters.SupplierTableAdapter tas = new DataSet1TableAdapters.SupplierTableAdapter(); DataSet1.SupplierDataTable pts = tas.GetDataByIdSupplier((int)valorcillo); // DataSet1.SupplierRow rowsup = (DataSet1.SupplierRow)pts.Rows[0]; // txtProveedor.Text = rowsup.ToString(); dgvProveedor.DataSource = pts; } else { MessageBox.Show("No hay registros"); } }
private void btnGuardar_Click(object sender, EventArgs e) { int valorIdSupplier = int.Parse(dgvProveedor.Rows[dgvProveedor.CurrentRow.Index].Cells[0].Value.ToString()); // MessageBox.Show(idd.ToString()); DataSet1TableAdapters.MaterialTableAdapter ta = new DataSet1TableAdapters.MaterialTableAdapter(); // MessageBox.Show(idd.ToString()); if (string.IsNullOrWhiteSpace(txtNombre.Text)) { MessageBox.Show("Verifique que todos los campos hayan sido llenados correctamente"); } else if (idd == 0) { // ta.InsertQueryMaterial(txtNombre.Text.Trim()); ta.InsertQueryMaterial(txtNombre.Text.Trim(), (int)udCantidad.Value, clnFechaExp.SelectionRange.Start.ToShortDateString(), (decimal)udUnidades.Value, (int)valorIdSupplier, txtPresentacion.Text.Trim()); txtNombre.Clear(); udCantidad.Value = 0; udUnidades.Value = 0; clnFechaExp.SetDate(DateTime.Now); txtProveedor.Clear(); txtProveedor.Enabled = true; dgvProveedor.Enabled = true; btnElegir.Enabled = true; btnLimpiar.Enabled = true; idd = 0; Refresh(); txtPresentacion.Clear(); } else { // int valorIdSupplier = int.Parse(dgvProveedor.Rows[dgvProveedor.CurrentRow.Index].Cells[0].Value.ToString()); ta.UpdateQueryMaterial(txtNombre.Text.Trim(), (int)udCantidad.Value, clnFechaExp.SelectionRange.Start.ToShortDateString(), (decimal)udUnidades.Value, valorIdSupplier , txtPresentacion.Text.Trim(), (int)idd); txtNombre.Clear(); udCantidad.Value = 0; udUnidades.Value = 0; clnFechaExp.SetDate(DateTime.Now); txtPresentacion.Clear(); txtProveedor.Clear(); txtProveedor.Enabled = true; dgvProveedor.Enabled = true; btnElegir.Enabled = true; btnLimpiar.Enabled = true; idd = 0; Refresh(); } /* * * * */ }