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