public Movimentações()
{
InitializeComponent();
DAO.CaixaDAO cDAO = new DAO.CaixaDAO();
dinheiroLb.Text = "R$" + String.Format("{0:0.00}", cDAO.ConsultarSaldo());
}
private void updateTable()
{
DAO.EntradaDAO eDAO = new DAO.EntradaDAO();
DAO.CaixaDAO cDAO = new DAO.CaixaDAO();
dataGridView1.DataSource = eDAO.ConsultarEntrada();
dataGridView1.Sort(this.dataGridView1.Columns["DataHoraRegistro"], ListSortDirection.Descending);
dinheiroEntradaLb.Text = "R$" + String.Format("{0:0.00}", cDAO.ConsultarSaldo());
}
public Saída()
{
InitializeComponent();
Objetos.Saida saida = new Objetos.Saida();
DAO.SaidaDAO sDAO = new DAO.SaidaDAO();
DAO.CaixaDAO cDAO = new DAO.CaixaDAO();
DAO.UsuarioDAO uDAO = new DAO.UsuarioDAO();
tipoDp.SelectedItem = "Fixa";
respDp.DataSource = uDAO.NomesColaboradores();
respDp.DisplayMember = "Nome";
respDp.SelectedItem = saida.FkNomeColaboradorResponsavel;
dataGridView1.DataSource = sDAO.ConsultarSaida();
dataGridView1.Sort(this.dataGridView1.Columns["DataHoraRegistro"], ListSortDirection.Descending);
dinheiroSaidaLb.Text = "R$" + String.Format("{0:0.00}", cDAO.ConsultarSaldo());
switchTabela();
}
private void deleteBt_Click(object sender, EventArgs e)
{
DAO.CaixaDAO cDAO = new DAO.CaixaDAO();
DAO.SaidaDAO sDAO = new DAO.SaidaDAO();
DataGridViewRow row = dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex];
int valorCelula = Int16.Parse(row.Cells[0].Value.ToString());
//string verif = InputDialogBox.Show("Tem certeza que deseja fazer isso?\n(Digite 'SIM' para confirmar)");
var confirmResult = MessageBox.Show("Tem certeza que deseja excluir essa saída?", "Confirmação", MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
sDAO.ExcluirSaida(valorCelula);
dataGridView1.DataSource = sDAO.ConsultarSaida();
dataGridView1.Sort(this.dataGridView1.Columns["DataHoraRegistro"], ListSortDirection.Descending);
dinheiroSaidaLb.Text = "R$" + String.Format("{0:0.00}", cDAO.ConsultarSaldo());
}
}
private void saveBt_Click(object sender, EventArgs e)
{
Objetos.Saida saida = new Objetos.Saida();
DAO.SaidaDAO sDAO = new DAO.SaidaDAO();
DAO.CaixaDAO cDAO = new DAO.CaixaDAO();
saida.IdMovimentacao = id;
saida.Valor = Convert.ToDouble(saqueTb.Text);
saida.TipoDespesa = tipoDp.Text;
saida.FkNomeColaboradorResponsavel = respDp.Text;
saida.NotaFiscal = notaTb.Text;
saida.Descricao = descripTb.Text;
sDAO.AlterarSaida(saida);
dataGridView1.DataSource = sDAO.ConsultarSaida();
dataGridView1.Sort(this.dataGridView1.Columns["DataHoraRegistro"], ListSortDirection.Descending);
dinheiroSaidaLb.Text = "R$" + String.Format("{0:0.00}", cDAO.ConsultarSaldo());
switchTabela();
}
private void enviarSaida()
{
if (saqueTb.Text == "")
{
MessageBox.Show("Insira um valor!");
saqueTb.Focus();
}
else if (tipoDp.Text == "")
{
MessageBox.Show("Escolha o tipo da despesa!");
tipoDp.Focus();
}
else if (respDp.Text == "")
{
MessageBox.Show("Escolha o colaborador responsável!");
respDp.Focus();
}
else
{
Objetos.Saida saida = new Objetos.Saida();
DAO.SaidaDAO sDAO = new DAO.SaidaDAO();
DAO.CaixaDAO cDAO = new DAO.CaixaDAO();
saida.Valor = Convert.ToDouble(saqueTb.Text);
saida.TipoDespesa = tipoDp.Text;
saida.FkNomeColaboradorResponsavel = respDp.Text;
saida.NotaFiscal = notaTb.Text;
saida.Descricao = descripTb.Text;
clear();
switchTabela();
sDAO.IncluirSaida(saida);
dataGridView1.DataSource = sDAO.ConsultarSaida();
dataGridView1.Sort(this.dataGridView1.Columns["DataHoraRegistro"], ListSortDirection.Descending);
dinheiroSaidaLb.Text = "R$" + String.Format("{0:0.00}", cDAO.ConsultarSaldo());
}
}
