public List <ContratoCondominioModel> printCondos()
{
data.connectToDB();
List <ContratoCondominioModel> conds = new List <ContratoCondominioModel>();
String sql = "SELECT * FROM ((proj_contrato join proj_pessoa on proj_contrato.proprietario=proj_pessoa.nif) join proj_contrato_condominio on proj_contrato.codigo=proj_contrato_condominio.codigo)";
SqlCommand com = new SqlCommand(sql, data.connection());
SqlDataReader reader;
reader = com.ExecuteReader();
while (reader.Read())
{
ContratoCondominioModel tmp = new ContratoCondominioModel();
tmp.codigo = reader.GetDecimal(0);
tmp.data_ini = reader.GetDateTime(1);
tmp.data_fim = reader.GetDateTime(2);
tmp.dia_pagamento = reader.GetInt32(3);
tmp.proprietario = reader.GetDecimal(4);
tmp.despesas = reader.GetInt32(11);
tmp.seguro = reader.GetString(12);
tmp.area = reader.GetInt32(13);
tmp.condominio = reader.GetDecimal(14);
conds.Add(tmp);
}
data.close();
return(conds);
}
private void save(ContratoCondominioModel inq)
{
data.connectToDB();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "exec inserirContratoCond @cod, @data1, @data2, @dia, @prop, @despesa, @seguro, @area, @condo ";
// SqlCommand cmd = new SqlCommand();
//cmd.CommandText = "INSERT proj_contrato (codigo, data_ini, data_fim, dia_pagamento, proprietario) values(@cod, @data1, @data2, @dia, @prop)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@cod", inq.codigo);
cmd.Parameters.AddWithValue("@data1", inq.data_ini);
cmd.Parameters.AddWithValue("@data2", inq.data_fim);
cmd.Parameters.AddWithValue("@dia", inq.dia_pagamento);
cmd.Parameters.AddWithValue("@prop", inq.proprietario);
//cmd.Connection = data.connection();
//SqlCommand cmd2 = new SqlCommand();
//cmd2.CommandText = "INSERT proj_contrato_condominio (codigo, despesas, seguro, area, condominio) values(@cod, @despesa, @seguro, @area, @condo)";
//cmd2.Parameters.Clear();
//cmd.Parameters.AddWithValue("@cod", inq.codigo);
cmd.Parameters.AddWithValue("@despesa", inq.despesas);
cmd.Parameters.AddWithValue("@seguro", inq.seguro);
cmd.Parameters.AddWithValue("@area", inq.area);
cmd.Parameters.AddWithValue("@condo", inq.condominio);
cmd.Connection = data.connection();
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Entry Successful!");
}
catch (Exception ex)
{
//throw new Exception("Failed to insert in database. \n ERROR MESSAGE: \n" + ex.Message);
MessageBox.Show("Não foi possível guardar os dados! Verifique os campos inseridos!");
}
finally
{
data.close();
}
}
private void button2_Click(object sender, EventArgs e)
{
ContratoCondominioModel inq = new ContratoCondominioModel();
try
{
inq.codigo = Decimal.Parse(codigoBox.Text);
inq.data_ini = DateTime.Parse(data1.Text.ToString());
inq.data_fim = DateTime.Parse(data2.Text.ToString());
inq.dia_pagamento = Int32.Parse(diaBox.Text.ToString());
inq.proprietario = getNifProp(proprietarioBox.Text.ToString());
inq.condominio = (condominio_comboBox.SelectedItem as CondominioView).value;
inq.despesas = Int32.Parse(despesaBox.Text.ToString());
inq.area = Int32.Parse(areaBox.Text.ToString());
inq.seguro = seguroBox.Text.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
save(inq);
this.Close();
}
