private void edit_button_Click(object sender, EventArgs e)
{
string morada = casas_dataGrid.CurrentRow.Cells[0].Value.ToString();
CasaModel tmp = new CasaModel();
data.connectToDB();
//String sql = String.Format("SELECT * FROM proj_casa WHERE morada = '" + morada + "'");
//MessageBox.Show(sql);
SqlCommand com = new SqlCommand("getCasaByMorada", data.connection());
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@morada", morada);
SqlDataReader reader;
reader = com.ExecuteReader();
while (reader.Read())
{
tmp.morada = reader.GetString(0);
tmp.n_quartos = reader.GetInt32(1);
tmp.cidade = reader.GetString(2);
tmp.max_hab = reader.GetInt32(3);
tmp.descricao = reader.GetString(4);
tmp.condominio = reader.GetDecimal(5);
}
data.close();
AddCasa addCasa = new AddCasa(tmp);
addCasa.ShowDialog(this);
}
private void add_bt_Click(object sender, EventArgs e)
{
AddCasa add = new AddCasa();
add.ShowDialog();
}
private void button3_Click(object sender, EventArgs e)
{
AddCasa add = new AddCasa(getCasa(casa_selected()));
add.ShowDialog(this);
}
private void button2_Click(object sender, EventArgs e)
{
AddCasa add = new AddCasa();
add.ShowDialog(this);
}
