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_Staff_Service expense_Staff_Service = new Expense_Staff_Service(unitofWork);
List <Expense_Staff> expense_Staffs = expense_Staff_Service.GetAllExpense_Staff().Where(x => x.ExpenseDate >= DateStart && x.ExpenseDate <= DateFinish).ToList();
dataGridView1.DataSource = expense_Staffs;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Ad Soyad";
dataGridView1.Columns[2].HeaderText = "Gider Tipi";
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_Staffs.Sum(x => x.Price).ToString();
}
private void btnClear_Click(object sender, EventArgs e)
{
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Staff_Service expense_Staff_Service = new Expense_Staff_Service(unitofWork);
List <Expense_Staff> expense_Staffs = expense_Staff_Service.GetAllExpense_Staff();
dataGridView1.DataSource = expense_Staffs;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Ad Soyad";
dataGridView1.Columns[2].HeaderText = "Gider Tipi";
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_Staffs.Sum(x => x.Price).ToString();
}
