public VanBanChildBO GetBO(long id)
{
var result = (from vb in this.context.QUANLY_VANBAN
join mst in this.context.DM_DANHMUC_DATA
on vb.COQUAN_BANHANH_ID equals(int) mst.ID
into group1
from gCoQuanBanHanh in group1.DefaultIfEmpty()
join tl in this.context.TAILIEUDINHKEM
on vb.HOSO_ID equals tl.ITEM_ID
into group2
from gTaiLieu in group2.DefaultIfEmpty()
where vb.ID == id
select new VanBanChildBO
{
HOSO_ID = vb.HOSO_ID.Value,
COQUAN_BANHANH_ID = vb.COQUAN_BANHANH_ID,
VANBAN_ID = vb.ID,
COQUAN_BANHANH_NAME = gCoQuanBanHanh.TEXT,
NGAYBANHANH = vb.NGAYBANHANH,
SO_KYHIEU = vb.SO_KYHIEU,
TRICHYEU_VANBAN = vb.TRICHYEU_VANBAN,
TAILIEU_ID = gTaiLieu.TAILIEU_ID,
TAILIEU_NAME = gTaiLieu.TENTAILIEU
}).FirstOrDefault();
if (result != null)
{
// public const int VANBAN = 1999;
var listTailieu = new TAILIEUDINHKEMBusiness(new UnitOfWork()).GetDataByItemID(result.VANBAN_ID, 1999);
if (listTailieu.Any())
{
var taiLieu = listTailieu.FirstOrDefault();
if (taiLieu != null)
{
result.TAILIEU_ID = taiLieu.TAILIEU_ID;
result.TAILIEU_NAME = taiLieu.TENTAILIEU;
}
}
result.NGAYBANHANH_FORMAT = string.Format("{0:dd/MM/yyyy}", result.NGAYBANHANH);
return(result);
}
return(new VanBanChildBO());
}
public List <VanBanChildBO> GetByHoSo(long?hoSoId = 0)
{
var result = (from vb in this.context.QUANLY_VANBAN
join mst in this.context.DM_DANHMUC_DATA
on vb.COQUAN_BANHANH_ID equals(int) mst.ID
into group1
from gCoQuanBanHanh in group1.DefaultIfEmpty()
where vb.HOSO_ID == hoSoId
select new VanBanChildBO
{
HOSO_ID = vb.HOSO_ID.Value,
COQUAN_BANHANH_ID = vb.COQUAN_BANHANH_ID,
VANBAN_ID = vb.ID,
COQUAN_BANHANH_NAME = gCoQuanBanHanh.TEXT,
NGAYBANHANH = vb.NGAYBANHANH,
SO_KYHIEU = vb.SO_KYHIEU,
TRICHYEU_VANBAN = vb.TRICHYEU_VANBAN
}).ToList();
if (result.Any())
{
foreach (var item in result)
{
// public const int VANBAN = 1999;
var listTailieu = new TAILIEUDINHKEMBusiness(new UnitOfWork()).GetDataByItemID(item.VANBAN_ID, 1999);
if (listTailieu.Any())
{
var taiLieu = listTailieu.FirstOrDefault();
if (taiLieu != null)
{
item.TAILIEU_ID = taiLieu.TAILIEU_ID;
item.TAILIEU_NAME = taiLieu.TENTAILIEU;
}
}
item.NGAYBANHANH_FORMAT = string.Format("{0:dd/MM/yyyy}", item.NGAYBANHANH);
}
return(result);
}
return(new List <VanBanChildBO>());
}
