private void mudar_gerente_bt_Click(object sender, EventArgs e)
{
string num_fiscal = cond_dataGridView.CurrentRow.Cells[0].Value.ToString();
data.connectToDB();
CondominioModel cond = new CondominioModel();
//String sql = String.Format("SELECT * FROM proj_condominio WHERE num_fiscal = '" + num_fiscal + "'");
//MessageBox.Show(sql);
SqlCommand com = new SqlCommand("getCondominio", data.connection());
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@condomino", num_fiscal);
SqlDataReader reader;
reader = com.ExecuteReader();
while (reader.Read())
{
cond.num_fiscal = Decimal.Parse(reader["num_fiscal"].ToString());
cond.gerente_nif = Decimal.Parse(reader["gerente_nif"].ToString());
cond.nome = reader["nome"].ToString();
}
data.close();
AddCondominio addCond = new AddCondominio(cond);
addCond.ShowDialog(this);
}
private void editar_Click(object sender, EventArgs e)
{
data.connectToDB();
CondominioModel cond = new CondominioModel();
SqlCommand com = new SqlCommand("getCondominio", data.connection());
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@num_fiscal", cond_selected());
SqlDataReader reader;
reader = com.ExecuteReader();
while (reader.Read())
{
cond.num_fiscal = Decimal.Parse(reader["num_fiscal"].ToString());
cond.gerente_nif = Decimal.Parse(reader["gerente_nif"].ToString());
cond.nome = reader["nome"].ToString();
}
data.close();
AddCondominio addCond = new AddCondominio(cond);
addCond.ShowDialog(this);
}
private void add_bt_Click(object sender, EventArgs e)
{
AddCondominio cond = new AddCondominio();
this.Hide();
cond.ShowDialog(this);
}
private void add_cond_bt_Click(object sender, EventArgs e)
{
AddCondominio add = new AddCondominio();
add.ShowDialog();
}