public ActionResult TinhLuong(EBatDongSansearch batdongsansearch, ESale sale, string Submit)
{
int idnhanvien = Convert.ToInt32(Session["nhanvien"]);
if (idnhanvien != 0)
{
ViewBag.tennhanvien = db.NhanViens.Where(x => x.ID == idnhanvien).FirstOrDefault().HoTen;
}
else
{
return(RedirectToAction("../Home/Login"));
}
if (Submit == "Export")
{
var gv = new GridView();
gv.DataSource = this.GetExportPhanCong(batdongsansearch, sale);
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=ThongKeDoanhThu.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
}
var dsdoanhthu = GetPhancongtheothoigian(batdongsansearch, sale);
var model = from o in dsdoanhthu
select new EPhanCongSales
{
ID = o.ID,
IDBatDongSan = o.IDBatDongSan,
TenBatDongSan = o.BatDongSan.TenBatDongSan,
IDSales = o.IDSales,
TenSale = o.Sale.TenSales,
PhanTramHoaHong_string = o.PhanTramHoaHong * 100 + " %",
NgayTao = o.NgayTao,
GiaBatDongSan = o.BatDongSan.Gia + " " + o.BatDongSan.DonVi.TenDonVi,
HoaHong = (double)o.BatDongSan.Gia * o.PhanTramHoaHong + " " + o.BatDongSan.DonVi.TenDonVi,
};
ViewBag.ngaycapnhattu = batdongsansearch.NgayCapNhatTu.ToString(string.Format("yyyy-MM-dd"));
ViewBag.ngaycapnhatden = batdongsansearch.NgayCapNhatDen.ToString(string.Format("yyyy-MM-dd"));
ViewBag.listsales = db.Sales.ToList();
if (Session["nhanvien"] != null)
{
return(View(model));
}
else
{
return(RedirectToAction("../Home/Login"));
}
}
public ActionResult XemHoaHong(EBatDongSansearch batdongsansearch, ESale sale, string Submit)
{
int idsale = Convert.ToInt32(Session["sale"]);
if (idsale != 0)
{
ViewBag.tensale = db.Sales.Where(x => x.ID == idsale).FirstOrDefault().TenSales;
}
else
{
return(RedirectToAction("../Home/Login"));
}
var dsdoanhthu = GetPhancongtheothoigian(batdongsansearch, idsale);
var model = from o in dsdoanhthu
select new EPhanCongSales
{
ID = o.ID,
IDBatDongSan = o.IDBatDongSan,
TenBatDongSan = o.BatDongSan.TenBatDongSan,
IDSales = o.IDSales,
TenSale = o.Sale.TenSales,
PhanTramHoaHong_string = o.PhanTramHoaHong * 100 + " %",
NgayTao = o.NgayTao,
GiaBatDongSan = o.BatDongSan.Gia + " " + o.BatDongSan.DonVi.TenDonVi,
HoaHong = (double)o.BatDongSan.Gia * o.PhanTramHoaHong + " " + o.BatDongSan.DonVi.TenDonVi,
};
ViewBag.ngaycapnhattu = batdongsansearch.NgayCapNhatTu.ToString(string.Format("yyyy-MM-dd"));
ViewBag.ngaycapnhatden = batdongsansearch.NgayCapNhatDen.ToString(string.Format("yyyy-MM-dd"));
ViewBag.listsales = db.Sales.ToList();
if (Session["sale"] != null)
{
return(View(model));
}
else
{
return(RedirectToAction("../Home/Login"));
}
}
public List <ExportPhanCong> GetExportPhanCong(EBatDongSansearch batdongsansearch, ESale sale)
{
var dsphancong = GetPhancongtheothoigian(batdongsansearch, sale);
List <ExportPhanCong> exportphancong = new List <ExportPhanCong>();
foreach (var item in dsphancong)
{
exportphancong.Add(new ExportPhanCong
{
TenBatDongSan = item.BatDongSan.TenBatDongSan,
TenSale = item.Sale.TenSales,
Gia = item.BatDongSan.Gia + " " + item.BatDongSan.DonVi.TenDonVi,
PhanTramHoaHong = item.PhanTramHoaHong * 100 + " %",
HoaHong = item.BatDongSan.Gia * item.PhanTramHoaHong + " " + item.BatDongSan.DonVi.TenDonVi,
});
}
return(exportphancong);
}
public IQueryable <PhanCong> GetPhancongtheothoigian(EBatDongSansearch batdongsansearch, ESale sale)
{
//DateTime dt = DateTime.MinValue;
var result = db.PhanCongs.Where(x => x.BatDongSan.TrangThai == 4).ToList();
//if (batdongsansearch.NgayCapNhatTu != dt)
result = result.Where(x => x.BatDongSan.NgayCapNhat >= batdongsansearch.NgayCapNhatTu).ToList();
//if (batdongsansearch.NgayCapNhatDen != dt)
result = result.Where(x => x.BatDongSan.NgayCapNhat <= batdongsansearch.NgayCapNhatDen).ToList();
if (sale.ID != 0)
{
result = result.Where(x => x.IDSales == sale.ID).ToList();
}
return(result.AsQueryable());
}
