private void btnEditar_Click(object sender, EventArgs e) { int?id = GetId(); int valorcillo; // MessageBox.Show(id.ToString()); if (id != null) { DataSet1TableAdapters.ProductTableAdapter ta = new DataSet1TableAdapters.ProductTableAdapter(); DataSet1.ProductDataTable pt = ta.GetDataByIdProduct((int)id); DataSet1.ProductRow row = (DataSet1.ProductRow)pt.Rows[0]; txtNombre.Text = row.ProductName; udCantidad.Value = row.ProductQuantity; udUnidades.Value = row.ProductUnits; txtTipoUnidad.Text = row.ProductUnitType; clnFechaExp.SetDate(row.ProductExpDate); 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; // dgvProveedor.Rows[dgvProveedor.CurrentRow.Index].Cells[0].Value.Equals(valorcillo); //DataSet1TableAdapters.SupplierTableAdapter tas = new DataSet1TableAdapters.SupplierTableAdapter(); // DataSet1.SupplierDataTable pts = tas.GetDataByIdSupplier((int)iddSupplier); // txtProveedor.Text = pts.ToString(); //iddSupplier= row.idSupplier; // DataSet1.SupplierRow rowsup = (DataSet1.SupplierRow)pts.Rows[0]; // rowsup.id_Supplier = iddSupplier; // // int.Parse(dgvProveedor.Rows[dgvProveedor.CurrentRow.Index].Cells[0].Value.ToString()); //DataSet1.SupplierRow rowsup = (DataSet1.SupplierRow)pts.Rows[0]; //rowsup.id_Supplier = row.idSupplier; } else { MessageBox.Show("No hay registros"); } }
private void LoadData(FlexCelReport fr) { DataSet1 Data = new DataSet1(); DataSet1TableAdapters.ProductTableAdapter ProductAdapter = new DataSet1TableAdapters.ProductTableAdapter(); ProductAdapter.Fill(Data.Product); DataSet1TableAdapters.ProductPhotoTableAdapter ProductPhotoAdapter = new DataSet1TableAdapters.ProductPhotoTableAdapter(); ProductPhotoAdapter.Fill(Data.ProductPhoto); DataSet1TableAdapters.ProductProductPhotoTableAdapter ProductProductPhotoAdapter = new DataSet1TableAdapters.ProductProductPhotoTableAdapter(); ProductProductPhotoAdapter.Fill(Data.ProductProductPhoto); fr.AddTable(Data); }
private void Refresh() { DataSet1TableAdapters.ProductTableAdapter ta = new DataSet1TableAdapters.ProductTableAdapter(); DataSet1.ProductDataTable dt = ta.GetDataProduct(); 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 = "Caducidad"; dataGridView1.Columns[5].HeaderText = "Unidades"; dataGridView1.Columns[6].HeaderText = "Tipo Unidad"; dataGridView1.Columns[7].HeaderText = "Proveedor"; }
private void txtBuscarProd_KeyPress(object sender, KeyPressEventArgs e) { try { DataSet1TableAdapters.ProductTableAdapter ta = new DataSet1TableAdapters.ProductTableAdapter(); DataSet1.ProductDataTable dt = ta.GetDataByProductFiltering(txtBuscarProd.Text//,//string , txtBuscarProd.Text , txtBuscarProd.Text , txtBuscarProd.Text , txtBuscarProd.Text, txtBuscarProd.Text, txtBuscarProd.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.FillByProductFiltering(dt, txtBuscarProd.Text//, , txtBuscarProd.Text , txtBuscarProd.Text , txtBuscarProd.Text , txtBuscarProd.Text, txtBuscarProd.Text, txtBuscarProd.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.ProductTableAdapter ta = new DataSet1TableAdapters.ProductTableAdapter(); try { ta.DeleteQueryProduct((int)id); Refresh(); } catch (Exception mensaje) { MessageBox.Show(mensaje.ToString()); } } } else { // Do something } } }
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.ProductTableAdapter ta = new DataSet1TableAdapters.ProductTableAdapter(); // 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.InsertQueryProduct(txtNombre.Text.Trim(), (int)udCantidad.Value, clnFechaExp.SelectionRange.Start.ToShortDateString(), (decimal)udUnidades.Value, (int)valorIdSupplier, txtTipoUnidad.Text.Trim(), txtPresentacion.Text.Trim()); txtNombre.Clear(); udCantidad.Value = 0; udUnidades.Value = 0; clnFechaExp.SetDate(DateTime.Now); txtTipoUnidad.Clear(); txtProveedor.Clear(); txtProveedor.Enabled = true; dgvProveedor.Enabled = true; btnElegir.Enabled = true; btnLimpiar.Enabled = true; idd = 0; Refresh(); valorIdSupplier = 0; txtPresentacion.Clear(); } else { // int valorIdSupplier = int.Parse(dgvProveedor.Rows[dgvProveedor.CurrentRow.Index].Cells[0].Value.ToString()); ta.UpdateQueryProduct(txtNombre.Text.Trim(), (int)udCantidad.Value, txtPresentacion.Text.Trim(), clnFechaExp.SelectionRange.Start.ToShortDateString(), (decimal)udUnidades.Value, txtTipoUnidad.Text.Trim(), valorIdSupplier , (int)idd); txtNombre.Clear(); udCantidad.Value = 0; udUnidades.Value = 0; clnFechaExp.SetDate(DateTime.Now); valorIdSupplier = 0; txtTipoUnidad.Clear(); txtProveedor.Clear(); txtProveedor.Enabled = true; dgvProveedor.Enabled = true; btnElegir.Enabled = true; btnLimpiar.Enabled = true; idd = 0; Refresh(); } }