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