private void button2_Click(object sender, EventArgs e)
{
var company = new List <Company>();
var companyHaveEmployees = new List <Company>();
this.Hide();
var form = new frmEmployees();
form.Text = "Danh sách các công ty có số lượng viên > 2 và có tổng lương(Salary) phải trả một tháng lớn hơn 1000USD";
var employee = DatabaseService.Instance.Get <Employee>();
employee.ToList().ForEach(item =>
{
if (!company.Any(x => x.CompanyID == item.HomeBase?.CompanyID))
{
company.Add(item.HomeBase);
}
else
{
if (!companyHaveEmployees.Any(x => x.CompanyID == item.HomeBase?.CompanyID) && item.Salary > 1000)
{
companyHaveEmployees.Add(item.HomeBase);
}
}
});
form.Source = companyHaveEmployees.Select(x => new {
x.CompanyName,
x.HouseNumber,
x.Street,
x.City
});
form.ShowDialog();
this.Show();
}
private void button1_Click_1(object sender, EventArgs e)
{
var form = new frmEmployees();
form.Source = DatabaseService.Instance.Get <Employee>()
.Select(x => {
return(new
{
x.FullName,
x.Skill,
x.Salary,
Company = x.HomeBase?.CompanyName
});
});
this.Hide();
form.ShowDialog();
this.Show();
}
private void ChangeData(object sender, EventArgs e)
{
var form = new frmEmployees();
var employee = DatabaseService.Instance.Get <Employee>();
}