public List<Pro_details_entity> Load_listpro(int _Catid)
{
try
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString()))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> load_ordenowHighlight(int limit)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_ORDERs
join b in db.ESHOP_ORDER_ITEMs on a.ORDER_ID equals b.ORDER_ID
join c in db.ESHOP_NEWs on b.NEWS_ID equals c.NEWS_ID
select new {
a.ORDER_ID,
c.NEWS_ID,
c.NEWS_TITLE,
c.NEWS_SEO_URL,
c.NEWS_URL,
c.NEWS_IMAGE3,
c.NEWS_PRICE1,
c.NEWS_PRICE2,
c.NEWS_FIELD3
}).Distinct().OrderByDescending(n => n.ORDER_ID).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_TITLE = i.NEWS_TITLE;
l.Add(pro);
}
return l;
}
public List<Pro_details_entity> Load_search_result(string _txt, int type, int _idcat)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
string test = ClearUnicode(_txt);
var list = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII.ToString(), ClearUnicode(_txt)) || SqlMethods.Like(a.NEWS_TITLE.ToString(), _txt))
&& b.CAT_TYPE == type &&(b.CAT_ID==_idcat||b.CAT_PARENT_PATH.Contains(_idcat.ToString()))
select new {a.NEWS_VIDEO_URL, a.NEWS_FIELD1, a.NEWS_FIELD2, a.NEWS_FIELD4, a.NEWS_FIELD5, a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, a.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER);
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_VIDEO_URL = i.NEWS_VIDEO_URL;
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD1 = i.NEWS_FIELD1;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD4 = i.NEWS_FIELD4;
pro.NEWS_FIELD5 = i.NEWS_FIELD5;
l.Add(pro);
}
return l;
}
public List<Pro_details_entity> Load_search_resultM(string _txt, int type, int skip, int limit)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode(_txt)) || "" == _txt || "%%" == _txt)
&& a.NEWS_TYPE == type
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, b.CAT_SEO_URL }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit);
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
//Pro or news hien thi trang chu
public List<Pro_details_entity> Loadindex(int type, int period, int limit)
{
try
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_PERIOD == period && b.NEWS_TYPE == type
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3,b.NEWS_PRICE1, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER_PERIOD).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> Load_Product_Cungloai(string _News_seo_url)
{
try
{
var s = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where a.NEWS_SEO_URL == _News_seo_url
select new { b.CAT_ID }).ToList();
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (b.NEWS_SEO_URL != _News_seo_url)
&& (c.CAT_ID == s[0].CAT_ID || c.CAT_PARENT_PATH.Contains(s[0].CAT_ID.ToString()))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_PRICE3, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_SENDDATE, b.NEWS_CODE, c.CAT_SEO_URL, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_FIELD3, b.NEWS_FIELD4 }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
//pro.NEWS_PRICE3 = Utils.CDecDef(i.NEWS_PRICE3);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
//pro.NEWS_SENDDATE = Utils.CDateDef(i.NEWS_SENDDATE, DateTime.Now);
pro.NEWS_CODE = i.NEWS_CODE;
pro.CAT_SEO_URL = i.CAT_SEO_URL;
//pro.NEWS_FIELD1 = i.NEWS_FIELD1;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
//pro.NEWS_FIELD3 = i.NEWS_FIELD3;
//pro.NEWS_FIELD4 = i.NEWS_FIELD4;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> Load_Product_Detail(string _News_seo_url)
{
try
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (b.NEWS_SEO_URL==_News_seo_url)
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_IMAGE2, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_FIELD2, b.NEWS_FIELD3, b.NEWS_FIELD4, b.NEWS_COUNT, b.UNIT_ID1, b.UNIT_ID2, b.UNIT_ID3, c.CAT_SEO_URL, b.SHOP_ID }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE2 = i.NEWS_IMAGE2;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER =Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE =Utils.CDateDef(i.NEWS_PUBLISHDATE,DateTime.Now);
pro.NEWS_CODE = i.NEWS_CODE;
pro.CAT_SEO_URL = i.CAT_SEO_URL;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.NEWS_FIELD4 = i.NEWS_FIELD4;
pro.NEWS_COUNT =Utils.CIntDef(i.NEWS_COUNT);
pro.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1);
pro.UNIT_ID2 = Utils.CIntDef(i.UNIT_ID2);
pro.UNIT_ID3 = Utils.CIntDef(i.UNIT_ID3);
pro.SHOP_ID = Utils.CIntDef(i.SHOP_ID);
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> loadProductByAll(int _catid, string _idbrand, int _pricetype, string _price, int _sortype)
{
List<decimal> lprice = new List<decimal>();
decimal pri1 = 0;
decimal pri2 = 0;
if (!String.IsNullOrEmpty(_price))
{
string[] a = _price.Split(',');
if (a.Length == 2)
{
pri1 = Utils.CDecDef(a[0]);
pri2 = Utils.CDecDef(a[1]);
}
else pri1 = Utils.CDecDef(a[0]);
}
string[] _strbrand = _idbrand.Split(',');
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == _catid || c.CAT_PARENT_PATH.Contains(_catid.ToString()))
&& (_strbrand.Contains(b.UNIT_ID1.ToString()) || _idbrand == "")
&& (_pricetype == 3 ? b.NEWS_PRICE1 < pri1 : (_pricetype == 1 ? b.NEWS_PRICE1 >= pri1 && b.NEWS_PRICE1 <= pri2 : (_pricetype == 2 ? b.NEWS_PRICE1 > pri1 : 0 == _pricetype)))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).Distinct();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
public List<Pro_details_entity> Load_search_result(string _txt,int type,int _idcat)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
string[] arr = _txt.Split(' ');
for (int s = 0; s < arr.Length; s++)
{
if (s == 0)
{
var list = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode("%" + arr[s] + "%")))
&& a.NEWS_TYPE == type && (_idcat != 0 ? (b.CAT_ID == _idcat || b.CAT_PARENT_PATH.Contains(_idcat.ToString())) : _idcat == 0)
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, a.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER);
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.CAT_SEO_URL = "";
l.Add(pro);
}
}
else
{
var list = l.Where(n => n.NEWS_TITLE.ToLower().Contains(arr[s].ToLower())).ToList();
if (list != null && list.Count > 0)
l = list;
}
}
return l;
}
public List<Pro_details_entity> loadSosanh(string _newseo,int limit)
{
int _catid = 0;
var getcatid = (from a in db.ESHOP_NEWs
join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID
where a.NEWS_SEO_URL==_newseo
select new{b.CAT_ID}).ToList();
if (getcatid.Count > 0)
_catid =Utils.CIntDef(getcatid[0].CAT_ID);
if (_catid != 0)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL != _newseo && c.CAT_ID==_catid
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_FIELD2, b.NEWS_FIELD3, b.NEWS_FIELD4, b.NEWS_COUNT, b.UNIT_ID1, b.UNIT_ID2, b.UNIT_ID3, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_CODE = i.NEWS_CODE;
pro.CAT_SEO_URL = i.CAT_SEO_URL;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.NEWS_FIELD4 = i.NEWS_FIELD4;
pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT);
pro.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1);
pro.UNIT_ID2 = Utils.CIntDef(i.UNIT_ID2);
pro.UNIT_ID3 = Utils.CIntDef(i.UNIT_ID3);
l.Add(pro);
}
return l;
}
return new List<Pro_details_entity>();
}
public IQueryable<Pro_details_entity> Load_pro_index_cate(object catid, int per, int skip, int limit)
{
try
{
int id = Utils.CIntDef(catid);
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == id || c.CAT_PARENT_PATH.Contains(id.ToString())) & b.NEWS_FIELD1 == per.ToString()
select new { b.NEWS_COUNT, b.NEWS_VIDEO_URL, b.NEWS_FIELD3, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_PRICE2, b.NEWS_PRICE1, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_PUBLISHDATE }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_VIDEO_URL = i.NEWS_VIDEO_URL;
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT);
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD1 = i.NEWS_FIELD1;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
l.Add(pro);
}
return l.AsQueryable();
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> Load_listpro(int _Catid, int _idhangsx, int _pricetype, string _price, int _sortype)
{
try
{
List<decimal> lprice = new List<decimal>();
decimal pri1 = 0;
decimal pri2 = 0;
if (!String.IsNullOrEmpty(_price))
{
string[] a = _price.Split(',');
if (a.Length == 2)
{
pri1 = Utils.CDecDef(a[0]);
pri2 = Utils.CDecDef(a[1]);
}
else pri1 = Utils.CDecDef(a[0]);
}
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString()))
select new {b.NEWS_VIDEO_URL, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_FIELD4, b.NEWS_FIELD5, b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_FIELD3 }).Distinct();
switch (_sortype)
{
case 1: list = list.OrderBy(n => n.NEWS_TITLE); break;
case 2: list = list.OrderByDescending(n => n.NEWS_TITLE); break;
case 3: list = list.OrderByDescending(n => n.NEWS_PRICE1); break;
case 4: list = list.OrderBy(n => n.NEWS_PRICE1); break;
case 5: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderByDescending(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break;
case 6: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderBy(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break;
default: list = list.OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER); break;
}
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_VIDEO_URL = i.NEWS_VIDEO_URL;
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.NEWS_FIELD1 = i.NEWS_FIELD1;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD4 = i.NEWS_FIELD4;
pro.NEWS_FIELD5 = i.NEWS_FIELD5;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
//Load random
public List<Pro_details_entity> loadPro_Random(string _new_seo,int limit)
{
List<int> lpos = new List<int>();
List<Pro_details_entity> l = new List<Pro_details_entity>();
Random rdom = new Random();
var getallList = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL!=_new_seo && b.NEWS_TYPE==1
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_FIELD2, b.NEWS_FIELD3, c.CAT_SEO_URL }) .Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList();
if (getallList.Count > 0)
{
for (int i = 0; i < limit; i++)
{
int pos = rdom.Next(1, getallList.Count - 1);
if (!lpos.Contains(pos))
{
lpos.Add(pos);
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = getallList[pos].NEWS_ID;
pro.NEWS_TITLE = getallList[pos].NEWS_TITLE;
pro.NEWS_IMAGE3 = getallList[pos].NEWS_IMAGE3;
pro.NEWS_DESC = getallList[pos].NEWS_DESC;
pro.NEWS_SEO_URL = getallList[pos].NEWS_SEO_URL;
pro.NEWS_URL = getallList[pos].NEWS_URL;
pro.CAT_SEO_URL = getallList[pos].CAT_SEO_URL;
pro.NEWS_ORDER = Utils.CIntDef(getallList[pos].NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(getallList[pos].NEWS_ORDER_PERIOD);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(getallList[pos].NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_PRICE1 = Utils.CDecDef(getallList[pos].NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(getallList[pos].NEWS_PRICE2);
l.Add(pro);
}
}
}
return l;
}
public List<Pro_details_entity> loadProductByBrandId(int _idbrand)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.UNIT_ID1 == _idbrand
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).Distinct();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
public List<Pro_details_entity> Load_search_resultMore(string _txt, int type, int _idcat,int _skip,int _limit)
{
if (_txt.Contains("Từ khóa tìm kiếm"))
_txt = "";
_txt = "%" + _txt + "%";
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode(_txt)) || "" == _txt || "%%" == _txt)
&& a.NEWS_TYPE == type && (_idcat != 0 ? (b.CAT_ID == _idcat || b.CAT_PARENT_PATH.Contains(_idcat.ToString())) : _idcat == 0)
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, a.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER).Skip(_skip).Take(_limit);
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.CAT_SEO_URL = "";
l.Add(pro);
}
return l;
}
public List<Pro_details_entity> LoadProductsHome(int _catid, int pos)
{
try
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
if (pos == 3)
{
var list = ((from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == _catid || c.CAT_PARENT_PATH.Contains(_catid.ToString()))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).Distinct());
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
}
return l.ToList();
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return null;
}
}
public List<Pro_details_entity> Load_search_resultBrand(string _txt, int cat, int type, int _Brand, int _pricetype, string _price)
{
List<decimal> lprice = new List<decimal>();
decimal pri1 = 0;
decimal pri2 = 0;
if (!String.IsNullOrEmpty(_price))
{
string[] a = _price.Split(',');
if (a.Length == 2)
{
pri1 = Utils.CDecDef(a[0]);
pri2 = Utils.CDecDef(a[1]);
}
else pri1 = Utils.CDecDef(a[0]);
}
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode(_txt)) || "" == _txt || "%%" == _txt)
&& (b.CAT_ID == cat || b.CAT_PARENT_PATH.Contains(cat.ToString()) || cat == 0)
&& a.NEWS_TYPE == type
&& (a.UNIT_ID3 == _Brand || 0 == _Brand)
&& (_pricetype == 3 ? a.NEWS_PRICE2 < pri1 : (_pricetype == 1 ? a.NEWS_PRICE2 >= pri1 && a.NEWS_PRICE2 <= pri2 : (_pricetype == 2 ? a.NEWS_PRICE2 > pri1 : 0 == _pricetype)))
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, b.CAT_SEO_URL }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER);
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
//Load similar
public List<Pro_details_entity> Load_Similar_Product(string News_Seo_Url)
{
try
{
List<Pro_details_entity> l=new List<Pro_details_entity>();
var _vCatID = from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_SEO_URL == News_Seo_Url
select new { c.CAT_ID, c.CAT_PARENT_ID, b.NEWS_TYPE };
if (_vCatID.ToList().Count > 0)
{
var _vProduct = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
where a.NEWS_TYPE == _vCatID.ToList()[0].NEWS_TYPE && (c.CAT_ID == _vCatID.ToList()[0].CAT_ID || c.CAT_ID == _vCatID.ToList()[0].CAT_PARENT_ID)
&& a.NEWS_SHOWINDETAIL == 1 && a.NEWS_SEO_URL != News_Seo_Url
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE,a.NEWS_PRICE1, c.ESHOP_CATEGORy.CAT_SEO_URL });
foreach (var i in _vProduct)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
}
return l;
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return null;
}
}
public List<Pro_details_entity> getProinfo(int id)
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWs
join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID
where a.NEWS_ID == id
select new
{
a.NEWS_ID,
a.NEWS_TITLE,
a.NEWS_DESC,
a.NEWS_SEO_URL,
a.NEWS_URL,
a.NEWS_PRICE1,
a.UNIT_ID1,
a.UNIT_ID2,
a.NEWS_FIELD2,
a.NEWS_IMAGE3,
b.ESHOP_CATEGORy.CAT_SEO_URL
}).ToList();
foreach (var i in list)
{
Pro_details_entity enti = new Pro_details_entity();
enti.NEWS_ID = i.NEWS_ID;
enti.NEWS_TITLE = i.NEWS_TITLE;
enti.NEWS_DESC = i.NEWS_DESC;
enti.NEWS_PRICE1 =Utils.CDecDef(i.NEWS_PRICE1);
enti.NEWS_FIELD2 = i.NEWS_FIELD2;
enti.NEWS_URL = i.NEWS_URL;
enti.NEWS_SEO_URL = i.NEWS_SEO_URL;
enti.CAT_SEO_URL = i.CAT_SEO_URL;
enti.NEWS_IMAGE3 = i.NEWS_IMAGE3;
enti.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1);
enti.UNIT_ID2 = Utils.CIntDef(i.UNIT_ID2);
l.Add(enti);
}
return l;
}
//Getpro cookie
public List<Pro_details_entity> Loadpro_cookie(int type, List<string> listnews_url)
{
try
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_TYPE == type && listnews_url.Contains(b.NEWS_SEO_URL)
select new { b.NEWS_ID, b.UNIT_ID1, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_COUNT, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_CODE = i.NEWS_CODE;
pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT);
pro.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> loadproAjax(int _Catid, int skip, int limit)
{
bool checkhsx = checkHangsx(_Catid);
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (checkhsx==true ? b.UNIT_ID2==_Catid : c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString()))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
l.Add(pro);
}
return l;
}
//xuat xu
public List<Pro_details_entity> loadProhangXuatxu(int _catid, int _pricetype, string _price, int _sortype)
{
List<decimal> lprice = new List<decimal>();
decimal pri1 = 0;
decimal pri2 = 0;
if (!String.IsNullOrEmpty(_price))
{
string[] a = _price.Split(',');
if (a.Length == 2)
{
pri1 = Utils.CDecDef(a[0]);
pri2 = Utils.CDecDef(a[1]);
}
else pri1 = Utils.CDecDef(a[0]);
}
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.UNIT_ID1 == _catid
&& (_pricetype == 3 ? b.NEWS_PRICE2 < pri1 : (_pricetype == 1 ? b.NEWS_PRICE2 >= pri1 && b.NEWS_PRICE2 <= pri2 : (_pricetype == 2 ? b.NEWS_PRICE2 > pri1 : 0 == _pricetype)))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_FIELD3 }).Distinct();
switch (_sortype)
{
case 1: list = list.OrderBy(n => n.NEWS_TITLE); break;
case 2: list = list.OrderByDescending(n => n.NEWS_TITLE); break;
case 3: list = list.OrderByDescending(n => n.NEWS_PRICE1); break;
case 4: list = list.OrderBy(n => n.NEWS_PRICE1); break;
case 5: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderByDescending(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break;
case 6: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderBy(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break;
default: list = list.OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER); break;
}
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
l.Add(pro);
}
return l;
}
public List<Pro_details_entity> Load_listproHasBrand(int _Catid, int _Brand, int _pricetype, string _price)
{
try
{
List<decimal> lprice = new List<decimal>();
decimal pri1 = 0;
decimal pri2 = 0;
if (!String.IsNullOrEmpty(_price))
{
string[] a = _price.Split(',');
if (a.Length == 2)
{
pri1 = Utils.CDecDef(a[0]);
pri2 = Utils.CDecDef(a[1]);
}
else pri1 = Utils.CDecDef(a[0]);
}
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString()))
&& (b.UNIT_ID3 == _Brand || 0 == _Brand)
&& (_pricetype == 3 ? b.NEWS_PRICE2 < pri1 : (_pricetype == 1 ? b.NEWS_PRICE2 >= pri1 && b.NEWS_PRICE2 <= pri2 : (_pricetype == 2 ? b.NEWS_PRICE2 > pri1 : 0 == _pricetype)))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
public IQueryable<Pro_details_entity> Load_pro_index_cate(object catid, int period, int limit)
{
try
{
int id = Utils.CIntDef(catid);
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where b.NEWS_PERIOD == period && (c.CAT_ID == id || c.CAT_PARENT_PATH.Contains(id.ToString()))
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER_PERIOD).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l.AsQueryable();
}
catch (Exception)
{
throw;
}
}
public List<Pro_details_entity> Load_listproGoiY(int limit)
{
try
{
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where c.CAT_TYPE == 1
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderBy(x => Guid.NewGuid()).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l;
}
catch (Exception)
{
throw;
}
}
