private void adicionarTempoToolStripMenuItem_Click(object sender, EventArgs e)
{
relogio.Enabled = false;
frm_add add = new frm_add();
if (add.ShowDialog() == DialogResult.OK)
{
NpgsqlCommand sel_rest = new NpgsqlCommand("select tmp_rest from espera where nick = '" + grid_espera.SelectedCells[0].Value + "'", kronos_con);
NpgsqlDataReader drSelhora = sel_rest.ExecuteReader();
if (drSelhora.Read())
{
DateTime res_h = Convert.ToDateTime(drSelhora[0]);
DateTime total = res_h.AddMinutes(Convert.ToInt32(add.hora.Text));
NpgsqlCommand upd_tempo = new NpgsqlCommand("update espera set tmp_add = '" + total.ToString("HH:mm:ss") + "', tmp_rest = '" + total.ToString("HH:mm:ss") + "' where nick = '" + grid_espera.SelectedCells[0].Value + "'", kronos_con);
Int32 upd_result = upd_tempo.ExecuteNonQuery();
if (upd_result != 0)
{
MessageBox.Show("Adicionado " + res_h.ToString("HH:mm") + " total de " + total.ToString("HH:mm"));
}
else
{
MessageBox.Show("Ocorreu erro ao adicionar tempo para " + grid_espera.SelectedCells[0].Value);
}
}
}
verifica_maquinas();
verifica_espera();
relogio.Enabled = true;
}
private void adicionarHoraToolStripMenuItem_Click(object sender, EventArgs e)
{
relogio.Enabled = false;
if (grid_espera.RowCount != 0)
{
if (MessageBox.Show("Existe usuário na lista de espera. Deseja adicionar tempo assim mesmo?", "ATENÇÃO", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
frm_add add = new frm_add();
if (add.ShowDialog() == DialogResult.OK)
{
String qry_selhora = "select tmp_rest from atividade where nick = '" + grid_user.SelectedCells[0].Value + "'";
NpgsqlCommand sel_rest = new NpgsqlCommand(qry_selhora, kronos_con);
NpgsqlDataReader drSelhora = sel_rest.ExecuteReader();
if (drSelhora.Read())
{
DateTime res_h = Convert.ToDateTime(drSelhora[0]);
DateTime total = res_h.AddMinutes(Convert.ToInt32(add.hora.Text));
String qry_upd_tempo = "update atividade set tmp_add = '" + total.ToString("HH:mm:ss") + "', tmp_rest = '" + total.ToString("HH:mm:ss") + "' where nick = '" + grid_user.SelectedCells[0].Value + "'";
NpgsqlCommand upd_tempo = new NpgsqlCommand(qry_upd_tempo, kronos_con);
Int32 upd_result = upd_tempo.ExecuteNonQuery();
if (upd_result != 0)
{
MessageBox.Show("Adicionado " + res_h.ToString("HH:mm") + " total de " + total.ToString("HH:mm"));
}
else
{
MessageBox.Show("Ocorreu erro ao adicionar tempo para " + grid_user.SelectedCells[0].Value);
}
}
drSelhora.Close();
}
}
}
else
{
frm_add add = new frm_add();
if (add.ShowDialog() == DialogResult.OK)
{
String qry_selhora = "select tmp_rest from atividade where nick = '" + grid_user.SelectedCells[0].Value + "'";
NpgsqlCommand sel_rest = new NpgsqlCommand(qry_selhora, kronos_con);
NpgsqlDataReader drSelhora = sel_rest.ExecuteReader();
if (drSelhora.Read())
{
DateTime res_h = Convert.ToDateTime(drSelhora[0]);
DateTime total = res_h.AddMinutes(Convert.ToInt32(add.hora.Text));
String qry_upd_tempo = "update atividade set tmp_add = '" + total.ToString("HH:mm:ss") + "', tmp_rest = '" + total.ToString("HH:mm:ss") + "' where nick = '" + grid_user.SelectedCells[0].Value + "'";
NpgsqlCommand upd_tempo = new NpgsqlCommand(qry_upd_tempo, kronos_con);
Int32 upd_result = upd_tempo.ExecuteNonQuery();
if (upd_result != 0)
{
MessageBox.Show("Adicionado " + res_h.ToString("HH:mm") + " total de " + total.ToString("HH:mm"));
}
else
{
MessageBox.Show("Ocorreu erro ao adicionar tempo para " + grid_user.SelectedCells[0].Value);
}
}
drSelhora.Close();
}
}
verifica_maquinas();
relogio.Enabled = true;
}