public frmExeGerenciar()
{
InitializeComponent();
exe = new Exercicio();
lblTotExe.Text = exe.getTotal();
exe.Desc = "";
atualizaDtgv();
}
public frmExeNovo(String exeId)
{
InitializeComponent();
exe = new Exercicio();
exe.Id = exeId;
if (exe.Id != "")
{
exe = exe.getById();
adptaInterface();
}
}
public bool altera(Exercicio exe)
{
sql = "UPDATE exercicio SET exe_desc='@2', exe_area='@3'"+
" WHERE exe_id = '@1'";
sql = sql.Replace("@1", exe.Id);
sql = sql.Replace("@2", exe.Desc);
sql = sql.Replace("@3", exe.Area);
bco.conecta();
result = bco.executeNonQuery(sql);
bco.desconecta();
return result;
}
public Exercicio getById(String id)
{
Exercicio exe = new Exercicio();
sql = "SELECT * FROM exercicio WHERE exe_id = @1";
sql = sql.Replace("@1", id);
bco.conecta();
bco.executeQuery(sql, out dt);
bco.desconecta();
exe.Id = id;
exe.Desc = dt.Rows[0]["exe_desc"].ToString();
exe.Area = dt.Rows[0]["exe_area"].ToString();
return exe;
}
public bool novo(Exercicio exe)
{
sql = "INSERT INTO exercicio(exe_desc, exe_area) "+
"VALUES ('@1', '@2')";
sql = sql.Replace("@1", exe.Desc);
sql = sql.Replace("@2", exe.Area);
bco.conecta();
result = bco.executeNonQuery(sql);
bco.desconecta();
return result;
}