public async Task <dynamic> thongKeNhapHangTheoNam(string nam)
{
//ThongKeDoanhThu thongKe = new ThongKeDoanhThu();
IEnumerable <chiphiThang> dsNhapHang = null;
using (var connection = new SqlConnection(connectionstr))
{
string query = @"select DATEPART(Month, NgayTao) thang, SUM(DonGia) tongTien from CHITIETPHIEUNHAP CT
INNER JOIN PHIEUNHAP PN ON CT.MaPN = PN.MaPN WHERE DATEPART(Year, NgayTao)='" + nam + @"'
GROUP BY DATEPART(Year, NgayTao),DATEPART(Month, NgayTao)
ORDER BY Thang ";
dsNhapHang = await connection.QueryAsync <chiphiThang>(query, commandType : CommandType.Text);
chiphiThang[] ds = new chiphiThang[12];
for (int i = 0; i < 12; i++)
{
ds[i] = new chiphiThang();
ds[i].thang = (i + 1).ToString();
ds[i].tongTien = 0;
}
foreach (var item in dsNhapHang)
{
ds[int.Parse(item.thang) - 1] = item;
}
return(ds);
}
}
public async Task <dynamic> thongKeDoanhThuTheoNam(string nam)
{
//ThongKeDoanhThu thongKe = new ThongKeDoanhThu();
using (var connection = new SqlConnection(connectionstr))
{
IEnumerable <chiphiThang> dsDoanhThu = null;
string query = @"select DATEPART(Month, NgayDat) thang, SUM(DonGia) tongTien from CHITIETDONDATHANG CT
INNER JOIN DONDATHANG DDH ON CT.MaDDH = DDH.MaDDH WHERE DATEPART(Year, NgayDat)='" + nam + @"' AND TinhTrang=1
GROUP BY DATEPART(Year, NgayDat),DATEPART(Month, NgayDat)
ORDER BY Thang ";
dsDoanhThu = await connection.QueryAsync <chiphiThang>(query, commandType : CommandType.Text);
chiphiThang[] ds = new chiphiThang[12];
for (int i = 0; i < 12; i++)
{
ds[i] = new chiphiThang();
ds[i].thang = (i + 1).ToString();
ds[i].tongTien = 0;
}
foreach (var item in dsDoanhThu)
{
ds[int.Parse(item.thang) - 1] = item;
}
return(ds);
}
}
