public static List <BCDoanhThuDTO> DoanhThuTheoLoaiPhongTheoThang(BCDoanhThuDTO infor)
{
DateTime ntm_min = Convert.ToDateTime("1990-01-01");
DateTime ntm_max = Convert.ToDateTime("1990-01-31");
string n1 = "-01"; string n2 = "-31"; string t = (infor.Thang).ToString(); string nam = (infor.Nam).ToString();
if (infor.Thang == 2)
{
if ((infor.Nam % 4 != 0) || ((infor.Nam % 100 == 0) && (infor.Nam % 400 != 0)))
{
n2 = "-28";
}
else
{
n2 = "-29";
}
}
else if (infor.Thang == 4 || infor.Thang == 6 || infor.Thang == 9 || infor.Thang == 11)
{
n2 = "-30";
}
string ntmold = nam + "-" + t + n1;
string ntmnew = nam + "-" + t + n2;
ntm_min = Convert.ToDateTime(ntmold);
ntm_max = Convert.ToDateTime(ntmnew);
return(BaoCaoDAO.DoanhThuTheoLoaiPhongTheoThang(ntm_min, ntm_max));
}
public ActionResult CT_BaoCao()
{
string ngayden = Request.Form["ngayden"];
string ngaydi = Request.Form["ngaydi"];
string[] arrngayden = ngayden.Split('-');
string[] arrngaydi = ngaydi.Split('-');
BaoCaoDAO baocao_dao = new BaoCaoDAO();
List <BaoCao> bc = new List <BaoCao>();
bc = baocao_dao.GetAllBaoCao(arrngayden[0], arrngayden[1], arrngaydi[1], arrngayden[2], arrngaydi[2]);
ViewBag.baocao = bc;
ViewBag.ngayden = ngayden;
ViewBag.ngaydi = ngaydi;
return(View("BaoCao"));
}
public List <BaoCaoDTDTO> getBaoCaoDT(string thang, string nam)
{
BaoCaoDAO dao = new BaoCaoDAO();
return(dao.getBaoCaoDT(thang, nam));
}
public static List <BCDoanhThuDTO> TinhTongDoanhThuTheoLoaiPhong()
{
return(BaoCaoDAO.TinhTongDoanhThuTheoLoaiPhong());
}
