private IQueryable<ThongTinGiaBaoModel> BuildQuery(ThongTinGiaBaoSearchModel search, string idBao, int status = 1, List<string> lstInclude = null)
        {
            string include = string.Empty;
            IQueryable<BThongTinGiaBao> qThongTinGiaBao = db.BThongTinGiaBaos;
            if (lstInclude != null && lstInclude.Count > 0)
                foreach (string item in lstInclude)
                    qThongTinGiaBao = qThongTinGiaBao.Include(item);

            IQueryable<ThongTinGiaBaoModel> query = (from u in qThongTinGiaBao//.Include(a=>a.)
                                                      where u.Status == status && u.ThongTinBaoId == idBao
                                                      select new ThongTinGiaBaoModel()
                                                      {
                                                          Id = u.Id,
                                                          ThongTinBaoId = u.ThongTinBaoId,
                                                          NgayHieuLuc = u.NgayHieuLuc,
                                                          NgayHetHieuLuc = u.NgayHetHieuLuc,
                                                          ProvinceCode = u.ProvinceCode,
                                                          QuyetDinh = u.QuyetDinh,
                                                          ValueType = u.ValueType,
                                                          Value = u.Value.ToString(),
                                                          MaBao = u.BThongTinBao != null ? u.BThongTinBao.MaBao : "",
                                                          TenBao = u.BThongTinBao != null ? u.BThongTinBao.TenBao : "",
                                                          BaoTrungUongDiaPhuong =  u.BThongTinBao.BaoTrungUongDiaPhuong,
                                                          BaoTrongMucLuc = u.BThongTinBao.BaoTrongMucLuc
                                                      }).OrderBy(a => a.Id);
            //Neu co include thi them include vao
            if (lstInclude != null && lstInclude.Count > 0)
                foreach (string item in lstInclude)
                    qThongTinGiaBao = qThongTinGiaBao.Include(item);
            if (search != null)
            {
                if (!string.IsNullOrWhiteSpace(search.Search))
                {
                    //string giaFrom = search.Search.Trim().Split(',')[0];
                    //string giaTo = search.Search.Trim().Split(',')[1];
                    //query = query.Where(a => Convert.ToDecimal(a.Value) >= Convert.ToDecimal(giaFrom) && Convert.ToDecimal(a.Value) <= Convert.ToDecimal(giaTo));
                    query = query.Where(a => a.MaBao.Contains(search.Search) || a.TenBao.Contains(search.Search));
                }
                if (!string.IsNullOrWhiteSpace(search.Value))
                    query = query.Where(a=>a.Value.CompareTo(search.Value)==0);
                if (!string.IsNullOrWhiteSpace(search.Id))
                    query = query.Where(a => a.Id.CompareTo(search.Id) == 0);
                if (!string.IsNullOrWhiteSpace(search.ThongTinBaoId))
                    query = query.Where(a => a.ThongTinBaoId.Contains(search.ThongTinBaoId));

            }
            return query;
        }
        private IQueryable<BThongTinGiaBaoModel> BuildQuery(ThongTinGiaBaoSearchModel search, int status = 1, List<string> lstInclude = null)
        {
            string include = string.Empty;
            IQueryable<BThongTinGiaBao> qThongTinGiaBao = db.BThongTinGiaBaos;
            if (lstInclude != null && lstInclude.Count > 0)
                foreach (string item in lstInclude)
                    qThongTinGiaBao = qThongTinGiaBao.Include(item);

            IQueryable<BThongTinGiaBaoModel> query = (from u in qThongTinGiaBao//.Include(a=>a.)
                                                      where u.Status == status
                                                      select new BThongTinGiaBaoModel()
                                                      {
                                                          Id = u.Id,
                                                          ThongTinBaoId = u.ThongTinBaoId,
                                                          NgayHieuLuc = u.NgayHieuLuc,
                                                          NgayHetHieuLuc = u.NgayHetHieuLuc,
                                                          ProvinceCode = u.ProvinceCode,
                                                          QuyetDinh = u.QuyetDinh,
                                                          ValueType = u.ValueType,
                                                          Value = u.Value,
                                                          MaBao = u.BThongTinBao != null ? u.BThongTinBao.MaBao : "",
                                                          TenBao = u.BThongTinBao != null ? u.BThongTinBao.TenBao : ""
                                                      }).OrderBy(a => a.ThongTinBaoId);
            //Neu co include thi them include vao
            if (lstInclude != null && lstInclude.Count > 0)
                foreach (string item in lstInclude)
                    qThongTinGiaBao = qThongTinGiaBao.Include(item);
            if (search != null)
            {
                if (!string.IsNullOrWhiteSpace(search.Id))
                    query = query.Where(a => a.Id.CompareTo(search.Id) == 0);
                if (!string.IsNullOrWhiteSpace(search.ThongTinBaoId))
                    query = query.Where(a => a.ThongTinBaoId.Contains(search.ThongTinBaoId));

            }
            return query;
        }
 public List<ThongTinGiaBaoModel> searchThongTinGiaBao(ThongTinGiaBaoSearchModel thongTinGiaBaoSearchModel)
 {
     int active = (int)Enums.RecordStatusCode.active;
     return BuildQuery(thongTinGiaBaoSearchModel, null, active, null).ToList();
 }
 public List<BThongTinGiaBaoModel> searchThongTinGiaBao(ThongTinGiaBaoSearchModel thongTinGiaBaoSearchModel)
 {
     int active = (int)Enums.RecordStatusCode.active;
     return BuildQuery(thongTinGiaBaoSearchModel, active, null).ToList();
     // throw new NotImplementedException();
 }