private int update(Lectura lectura)
{
int resultado = 0;
try
{
MySqlConnection cnn = new MySqlConnection(myConnectionString);
cnn.Open();
MySqlCommand cmd = new MySqlCommand("SpUpdateLecturas", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("id_lect", lectura.Id);
cmd.Parameters.AddWithValue("lec_ant", lectura.Lec_ant);
cmd.Parameters.AddWithValue("lec_act", lectura.Lec_act);
resultado = cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception)
{
throw;
}
return(resultado);
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
Lectura lectura = new Lectura();
string id;
id = dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString();
if (id != "")
{
lectura.Id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString());
lectura.Lec_ant = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["L. Anterior"].Value.ToString());
lectura.Lec_act = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["L. Actual"].Value.ToString());
int result = update(lectura);
if (result > 0)
{
lblmsj.ForeColor = Color.Green;
lblmsj.Text = "Se actualizo correctamente .!";
control();
dataGridView1.DataSource = selectAll();
int cantidad = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Cantidad"].Value.ToString());
if (cantidad <= 0)
{
DataGridViewCell cell = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
cell.ErrorText = "valor no valido";
}
controlDatagridView();
}
else
{
lblmsj.ForeColor = Color.Red;
lblmsj.Text = "Ninguna fila selecionada.!";
control();
ddt = new DataTable();
dataGridView1.DataSource = selectAll();
controlDatagridView();
}
}
}
