public List <Thongke> ThongKe(DateTime tungay, DateTime denngay)
{
var dbContext = new shopContext();
var doanhthu = dbContext.Hoadon
.Where(x => x.NgayTao >= tungay && x.NgayTao <= denngay)
.GroupBy(x => new {
x.NgayTao.Month,
x.NgayTao.Year
})
.OrderBy(x => x.Key.Year)
.OrderBy(x => x.Key.Month)
.Select(g => new {
thang = g.Key.Month,
nam = g.Key.Year,
tong = g.Sum(x => x.TongTienThanhToan).ToString()
}).ToList();
List <Thongke> DSThongKe = new List <Thongke>();
foreach (var item in doanhthu)
{
Thongke tk = new Thongke();
tk.Nam = item.nam;
tk.Thang = item.thang;
tk.DoanhThu = item.tong;
DSThongKe.Add(tk);
}
return(DSThongKe);
}
private void thốngKêToolStripMenuItem_Click(object sender, EventArgs e)
{
Thongke f = new Thongke();
this.Hide();
f.ShowDialog();
this.Show();
}
public static Thongke khoitao()
{
if (check == false)
{
check = true;
TK = new Thongke();
}
else
{
TK.Activate();
}
return(TK);
}
public static List <Thongke> thongke(DateTime tu, DateTime den)
{
List <Thongke> tour = new List <Thongke>();
List <int> lt = QLTOUR.load(tu, den);
foreach (var temp in lt)
{
TOUR tt = QLTOUR.find(temp);
int demd = DAO.QLTOUR.demdoan(temp, tu, den);
int doanhthu = DAO.QLTOUR.doanhthu(temp, tt.GIATOUR, tu, den);
int chiphi = DAO.QLTOUR.chiphi(temp, tu, den);
int loi = doanhthu - chiphi;
Thongke tk = new Thongke();
tk.TENTOUR = tt.TENTOUR;
tk.SODOAN = demd;
tk.DOANHTHU = doanhthu;
tk.CHIPHI = chiphi;
tk.LOI = loi;
tour.Add(tk);
}
return(tour);
}
