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_Suppliers_Service expense_Suppliers_Service = new Expense_Suppliers_Service(unitofWork);
List <Expense_Suppliers> expense_Suppliers = expense_Suppliers_Service.GetAllExpense_Suppliers().Where(x => x.ExpenseDate >= DateStart && x.ExpenseDate <= DateFinish).ToList();
dataGridView1.DataSource = expense_Suppliers;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Firma";
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;
dataGridView1.Columns[8].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = expense_Suppliers.Sum(x => x.Price).ToString();
}
private void btnClear_Click(object sender, EventArgs e)
{
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Suppliers_Service expense_Suppliers_Service = new Expense_Suppliers_Service(unitofWork);
List <Expense_Suppliers> expense_Suppliers = expense_Suppliers_Service.GetAllExpense_Suppliers();
dataGridView1.DataSource = expense_Suppliers;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Firma";
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;
dataGridView1.Columns[8].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = expense_Suppliers.Sum(x => x.Price).ToString();
}
