public JanelaAgentes(Spartacus.Database.Generic p_database, Spartacus.Forms.Window p_pai)
: base("Cadastro de Agentes", 600, 400, p_pai)
{
this.v_database = p_database;
this.v_grid = new Spartacus.Forms.Grid(this, 330);
this.v_grid.Populate(
this.v_database,
"select a.id, " +
" a.nome, " +
" a.telefone " +
"from agentes a " +
"order by a.id "
);
this.Add(this.v_grid);
this.v_buttons = new Spartacus.Forms.Buttons(this);
this.v_buttons.AddButton("Novo", this.ClickNovo);
this.v_buttons.AddButton("Editar", this.ClickEditar);
this.v_buttons.AddButton("Remover", this.ClickRemover);
this.Add(this.v_buttons);
this.v_janelaagente = new JanelaAgente(this.v_database, this);
this.v_delete = new Spartacus.Database.Command();
this.v_delete.v_text = "delete from agentes where id = #ID#";
this.v_delete.AddParameter("ID", Spartacus.Database.Type.INTEGER);
}
public JanelaPrincipal(Spartacus.Database.Generic p_database)
: base("Finanças Pessoais", 800, 600)
{
this.v_database = p_database;
Spartacus.Forms.Menugroup v_group, v_group2;
this.v_menu = new Spartacus.Forms.Menu(this);
v_group = this.v_menu.AddGroup("Cadastro");
this.v_menu.AddItem(v_group, "Agentes", this.MenuAgentes);
this.Add(this.v_menu);
v_group = this.v_menu.AddGroup("Relatórios");
v_group2 = this.v_menu.AddGroup(v_group, "Listagem de Agentes");
this.v_menu.AddItem(v_group2, "Excel", this.MenuAgentesExcel);
this.v_menu.AddItem(v_group2, "PDF", this.MenuAgentesPDF);
v_group2 = this.v_menu.AddGroup(v_group, "Listagem de Movimentação");
this.v_menu.AddItem(v_group2, "Excel", this.MenuMovimentacaoExcel);
this.v_menu.AddItem(v_group2, "PDF", this.MenuMovimentacaoPDF);
this.v_grid = new Spartacus.Forms.Grid(this, 480);
this.v_grid.Populate(
this.v_database,
"select m.id, " +
" m.data, " +
" a.nome, " +
" m.descricao, " +
" m.debito, " +
" m.credito, " +
" m.saldo " +
"from movimentos m " +
"inner join agentes a " +
"on a.id = m.idagente " +
"order by m.id desc "
);
this.Add(this.v_grid);
this.v_buttons = new Spartacus.Forms.Buttons(this);
this.v_buttons.AddButton("Débito", this.ClickDebito);
this.v_buttons.AddButton("Crédito", this.ClickCredito);
this.v_buttons.AddButton("Estorno", this.ClickEstorno);
this.v_buttons.AddButton("Atualizar", this.ClickAtualizar);
this.Add(this.v_buttons);
this.v_janelaagentes = new JanelaAgentes(this.v_database, this);
this.v_janeladebito = new JanelaDebito(this.v_database, this);
this.v_janelacredito = new JanelaCredito(this.v_database, this);
this.v_cmd = new Spartacus.Database.Command();
this.v_cmd.v_text = "insert into movimentos (idagente, data, debito, credito, saldo, descricao) values (#IDAGENTE#, #DATA#, #DEBITO#, #CREDITO#, #SALDO#, #DESCRICAO#)";
this.v_cmd.AddParameter("IDAGENTE", Spartacus.Database.Type.INTEGER);
this.v_cmd.AddParameter("DATA", Spartacus.Database.Type.INTEGER);
this.v_cmd.AddParameter("DEBITO", Spartacus.Database.Type.REAL);
this.v_cmd.SetLocale("DEBITO", Spartacus.Database.Locale.EUROPEAN);
this.v_cmd.AddParameter("CREDITO", Spartacus.Database.Type.REAL);
this.v_cmd.SetLocale("CREDITO", Spartacus.Database.Locale.EUROPEAN);
this.v_cmd.AddParameter("SALDO", Spartacus.Database.Type.REAL);
this.v_cmd.SetLocale("SALDO", Spartacus.Database.Locale.EUROPEAN);
this.v_cmd.AddParameter("DESCRICAO", Spartacus.Database.Type.STRING);
}
public void Initialize()
{
try
{
if (new System.IO.FileInfo(System.Configuration.ConfigurationManager.AppSettings["database"].ToString()).Exists)
{
this.v_database = new Spartacus.Database.Sqlite(System.Configuration.ConfigurationManager.AppSettings["database"].ToString());
}
else
{
this.v_database = new Spartacus.Database.Sqlite();
this.v_database.CreateDatabase(System.Configuration.ConfigurationManager.AppSettings["database"].ToString());
this.v_database.Execute("create table reports (code integer primary key autoincrement, name text, xmlfile text not null);");
}
this.v_mainwindow = new Spartacus.Forms.Window(
System.Configuration.ConfigurationManager.AppSettings["main.title"].ToString(),
600,
400
);
this.v_maingrid = new Spartacus.Forms.Grid(this.v_mainwindow, 300);
this.v_maingrid.Populate(this.v_database, "select * from reports");
this.v_mainwindow.Add(this.v_maingrid);
this.v_editable = bool.Parse(System.Configuration.ConfigurationManager.AppSettings["editable"].ToString());
this.v_mainbuttons = new Spartacus.Forms.Buttons(this.v_mainwindow);
this.v_mainbuttons.AddButton(System.Configuration.ConfigurationManager.AppSettings["main.execute"].ToString(), this.OnMainExecuteClick);
this.v_mainbuttons.AddButton(System.Configuration.ConfigurationManager.AppSettings["main.insert"].ToString(), this.OnMainInsertClick, this.v_editable);
this.v_mainbuttons.AddButton(System.Configuration.ConfigurationManager.AppSettings["main.update"].ToString(), this.OnMainUpdateClick, this.v_editable);
this.v_mainbuttons.AddButton(System.Configuration.ConfigurationManager.AppSettings["main.delete"].ToString(), this.OnMainDeleteClick, this.v_editable);
this.v_mainwindow.Add(this.v_mainbuttons);
this.v_mainwindow.Run();
}
catch (Spartacus.Database.Exception exc)
{
Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Database.Exception", Spartacus.Forms.Messagebox.Icon.ERROR);
System.Environment.Exit(-1);
}
catch (Spartacus.Forms.Exception exc)
{
Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Forms.Exception", Spartacus.Forms.Messagebox.Icon.ERROR);
System.Environment.Exit(-1);
}
catch (System.Exception exc)
{
Spartacus.Forms.Messagebox.Show(exc.Message, exc.GetType().ToString(), Spartacus.Forms.Messagebox.Icon.ERROR);
System.Environment.Exit(-1);
}
}
