//Get oder_code
private string Getorder_code()
{
try
{
var _vOrderShop = db.GetTable <ESHOP_ORDER>().OrderByDescending(a => a.ORDER_ID);
int iNo = 0;
string _sMonth = string.Empty;
string _sDay = string.Empty;
if (_vOrderShop.ToList().Count > 0)
{
iNo = _vOrderShop.ToList().Count > 0 ? Utils.CIntDef(_vOrderShop.ToList()[0].ORDER_ID) + 1 : 1;
_sMonth = DateTime.Now.Month.ToString().Length == 1 ? "0" + Utils.CStrDef(DateTime.Now.Month) : Utils.CStrDef(DateTime.Now.Month);
_sDay = DateTime.Now.Day.ToString().Length == 1 ? "0" + Utils.CStrDef(DateTime.Now.Day) : Utils.CStrDef(DateTime.Now.Day);
}
string _sOrderCode = DateTime.Now.Year + _sMonth + _sDay + "_" + iNo;
return(_sOrderCode);
}
catch (Exception)
{
throw;
}
}
public bool Update_cart(Guid _guid, int NEWS_ID, int quantity)
{
try
{
if (quantity < 0 || quantity > 20)
{
return(false);
}
else
{
var g = db.GetTable <ESHOP_BASKET>().Where(gid => gid.NEWS_ID == NEWS_ID && gid.CUSTOMER_OID == _guid);
if (g.ToList().Count > 0)
{
if (quantity == 0)
{
db.ESHOP_BASKETs.DeleteAllOnSubmit(g);
db.SubmitChanges();
}
else
{
g.ToList()[0].BASKET_QUANTITY = quantity;
db.SubmitChanges();
}
}
return(true);
}
}
catch (Exception)
{
throw;
}
}
public void LoadCatInfo(string _catSeoUrl)
{
try
{
var cats = db.GetTable <ESHOP_CATEGORy>().Where(c => c.CAT_SEO_URL == _catSeoUrl).ToList();
if (cats.Count > 0)
{
#region Bind Cat Info
HttpContext.Current.Session["Cat_id"] = cats[0].CAT_ID;
HttpContext.Current.Session["Cat_seo_url"] = cats[0].CAT_SEO_URL;
HttpContext.Current.Session["Cat_img1"] = cats[0].CAT_IMAGE1;
HttpContext.Current.Session["Cat_showitem"] = cats[0].CAT_SHOWITEM;
HttpContext.Current.Session["Cat_type"] = cats[0].CAT_TYPE;
HttpContext.Current.Session["Cat_desc"] = cats[0].CAT_DESC;
HttpContext.Current.Session["Cat_name"] = cats[0].CAT_NAME;
HttpContext.Current.Session["Cat_seo_title"] = cats[0].CAT_SEO_TITLE;
HttpContext.Current.Session["Cat_seo_desc"] = cats[0].CAT_SEO_DESC;
HttpContext.Current.Session["Cat_seo_keyword"] = cats[0].CAT_SEO_KEYWORD;
HttpContext.Current.Session["News_type"] = null;
#endregion
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
//Config mail
public List <ESHOP_EMAIL> Getemail(int stt)
{
//stt=2 contact
var _ccMail = db.GetTable <ESHOP_EMAIL>().Where(c => c.EMAIL_STT == stt).ToList();
return(_ccMail);
}
// Show html
public string Show_File_HTML(int _newsID, string htmExt)
{
try
{
string pathFile;
string strHTMLContent;
string _result = string.Empty;
if (_newsID > 0)
{
var newsInfo = db.GetTable <ESHOP_NEW>().Where(n => n.NEWS_ID == _newsID);
if (newsInfo.ToList().Count > 0)
{
//pathFile = HttpContext.Current.Server.MapPath(PathFiles.GetPathNews(_newsID) + "/" + _newsID.ToString() + htmExt);
pathFile = HttpContext.Current.Server.MapPath("/htm/" + _newsID.ToString() + htmExt);
if ((File.Exists(pathFile)))
{
StreamReader objNewsReader;
objNewsReader = new StreamReader(pathFile);
strHTMLContent = objNewsReader.ReadToEnd();
objNewsReader.Close();
_result = strHTMLContent;
}
}
}
return(_result);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return("");
}
}
public void LoadCatInfo(string _catSeoUrl)
{
try
{
var cats = db.GetTable <ESHOP_CATEGORy>().Where(c => c.CAT_SEO_URL == _catSeoUrl);
if (cats.ToList().Count > 0)
{
#region Bind Cat Info
HttpContext.Current.Session["Cat_access"] = cats.ToList()[0].CAT_ACCESS;
HttpContext.Current.Session["Cat_code"] = cats.ToList()[0].CAT_CODE;
HttpContext.Current.Session["Cat_count"] = cats.ToList()[0].CAT_COUNT;
HttpContext.Current.Session["Cat_field1"] = cats.ToList()[0].CAT_FIELD1;
HttpContext.Current.Session["Cat_field2"] = cats.ToList()[0].CAT_FIELD2;
HttpContext.Current.Session["Cat_field3"] = cats.ToList()[0].CAT_FIELD3;
HttpContext.Current.Session["Cat_field4"] = cats.ToList()[0].CAT_FIELD4;
HttpContext.Current.Session["Cat_field5"] = cats.ToList()[0].CAT_FIELD5;
HttpContext.Current.Session["Cat_history"] = cats.ToList()[0].CAT_HISTORY;
HttpContext.Current.Session["Cat_id"] = cats.ToList()[0].CAT_ID;
HttpContext.Current.Session["Cat_image1"] = cats.ToList()[0].CAT_IMAGE1;
HttpContext.Current.Session["Cat_image2"] = cats.ToList()[0].CAT_IMAGE2;
HttpContext.Current.Session["Cat_language"] = cats.ToList()[0].CAT_LANGUAGE;
HttpContext.Current.Session["Cat_name"] = cats.ToList()[0].CAT_NAME;
HttpContext.Current.Session["Cat_order"] = cats.ToList()[0].CAT_ORDER;
HttpContext.Current.Session["Cat_pageitem"] = cats.ToList()[0].CAT_PAGEITEM;
HttpContext.Current.Session["Cat_parent_id"] = cats.ToList()[0].CAT_PARENT_ID;
HttpContext.Current.Session["Cat_parent_path"] = cats.ToList()[0].CAT_PARENT_PATH;
HttpContext.Current.Session["Cat_period"] = cats.ToList()[0].CAT_PERIOD;
HttpContext.Current.Session["Cat_period_order"] = cats.ToList()[0].CAT_PERIOD_ORDER;
HttpContext.Current.Session["Cat_position"] = cats.ToList()[0].CAT_POSITION;
HttpContext.Current.Session["Cat_rank"] = cats.ToList()[0].CAT_RANK;
HttpContext.Current.Session["Cat_rowitem"] = cats.ToList()[0].CAT_ROWITEM;
HttpContext.Current.Session["Cat_seo_desc"] = cats.ToList()[0].CAT_SEO_DESC;
HttpContext.Current.Session["Cat_seo_keyword"] = cats.ToList()[0].CAT_SEO_KEYWORD;
HttpContext.Current.Session["Cat_seo_title"] = cats.ToList()[0].CAT_SEO_TITLE;
HttpContext.Current.Session["Cat_seo_url"] = cats.ToList()[0].CAT_SEO_URL;
HttpContext.Current.Session["Cat_showfooter"] = cats.ToList()[0].CAT_SHOWFOOTER;
HttpContext.Current.Session["Cat_showitem"] = cats.ToList()[0].CAT_SHOWITEM;
HttpContext.Current.Session["Cat_status"] = cats.ToList()[0].CAT_STATUS;
HttpContext.Current.Session["Cat_target"] = cats.ToList()[0].CAT_TARGET;
HttpContext.Current.Session["Cat_type"] = cats.ToList()[0].CAT_TYPE;
HttpContext.Current.Session["Cat_url"] = cats.ToList()[0].CAT_URL;
#endregion
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
public List <ESHOP_CATEGORy> Load_sitemap()
{
try
{
var _Cats = db.GetTable <ESHOP_CATEGORy>().Where(c => c.CAT_STATUS > 0).OrderBy(c => c.CAT_NAME).OrderByDescending(c => c.CAT_ORDER);
return(_Cats.ToList());
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return(null);
}
}
//getSession
public int getID(string _sNews_seo_url)
{
int _newsID = 0;
var checkidcat = db.GetTable <ESHOP_NEWS_CAT>().Where(a => a.ESHOP_CATEGORy.CAT_SEO_URL == _sNews_seo_url).ToList();
if (checkidcat.Count > 0)
{
_newsID = Utils.CIntDef(checkidcat[0].NEWS_ID);
}
else
{
var getid = db.ESHOP_NEWs.Where(n => n.NEWS_SEO_URL == _sNews_seo_url).ToList();
_newsID = getid.Count > 0 ? Utils.CIntDef(getid[0].NEWS_ID) : 0;
}
return(_newsID);
}
public void Load_All_Cuss(string email)
{
try
{
var _cus = db.GetTable <ESHOP_CUSTOMER>().Where(a => a.CUSTOMER_EMAIL == email);
if (_cus.ToList().Count > 0)
{
HttpContext.Current.Session["USER_NAME"] = _cus.ToList()[0].CUSTOMER_FULLNAME;
HttpContext.Current.Session["USER_ID"] = _cus.ToList()[0].CUSTOMER_ID;
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
public string getHmtlSeo(int id)
{
string pathFile;
string strHTMLContent;
string _result = string.Empty;
if (id > 0)
{
var newsInfo = db.GetTable <ESHOP_CATEGORy>().Where(n => n.CAT_ID == id);
if (newsInfo.ToList().Count > 0)
{
pathFile = HttpContext.Current.Server.MapPath(PathFiles.GetPathCategory(id) + "/" + newsInfo.ToList()[0].CAT_FIELD5);
if ((File.Exists(pathFile)))
{
StreamReader objNewsReader;
objNewsReader = new StreamReader(pathFile);
strHTMLContent = objNewsReader.ReadToEnd();
objNewsReader.Close();
_result = strHTMLContent;
}
}
}
return(_result);
}
public bool Add_To_Cart(int News_id, object Guid)
{
var _news = from a in db.ESHOP_NEWs
where a.NEWS_ID == News_id
select a;
decimal _dPrice = 0;
if (_news.ToList().Count > 0)
{
if (Utils.CDecDef(_news.ToList()[0].NEWS_PRICE1) == 0)
{
_dPrice = 0;
}
else
{
//if (Utils.CDecDef(_news.ToList()[0].NEWS_PRICE2) != 0)
//{
// _dPrice = Utils.CDecDef(_news.ToList()[0].NEWS_PRICE2);
//}
//else
//{
_dPrice = Utils.CDecDef(_news.ToList()[0].NEWS_PRICE1);
//}
}
}
int _cus_id = 0;
//string _sCode = News_id + "_" + clsFormat.ClearUnicode(Color) + "_" + Size;
if (_dPrice != 0)
{
if (Check_Exist_Item(News_id, (Guid)Guid))
{
//Nếu đã có sản phẩm trong giỏ hàng thì thêm 1
//ESHOP_BASKET _bas = db.ESHOP_BASKETs.Single(a => a.NEWS_ID == News_id);
var _vBasket = db.GetTable <ESHOP_BASKET>().Where(a => a.NEWS_ID == News_id);
if (_vBasket.ToList().Count > 0)
{
_vBasket.Single().BASKET_QUANTITY += 1;
db.SubmitChanges();
}
}
else
{
//Nếu chưa có sản phẩm trong giỏ hàng thì thêm sản phẩm mới vào đó
ESHOP_BASKET _basket = new ESHOP_BASKET();
_basket.BASKET_PRICE = _dPrice;
_basket.CUSTOMER_OID = (Guid)Guid;
_basket.BASKET_PUBLISHDATE = DateTime.Now;
_basket.BASKET_QUANTITY = 1;
_basket.CUSTOMER_ID = _cus_id;
_basket.NEWS_ID = News_id;
db.ESHOP_BASKETs.InsertOnSubmit(_basket);
db.SubmitChanges();
}
return(true);
}
return(false);
}
//Showfile html
public string Showfilehtm(string _sCat_Seo_Url, string _sNews_seo_url, string htmExt)
{
try
{
string _result = string.Empty;
int _newsID = 0;
if (!string.IsNullOrEmpty(_sCat_Seo_Url))
{
var _vNewsID = db.GetTable <ESHOP_NEWS_CAT>().Where(a => a.ESHOP_CATEGORy.CAT_SEO_URL == _sCat_Seo_Url);
_newsID = _vNewsID.ToList().Count > 0 ? Utils.CIntDef(_vNewsID.ToList()[0].NEWS_ID) : 0;
}
else
{
var getid = db.ESHOP_NEWs.Where(n => n.NEWS_SEO_URL == _sNews_seo_url).ToList();
_newsID = getid.Count > 0 ? Utils.CIntDef(getid[0].NEWS_ID) : 0;
}
string pathFile;
string strHTMLContent;
if (_newsID > 0)
{
var newsInfo = db.GetTable <ESHOP_NEW>().Where(n => n.NEWS_ID == _newsID);
if (newsInfo.ToList().Count > 0)
{
pathFile = HttpContext.Current.Server.MapPath("/htm/" + _newsID.ToString() + htmExt);
if ((File.Exists(pathFile)))
{
StreamReader objNewsReader;
objNewsReader = new StreamReader(pathFile);
strHTMLContent = objNewsReader.ReadToEnd();
objNewsReader.Close();
_result = strHTMLContent;
}
}
}
return(_result);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return("");
}
}
public void Load_All_Cuss(string email)
{
try
{
var _cus = db.GetTable <ESHOP_CUSTOMER>().Where(a => a.CUSTOMER_EMAIL == email);
if (_cus.ToList().Count > 0)
{
HttpContext.Current.Session["User_Name"] = _cus.ToList()[0].CUSTOMER_FULLNAME;
HttpContext.Current.Session["User_ID"] = _cus.ToList()[0].CUSTOMER_ID;
HttpContext.Current.Session["User_Phone"] = _cus.ToList()[0].CUSTOMER_PHONE1;
HttpContext.Current.Session["User_Email"] = _cus.ToList()[0].CUSTOMER_EMAIL;
HttpContext.Current.Session["User_Type"] = _cus.ToList()[0].CUSTOMER_TYPE;
HttpContext.Current.Session["User_Code"] = _cus.ToList()[0].CUSTOMER_CODEID;
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
public string Load_video(int period)
{
string _sResult = "";
var _vGetVideo = db.GetTable <ESHOP_NEW>().Where(n => n.NEWS_PERIOD == period).Select(n => new { n.NEWS_VIDEO_URL, n.NEWS_ID }).Take(1).OrderByDescending(a => a.NEWS_ID);
if (_vGetVideo.ToList().Count > 0)
{
_sResult += "<iframe style='display: block; margin-left: auto; margin-right: auto; width:100%;height:220px' allowfullscreen='true'";
_sResult += " src='http://www.youtube.com/embed/" + Get_Embed(_vGetVideo.ToList()[0].NEWS_VIDEO_URL) + "?rel=0' frameborder='0' height='260px' width='100%'></iframe>";
}
return(_sResult);
}
// Show html
public string Show_File_HTML(int _newsID, int type)
{
try
{
string pathFile;
string strHTMLContent;
string _result = string.Empty;
if (_newsID > 0)
{
var newsInfo = db.GetTable <ESHOP_NEW>().Where(n => n.NEWS_ID == _newsID);
if (newsInfo.ToList().Count > 0)
{
if (type == 1)
{
pathFile = HttpContext.Current.Server.MapPath(PathFiles.GetPathNews(_newsID) + "/" + newsInfo.ToList()[0].NEWS_FILEHTML);
}
else if (type == 2)
{
pathFile = HttpContext.Current.Server.MapPath(PathFiles.GetPathNews(_newsID) + "/" + newsInfo.ToList()[0].NEWS_FIELD1);
}
else
{
pathFile = HttpContext.Current.Server.MapPath(PathFiles.GetPathNews(_newsID) + "/" + newsInfo.ToList()[0].NEWS_FIELD5);
}
if ((File.Exists(pathFile)))
{
StreamReader objNewsReader;
objNewsReader = new StreamReader(pathFile);
strHTMLContent = objNewsReader.ReadToEnd();
objNewsReader.Close();
_result = strHTMLContent;
}
}
}
return(_result);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return("");
}
}
public string Showfilehtml_index(int period, int lang)
{
try
{
int _newsID = 0;
string _result = string.Empty;
//var getnewsid = db.ESHOP_NEWs.Where(n => n.NEWS_PERIOD == period).Select(n => new { n.NEWS_ID }).Take(1).ToList();
var getnewsid = (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_LANGUAGE == lang
select b).Select(b => new { b.NEWS_ID }).Take(1).ToList();
if (getnewsid.Count > 0)
{
_newsID = getnewsid[0].NEWS_ID;
}
string pathFile;
string strHTMLContent;
if (_newsID > 0)
{
var newsInfo = db.GetTable <ESHOP_NEW>().Where(n => n.NEWS_ID == _newsID);
if (newsInfo.ToList().Count > 0)
{
pathFile = HttpContext.Current.Server.MapPath(PathFiles.GetPathNews(_newsID) + "/" + newsInfo.ToList()[0].NEWS_FILEHTML);
if ((File.Exists(pathFile)))
{
StreamReader objNewsReader;
objNewsReader = new StreamReader(pathFile);
strHTMLContent = objNewsReader.ReadToEnd();
objNewsReader.Close();
_result = strHTMLContent;
}
}
}
return(_result);
}
catch (Exception)
{
throw;
}
}
public bool CheckExitsEmail(string mail)
{
try
{
var _user = db.GetTable <ESHOP_CUSTOMER>().Where(u => u.CUSTOMER_UN_EMAIL == mail.Trim());
if (_user.ToList().Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return(true);
}
}
public int DoiPass(string user_id, string passnew, string salt)
{
try
{
var _vUser = db.GetTable <ESHOP_CUSTOMER>().Where(a => a.CUSTOMER_ID.ToString() == user_id);
_vUser.Single().CUSTOMER_PW = passnew;
_vUser.Single().CUSTOMER_FIELD5 = salt;
db.SubmitChanges();
return(1);
}
catch
{
return(-1);
}
}
//Active menu
#region Active menu
public string Get_Cat_Seo_Url(string _seoUrl)
{
var rausach = from p in db.ESHOP_CATEGORies
where p.CAT_SEO_URL == _seoUrl && p.CAT_STATUS == 1
select p;
int _catID = -1;
if (rausach.ToList().Count > 0)
{
string cat_parent_path = rausach.ToList()[0].CAT_PARENT_PATH;
string[] str = cat_parent_path.Split(',');
if (str.Count() > 1)
{
_catID = Utils.CIntDef(str[1]);
}
else
{
_catID = Utils.CIntDef(rausach.ToList()[0].CAT_ID);
}
}
else
{
var rausach1 = (from nc in db.ESHOP_NEWS_CATs
join c in db.ESHOP_CATEGORies on nc.CAT_ID equals c.CAT_ID
join n in db.ESHOP_NEWs on nc.NEWS_ID equals n.NEWS_ID
where n.NEWS_SEO_URL == _seoUrl && c.CAT_STATUS == 1
orderby c.CAT_RANK descending
select new
{
c.CAT_PARENT_PATH,
c.CAT_NAME,
c.CAT_DESC,
c.CAT_ID
}).Take(1);
if (rausach1.ToList().Count > 0)
{
string cat_parent_path_Max = rausach1.ToList()[0].CAT_PARENT_PATH;
string[] str = cat_parent_path_Max.Split(',');
if (str.Count() > 1)
{
_catID = Utils.CIntDef(str[1]);
}
else
{
_catID = Utils.CIntDef(rausach1.ToList()[0].CAT_ID);
}
}
}
var _cat_Seo_Url = db.GetTable <ESHOP_CATEGORy>().Where(a => a.CAT_ID == _catID && a.CAT_STATUS == 1);
if (_cat_Seo_Url.ToList().Count > 0)
{
string _catSeoUrl = _cat_Seo_Url.ToList()[0].CAT_SEO_URL;
return(_catSeoUrl);
}
else
{
return(null);
}
}
public List <ESHOP_CUSTOMER> Loaduserinfo(int userid)
{
var _vUser = db.GetTable <ESHOP_CUSTOMER>().Where(a => a.CUSTOMER_ID == userid).ToList();
return(_vUser);
}
