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_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;
}
}
//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.NEWS_TITLE, b.NEWS_IMAGE1, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, 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).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_IMAGE1 = i.NEWS_IMAGE1;
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_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
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> 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);
}
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> 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 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_IMAGE1, b.NEWS_IMAGE2, b.NEWS_IMAGE4, 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_FIELD5, 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_IMAGE1 = i.NEWS_IMAGE1;
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_FIELD5 = i.NEWS_FIELD5;
pro.NEWS_IMAGE4 = i.NEWS_IMAGE4;
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> Load_search_result(string _txt,int type,int _idcat)
//{
// 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_CODE.Contains(_txt.Replace("%",string.Empty)))
// && 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);
// }
// 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] + "%")))
where (SqlMethods.Like(db.fClearUnicode(a.NEWS_TITLE), 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);
}
//Load similar
public List <Pro_details_entity> Load_Similar_Product(string News_Seo_Url, int limit)
{
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_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, a.NEWS_PRICE2, c.ESHOP_CATEGORy.CAT_SEO_URL, a.NEWS_FIELD3 }).OrderByDescending(n => n.NEWS_PUBLISHDATE).Take(limit);
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.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
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> 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) &&
b.NEWS_SHOWTYPE == 1
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_IMAGE4, b.NEWS_PRICE1, b.NEWS_DESC, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, c.CAT_SEO_URL, c.CAT_ID, b.PHONE, b.ADDRESS, b.GOOPMAPSLINK, b.EMAIL, b.NEWS_TAB }).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_IMAGE4 = i.NEWS_IMAGE4;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_FIELD1 = i.NEWS_FIELD1;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
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.NEWS_CODE = i.NEWS_CODE;
pro.CAT_SEO_URL = i.CAT_SEO_URL;
pro.CAT_ID = i.CAT_ID;
pro.PHONE = i.PHONE;
pro.ADDRESS = i.ADDRESS;
pro.GOOGLEMAPSLINK = i.GOOPMAPSLINK;
pro.EMAIL = i.EMAIL;
pro.NEWS_TAB = Utils.CIntDef(i.NEWS_TAB);
l.Add(pro);
}
return(l);
}
catch (Exception)
{
throw;
}
}
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);
}
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;
}
}
//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 > 3)
{
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.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);
pro.CAT_SEO_URL = getallList[pos].CAT_SEO_URL;
l.Add(pro);
}
}
}
return(l);
}
public List <Pro_details_entity> loadlistcarousel(int limit, int lang)
{
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 == 2 || b.NEWS_TYPE == 1) &&
c.CAT_LANGUAGE == lang
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_IMAGE4, 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).Distinct().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_IMAGE4 = i.NEWS_IMAGE4;
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;
}
}
//Pro or news hien thi trang chu
public List <Pro_details_entity> Loadindex(int type, int period, int lang, 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 &&
(c.CAT_LANGUAGE == lang || lang == -1)
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, b.NEWS_FIELD2, b.NEWS_FIELD3 }).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;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
l.Add(pro);
}
return(l);
}
catch (Exception)
{
throw;
}
}
//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_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, 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_listpro(int _Catid, int _idhangsx, int _pricetype, string _price, int _sortype, string _param)
{
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]);
}
}
string[] paramth = new string[50];
if (!String.IsNullOrEmpty(_param))
{
paramth = _param.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())) &&
(_pricetype == 3 ? (b.NEWS_PRICE2 != 0 ? b.NEWS_PRICE2 < pri1 : b.NEWS_PRICE1 < pri1) : (_pricetype == 1 ? (b.NEWS_PRICE2 != 0 ? b.NEWS_PRICE2 >= pri1 && b.NEWS_PRICE2 <= pri2 : b.NEWS_PRICE1 >= pri1 && b.NEWS_PRICE1 <= pri2) : (_pricetype == 2 ? (b.NEWS_PRICE2 != 0 ? b.NEWS_PRICE2 > pri1 : b.NEWS_PRICE1 > pri1) : 0 == _pricetype))) &&
(!String.IsNullOrEmpty(_param) ? paramth.Contains(b.UNIT_ID2.ToString()) : true)
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.Where(n => n.NEWS_PRICE1 != 0).OrderByDescending(n => (n.NEWS_PRICE1 > n.NEWS_PRICE2 ? n.NEWS_PRICE1 : n.NEWS_PRICE2)); break;
case 4: list = list.Where(n => n.NEWS_PRICE1 != 0).OrderBy(n => (n.NEWS_PRICE1 > n.NEWS_PRICE2 ? n.NEWS_PRICE1 : n.NEWS_PRICE2)); 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);
}
catch (Exception)
{
throw;
}
}
public List <Pro_details_entity> Load_listprobytype(int type, int _Catid, int tinhtranghoso, int lang)
{
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_SHOWTYPE == 1 && //&& b.NEWS_LANGUAGE == lang
(c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString()) || _Catid == 0)
//&& b.NEWS_TYPE == c.CAT_TYPE
&& (b.TINHTRANGHOSO == tinhtranghoso || tinhtranghoso == 0) &&
b.NEWS_TYPE == type
//&& c.CAT_LANGUAGE == lang
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_IMAGE4, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_COUNT, c.CAT_SEO_URL, c.CAT_ORDER, c.CAT_RANK, b.PHONE, b.ADDRESS, b.GOOPMAPSLINK, b.CUSTOMER_ID,
b.NEWS_UPDATE, b.NEWS_UPDATEFRERESH, b.NEWS_DEALINE,
b.SOLUONGTUYEN,
b.MOTACONGVIEC,
b.TINHTRANGHOSO,
b.VL_CAOBAC_ID,
b.VL_DOTUOI_ID,
b.VL_HINHTHUCLAMVIEC_ID,
b.VL_HINHTHUCNOPHOSO_ID,
b.VL_KINHNGHIEM_ID,
b.VL_MUCLUONG_ID,
b.VL_NGOAINGU_ID,
b.VL_TRINHDOHOCVAN_ID,
b.VL_TRINHDONGOAINGU_ID,
b.VL_TRUONGTOTNGHIEP_ID,
b.QUATRINHLAMVIEC }).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_IMAGE4 = i.NEWS_IMAGE4;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.CAT_RANK = Utils.CIntDef(i.CAT_RANK);
pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT);
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.NEWS_UPDATE = Utils.CDateDef(i.NEWS_UPDATE, DateTime.Now);
pro.NEWS_UPDATEFRERESH = Utils.CDateDef(i.NEWS_UPDATEFRERESH, DateTime.Now);
pro.NEWS_DEALINE = Utils.CDateDef(i.NEWS_DEALINE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
pro.PHONE = i.PHONE;
pro.ADDRESS = i.ADDRESS;
pro.GOOGLEMAPSLINK = i.GOOPMAPSLINK;
pro.CUSTOMER_ID = Utils.CIntDef(i.CUSTOMER_ID);
pro.MOTACONGVIEC = i.MOTACONGVIEC;
pro.SOLUONGTUYEN = Utils.CIntDef(i.SOLUONGTUYEN);
pro.TINHTRANGHOSO = Utils.CIntDef(i.TINHTRANGHOSO);
pro.QUATRINHLAMVIEC = i.QUATRINHLAMVIEC;
pro.VL_CAOBAC_ID = Utils.CIntDef(i.VL_CAOBAC_ID);
pro.VL_HINHTHUCLAMVIEC_ID = Utils.CIntDef(i.VL_HINHTHUCLAMVIEC_ID);
pro.VL_MUCLUONG_ID = Utils.CIntDef(i.VL_MUCLUONG_ID);
pro.VL_DOTUOI_ID = Utils.CIntDef(i.VL_DOTUOI_ID);
pro.VL_HINHTHUCNOPHOSO_ID = Utils.CIntDef(i.VL_HINHTHUCNOPHOSO_ID);
pro.VL_KINHNGHIEM_ID = Utils.CIntDef(i.VL_KINHNGHIEM_ID);
pro.VL_TRINHDOHOCVAN_ID = Utils.CIntDef(i.VL_TRINHDOHOCVAN_ID);
pro.VL_NGOAINGU_ID = Utils.CIntDef(i.VL_NGOAINGU_ID);
pro.VL_TRINHDONGOAINGU_ID = Utils.CIntDef(i.VL_TRINHDONGOAINGU_ID);
pro.VL_TRUONGTOTNGHIEP_ID = Utils.CIntDef(i.VL_TRUONGTOTNGHIEP_ID);
l.Add(pro);
}
return(l);
}
catch (Exception)
{
throw;
}
}
