public void editar(TextBox txtCod, ComboBox cbxProv, ComboBox cbxProd,
Label lbl, DataGridView dt, DateTimePicker dtF)
{
int id;
id = int.Parse(dt.CurrentRow.Cells[0].Value.ToString());
mIntermedia = sIntermedia.editar(id);
txtCod.Text = mIntermedia.Codigo;
cbxProv.SelectedValue = mIntermedia.IdProveedor;
cbxProd.SelectedValue = mIntermedia.IdProducto;
dtF.Text = mIntermedia.Fecha;
}
public M_Intermedia editar(int id)
{
Con = base.conexion();
SQL = "spListarIdIntermedia";
M_Intermedia mIntermedia = new M_Intermedia();
try
{
Con.Open();
coman = new MySqlCommand(SQL, Con);
coman.CommandType = CommandType.StoredProcedure;
coman.Parameters.AddWithValue("@i", id);
mSDR = coman.ExecuteReader();
while (mSDR.Read())
{
mIntermedia.Id = int.Parse(mSDR[0].ToString());
mIntermedia.Codigo = mSDR[1].ToString();
mIntermedia.IdProveedor = int.Parse(mSDR[2].ToString());
mIntermedia.IdProducto = int.Parse(mSDR[3].ToString());
mIntermedia.Fecha = mSDR[4].ToString();
}
coman.Parameters.Clear();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
try
{
Con.Close();
}
catch (MySqlException ex)
{
Console.WriteLine("Error " + ex.Message);
}
}
return(mIntermedia);
}
public bool actualizar(M_Intermedia mIntermedia)
{
Con = base.conexion();
SQL = "spActualizarTablaIntermedia";
try
{
Con.Open();
coman = new MySqlCommand(SQL, Con);
coman.CommandType = CommandType.StoredProcedure;
coman.Parameters.AddWithValue("@cod", mIntermedia.Codigo);
coman.Parameters.AddWithValue("@idP", mIntermedia.IdProveedor);
coman.Parameters.AddWithValue("@idPro", mIntermedia.IdProducto);
DateTime dt = Convert.ToDateTime(mIntermedia.Fecha);
coman.Parameters.AddWithValue("@fech", dt);
coman.Parameters.AddWithValue("@idTrae", mIntermedia.Id);
coman.ExecuteNonQuery();
coman.Parameters.Clear();
return(true);
}
catch (MySqlException ex)
{
Console.WriteLine("Error " + ex.Message.ToString());
return(false);
}
finally
{
try
{
Con.Close();
}
catch (MySqlException ex)
{
Console.WriteLine("Error " + ex.Message);
}
}
}
