private void btnFillter_Click(object sender, EventArgs e)
{
DateTime DateStart = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateStart.Value));
DateTime DateFinish = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateFinish.Value));
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Invoice_Service expense_Invoice_Service = new Expense_Invoice_Service(unitofWork);
List <Expense_Invoice> expense_Invoices = expense_Invoice_Service.GetAllExpense_Invoice().Where(x => x.ExpenseDate >= DateStart && x.ExpenseDate <= DateFinish).ToList();
dataGridView1.DataSource = expense_Invoices;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Fatura Tipi";
dataGridView1.Columns[2].HeaderText = "Açıklama";
dataGridView1.Columns[3].HeaderText = "Tutar";
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = expense_Invoices.Sum(x => x.Price).ToString();
}
private void btnClear_Click(object sender, EventArgs e)
{
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Invoice_Service expense_Invoice_Service = new Expense_Invoice_Service(unitofWork);
List <Expense_Invoice> expense_Invoices = expense_Invoice_Service.GetAllExpense_Invoice();
dataGridView1.DataSource = expense_Invoices;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Fatura Tipi";
dataGridView1.Columns[2].HeaderText = "Açıklama";
dataGridView1.Columns[3].HeaderText = "Tutar";
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = expense_Invoices.Sum(x => x.Price).ToString();
}
