// GET: ChildView
// [OutputCache(Duration = ClassExten.timeCacheChild, VaryByParam = "lang")]
public ActionResult ChildHeader(string path)
{
int countSp = 0;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet != null)
{
countSp = cartGet.CartItems.Count;
}
ViewBag.countSp = countSp;
bool isHome = false;
if (path.Equals("") || path.Equals("/"))
{
}
isHome = true;
var qcTop = db.Advs.FirstOrDefault(u => u.advActive == true && u.advType == 1);
ViewBag.qcTop = qcTop;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
ViewBag.conf = conf;
ViewBag.isHome = isHome;
return(PartialView());
}
public ActionResult Detail(string id)
{
List <News> newOther = new List <News>();
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
ViewBag.conf = conf;
var newData = db.News.FirstOrDefault(u => u.new_key.Equals(id) && u.newLang.Equals(lang));
if (newData != null)
{
ViewBag.cateP = db.Categorys.FirstOrDefault(u => u.id.Equals(newData.groupId));
#region [load seo]
ViewBag.title = newData.titleSeo;
ViewBag.description = newData.desSeo;
ViewBag.keywords = newData.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + newData.newImage;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
ViewBag.newData = newData;
#region [lay cac bai lien quan]
newOther = db.News.Where(u => u.status == Constants.Active && u.groupId.Equals(newData.groupId) && !u.id.Equals(newData.id)).OrderByDescending(u => u.createDate).Take(conf.viewNewPageDetail.Value).ToList();
#endregion
}
return(View(newOther));
}
public ActionResult Partner()
{
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
ViewBag.conf = conf;
#region [load seo]
ViewBag.title = conf.titleSeo;
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
var all = (from a in db.Partners.AsNoTracking()
where a.lang.Equals(lang)
orderby a.numberOder
select a).ToList();
return(View(all));
}
public ActionResult SiteContent(string id)
{
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
var menu = db.Menus.FirstOrDefault(u => u.link.Equals("/sites/" + id) && u.active == true && u.mtype == 2 && u.mLang.Equals(lang));
if (menu != null)
{
#region [load seo]
ViewBag.title = menu.titleSeo;
ViewBag.description = menu.desSeo;
ViewBag.keywords = menu.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
#region [lay cac bai lien quan]
ViewBag.menu = menu;
#endregion
}
return(View());
}
public ActionResult Index()
{
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
ViewBag.conf = conf;
#region [load seo]
ViewBag.title = ClassExten.GetLangKey("key_giohang");
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
return(View());
}
else
{
shoppCart = cartGet;
return(View(shoppCart));
}
}
public ActionResult UpdatePass(LoginModel model)
{
var user = ClassExten.GetCokies();
if (user == null)
{
return(Json(new { ok = 2, mess = "Phiên đăng nhập hết hạn, vui lòng đăng nhập lại để sử dụng tính năng" }, JsonRequestBehavior.AllowGet));
}
var data = db.Admins.First(u => u.email.Equals(user.Email));
var passOld = StringClass.Encrypt(model.Password);
passOld = StringClass.Encrypt(passOld);
if (!data.pass.Equals(passOld))
{
return(Json(new { ok = 0, mess = "Mật khẩu cũ không đúng" }, JsonRequestBehavior.AllowGet));
}
try
{
var passNew = StringClass.Encrypt(model.PasswordNew);
passNew = StringClass.Encrypt(passNew);
data.pass = passNew;
db.SaveChanges();
return(Json(new { ok = 1, mess = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { ok = 0, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Tags(string id)
{
#region [con fig]
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
ViewBag.conf = conf;
#endregion
var tag = db.Tagproes.FirstOrDefault(u => u.tagKey.Equals(id));
if (tag != null)
{
var all = (from a in db.Products.AsNoTracking()
where a.active == true
join b in db.ProTags.AsNoTracking() on a.id equals b.proId
where b.tagId.Equals(tag.tagId)
orderby a.proOrder
select a).AsQueryable();
ViewBag.cateName = "Tags: " + tag.tagName;
#region [load seo]
ViewBag.title = conf.titleSeo;
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
string page = "1"; //so phan trang hien tai
var pagesize = 6; //so ban ghi tren 1 trang
var numOfNews = 0; //tong so ban ghi co duoc truoc khi phan trang
int curpage = 0; // trang hien tai dung cho phan trang
if (Request["page"] != null)
{
page = Request["page"];
curpage = Convert.ToInt32(page) - 1;
}
pagesize = conf.viewProPageList.Value;
numOfNews = all.Select(u => u.id).Count();
var data = all.Skip(curpage * pagesize).Take(pagesize).ToList();
var url = Request.Path;
if (numOfNews > pagesize)
{
ViewBag.pages = NTSPRODUCT.Models.Phantrang.PhanTrangSite(pagesize, curpage, numOfNews, url);
}
return(View(data));
}
else
{
ViewBag.cateName = "Tags";
return(View());
}
}
public ActionResult Addcart(string id)
{
string prokey = id;
int soluong = 1;
if (Request["number"] != null)
{
soluong = int.Parse(Request["number"].ToString());
}
var obj = db.Products.First(u => u.id.Equals(id));
int flag = -1;
int gia = obj.proPrice_sale.Value;
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
shoppCart = new ShoppingCartViewModel();
ClassExten.CreateCookiesCart(string.Empty);
}
else
{
shoppCart = cartGet;
}
if (GetCartItem(shoppCart, obj.id) == flag)
{
var cartItem = new Cart
{
productId = obj.id,
productName = obj.pro_name,
productImg = obj.proAvata,
price = gia,
count = soluong,
total = soluong * gia,
key = obj.pro_key
};
shoppCart.CartItems.Add(cartItem);
}
else
{
flag = GetCartItem(shoppCart, obj.id);
shoppCart.CartItems[flag].count += soluong;
shoppCart.CartItems[flag].total = shoppCart.CartItems[flag].price * shoppCart.CartItems[flag].count;
}
for (int k = 0; k < shoppCart.CartItems.Count; k++)
{
cartTotal += shoppCart.CartItems[k].total;
}
shoppCart.CartTotal = cartTotal;
ClassExten.UpdateCookiesCart(JsonConvert.SerializeObject(shoppCart));
return(Redirect("/Gio-hang"));
}
public ActionResult Search(string id)
{
id = id.ToLower();
ViewBag.id = id;
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
string page = "1"; //so phan trang hien tai
var pagesize = 6; //so ban ghi tren 1 trang
var numOfNews = 0; //tong so ban ghi co duoc truoc khi phan trang
int curpage = 0; // trang hien tai dung cho phan trang
if (Request["page"] != null)
{
page = Request["page"];
curpage = Convert.ToInt32(page) - 1;
}
pagesize = conf.viewNewPageList.Value;
var all = (from a in db.News.AsNoTracking()
where a.newLang.Equals(lang) &&
a.status == Constants.Active &&
a.title.ToLower().Contains(id)
orderby a.createDate descending
select a).AsQueryable();
List <string> cateid = new List <string>();
ViewBag.key_tintuc = ClassExten.GetLangKey("key_timkiem") + ": " + id;
#region [load seo]
ViewBag.title = conf.titleSeo;
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
numOfNews = all.Select(u => u.id).Count();
var data = all.Skip(curpage * pagesize).Take(pagesize).ToList();
var url = Request.Path;
if (numOfNews > pagesize)
{
ViewBag.pages = NTSPRODUCT.Models.Phantrang.PhanTrangSite(pagesize, curpage, numOfNews, url);
}
return(View(data));
}
public ActionResult GetList()
{
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
return(PartialView());
}
else
{
shoppCart = cartGet;
return(PartialView(shoppCart));
}
}
private ShoppingCartViewModel AddCartPro(string id, int soluong)
{
var obj = db.Products.First(u => u.id.Equals(id));
int flag = -1;
int gia = obj.proPrice_sale.Value;
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
shoppCart = new ShoppingCartViewModel();
ClassExten.CreateCookiesCart(string.Empty);
}
else
{
shoppCart = cartGet;
}
if (GetCartItem(shoppCart, obj.id) == flag)
{
var cartItem = new Cart
{
productId = obj.id,
productName = obj.pro_name,
productImg = obj.proAvata,
price = gia,
count = soluong,
total = soluong * gia,
key = obj.pro_key
};
shoppCart.CartItems.Add(cartItem);
}
else
{
flag = GetCartItem(shoppCart, obj.id);
shoppCart.CartItems[flag].count += soluong;
shoppCart.CartItems[flag].total = shoppCart.CartItems[flag].price * shoppCart.CartItems[flag].count;
}
for (int k = 0; k < shoppCart.CartItems.Count; k++)
{
cartTotal += shoppCart.CartItems[k].total;
}
shoppCart.CartTotal = cartTotal;
ClassExten.UpdateCookiesCart(JsonConvert.SerializeObject(shoppCart));
return(shoppCart);
}
public ActionResult RemoveFromCart(string id)
{
try
{
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
shoppCart = new ShoppingCartViewModel();
ClassExten.CreateCookiesCart(string.Empty);
}
else
{
shoppCart = cartGet;
}
for (int i = 0; i < shoppCart.CartItems.Count; i++)
{
if (shoppCart.CartItems[i].productId == id)
{
shoppCart.CartItems.RemoveAt(i);
break;
}
}
if (shoppCart.CartItems.Count > 0)
{
for (int j = 0; j < shoppCart.CartItems.Count; j++)
{
cartTotal += shoppCart.CartItems[j].total;
}
shoppCart.CartTotal = cartTotal;
}
else
{
shoppCart.CartTotal = 0;
}
ClassExten.UpdateCookiesCart(JsonConvert.SerializeObject(shoppCart));
return(Json(new { ok = true, mess = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { ok = false, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(Oder model)
{
try
{
var loginInfo = ClassExten.GetCokies();
var data = db.Oders.First(u => u.id.Equals(model.id));
data.status = model.status;
data.noteSiteAdmin = model.noteSiteAdmin;
data.updateBy = loginInfo.Id;
data.updateDate = DateTime.Now;
db.SaveChanges();
return(Json(new { ok = true, mess = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { ok = false, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index()
{
#region [check admin]
var userInfo = ClassExten.GetCokies();
if (userInfo != null)
{
if (userInfo.subAdmin == false)
{
return(Redirect("/Admins/Login"));
}
}
else
{
return(Redirect("/Admins/Login"));
}
#endregion
return(View());
}
public ActionResult UpdateCartCountItem(string id, int cartCount)
{
try
{
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
shoppCart = new ShoppingCartViewModel();
ClassExten.CreateCookiesCart(string.Empty);
}
else
{
shoppCart = cartGet;
}
for (int i = 0; i < shoppCart.CartItems.Count; i++)
{
if (shoppCart.CartItems[i].productId == id)
{
if (cartCount == 0 || cartCount < 0)
{
cartCount = 1;
}
shoppCart.CartItems[i].count = cartCount;
shoppCart.CartItems[i].total = Convert.ToInt32(shoppCart.CartItems[i].price) * cartCount;
break;
}
}
for (int j = 0; j < shoppCart.CartItems.Count; j++)
{
cartTotal += shoppCart.CartItems[j].total;
}
shoppCart.CartTotal = cartTotal;
var number = shoppCart.CartItems.Sum(u => u.count);
ClassExten.UpdateCookiesCart(JsonConvert.SerializeObject(shoppCart));
return(Json(new { ok = true, mess = "", countcart = number }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { ok = false, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult xacNhanDonHang(Oder model)
{
try
{
string lang = ClassExten.GetLangSite();
var loginInfo = ClassExten.GetCokies();
var data = db.Oders.First(u => u.id.Equals(model.id));
data.status = ClassExten.Bill_Status.DaMuaHang;
data.updateDate = DateTime.Now;
data.updateBy = loginInfo.Id;
db.SaveChanges();
return(Json(new { ok = true, mess = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { ok = false, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
// GET: HomeSite
public ActionResult Index()
{
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
#region [load seo]
ViewBag.title = conf.titleSeo;
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
#endregion
return(View());
}
public bool CheckVersionLogin(string id)
{
var loginProfile = ClassExten.GetCokies();
var identity = (ClaimsIdentity)HttpContext.Current.User.Identity;
if (identity != null)
{
var claimVersion = identity.Claims.Where(t => t.Type.Contains("version")).FirstOrDefault();
if (claimVersion != null)
{
var version = claimVersion.Value;
if (loginProfile != null && !string.IsNullOrEmpty(loginProfile.SecurityKey) && id.Equals(loginProfile.Email))
{
if (loginProfile.SecurityKey.Equals(version))
{
return(true);
}
}
}
}
return(false);
}
public ActionResult Fogot(FormCollection fr)
{
try
{
var Email = fr["Username"];
var phone = fr["phone"];
var userInfo = db.Admins.FirstOrDefault(u => u.email.ToLower().Equals(Email.ToLower()) && u.phone.Equals(phone));
if (userInfo != null)
{
var securityKey = Guid.NewGuid().ToString();
userInfo.keyFogot = securityKey;
userInfo.dateStart = DateTime.Now;
userInfo.dateEnd = userInfo.dateStart.Value.AddHours(2);
db.SaveChanges();
ViewBag.erro = "Gửi yêu cầu thành công bạn vui lòng check mail để lấy mật khẩu(yêu cầu sẽ hết hạn trong 2h)";
var conf = db.Configs.FirstOrDefault(u => u.conLang.Equals(lang));
string title = "Yêu cầu lấy mật khẩu quản trị hệ thống website " + Request.Url.Host;
string note = "<p>Yêu cầu lấy mật khẩu quản trị hệ thống website " + Request.Url.Host + " sẽ hết hạn trong 2h kể từ khi gửi yêu cầu</p>";
note += "<p>Bạn vui lòng click vào <a href='http://" + Request.Url.Host + "/Admins/FogotChange/" + securityKey + "'> đây </a> để cập nhật mật khẩu mới </p>";
var rs = ClassExten.SendMail(userInfo.email, conf.email_Send, conf.emailPass, conf.mail_Port.Value, title, note);
if (rs == false)
{
ViewBag.erro = "Hệ thống gửi mail lỗi vui lòng thử lại sau";
}
return(View());
}
else
{
ViewBag.erro = "Tài khoản và số điện thoại không hợp lệ";
return(View());
}
}
catch (Exception ex)
{
ViewBag.erro = "Xảy ra lỗi vui lòng thử lại";
return(View());
}
}
public ActionResult Detail(string id)
{
List <Product> proOther = new List <Product>();
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
ViewBag.conf = conf;
int numberPro = 6;
if (conf.viewProPageDetail != null)
{
numberPro = conf.viewProPageDetail.Value;
}
var proData = db.Products.FirstOrDefault(u => u.pro_key.Equals(id) && u.pLang.Equals(lang));
if (proData != null)
{
var cateP = db.Categorys.FirstOrDefault(u => u.id.Equals(proData.groupId));
#region [load seo]
ViewBag.title = proData.titleSeo;
ViewBag.description = proData.desSeo;
ViewBag.keywords = proData.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + proData.proAvata;
#endregion
ViewBag.pro = proData;
ViewBag.cateP = cateP;
#region [lay cac bai lien quan]
proOther = db.Products.Where(u => u.active == true && u.groupId.Equals(proData.groupId) && !u.id.Equals(proData.id)).OrderBy(u => u.proOrder).Take(numberPro).ToList();
#endregion
//db.SaveChanges();
}
return(View(proOther));
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool check = false;
var loginProfile = ClassExten.GetCokies();
if (loginProfile != null)
{
if (!string.IsNullOrEmpty(loginProfile.SecurityKey))
{
check = true;
}
}
if (httpContext.User.Identity.IsAuthenticated)
{
var id = httpContext.User.Identity.Name;
check = CheckVersionLogin(id);
}
if (check == false)
{
httpContext.Response.Redirect("~/Admins/Login", true);
}
return(check);
}
public ActionResult GetList()
{
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
ViewBag.conf = conf;
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
return(PartialView());
}
else
{
shoppCart = cartGet;
return(PartialView(shoppCart));
}
}
public ActionResult Detail(string id)
{
List <Product> proOther = new List <Product>();
// Category catePro;
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
ViewBag.conf = conf;
int numberPro = 6;
if (conf.viewProPageDetail != null)
{
numberPro = conf.viewProPageDetail.Value;
}
var proData = db.Products.FirstOrDefault(u => u.pro_key.Equals(id));
if (proData != null)
{
var protag = (from a in db.ProTags.AsNoTracking()
join b in db.Tagproes.AsNoTracking() on a.tagId equals b.tagId
where a.proId.Equals(proData.id)
select b).OrderBy(u => u.tagOrder).ToList();
var cateP = db.Categorys.FirstOrDefault(u => u.id.Equals(proData.cateId));
var catePSub = db.Categorys.FirstOrDefault(u => u.id.Equals(cateP.catepar_id));
// var SayWe = db.SayWes.Where(u => u.active == true).OrderBy(u => u.numberOder).Take(4).ToList();
var advs = db.Advs.FirstOrDefault(u => u.advActive == true && u.advType == 3); //quảng cáo chi tiết sp
var newsPro = db.News.Where(u => u.status == Constants.Active && u.newNew == true).OrderBy(u => u.newOrder).Take(4).ToList(); //tin mới
var newsHot = db.News.Where(u => u.status == Constants.Active && u.newHot == true).OrderBy(u => u.newOrder).Take(4).ToList(); //tin hot home
#region [load seo]
ViewBag.title = proData.titleSeo;
ViewBag.description = proData.desSeo;
ViewBag.keywords = proData.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + proData.proAvata;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
/// ViewBag.SayWe = SayWe;
ViewBag.advs = advs;
ViewBag.newsPro = newsPro;
ViewBag.newsHot = newsHot;
ViewBag.pro = proData;
ViewBag.cateP = cateP;
ViewBag.catePSub = catePSub;
ViewBag.protag = protag;
#region [lay cac bai lien quan]
proOther = db.Products.Where(u => u.active == true && u.cateId.Equals(proData.cateId) && !u.id.Equals(proData.id)).OrderBy(u => u.proOrder).Take(numberPro).ToList();
#endregion
}
return(View(proOther));
}
public ActionResult GetListOrder(SearchModel model)
{
var all = (from a in db.Oders.AsNoTracking()
join b in db.Customers.AsNoTracking() on a.cusId equals b.id
join c in db.Admins.AsNoTracking() on a.updateBy equals c.id into ac
from ac1 in ac.DefaultIfEmpty()
select new OderExten()
{
id = a.id,
cusId = a.cusId,
status = a.status,
createDate = a.createDate,
updateDate = a.updateDate,
priceShip = a.priceShip,
noteSite = a.noteSite,
noteSiteAdmin = a.noteSiteAdmin,
fullName = b.fullName,
phone = b.phone,
email = b.email,
addresss = b.addresss,
total = a.total,
EmpName = ac1 != null ? ac1.fullName : string.Empty
}
).AsQueryable();
if (!string.IsNullOrEmpty(model.AdminName))
{
all = all.Where(u => u.EmpName.ToLower().Contains(model.AdminName.ToLower()));
}
if (!string.IsNullOrEmpty(model.Name))
{
all = all.Where(u => u.fullName.ToLower().Contains(model.Name.ToLower()));
}
if (!string.IsNullOrEmpty(model.Email))
{
all = all.Where(u => u.email.ToLower().Contains(model.Email.ToLower()));
}
if (!string.IsNullOrEmpty(model.Phone))
{
all = all.Where(u => u.phone.ToLower().Contains(model.Phone.ToLower()));
}
if (!string.IsNullOrEmpty(model.Status))
{
int stt = int.Parse(model.Status);
all = all.Where(u => u.status == stt);
}
if (!string.IsNullOrEmpty(model.DateFrom))
{
DateTime dFrom = ClassExten.ConvertDateFromStr(model.DateFrom);
all = all.Where(u => u.createDate >= dFrom);
}
if (!string.IsNullOrEmpty(model.DateTo))
{
DateTime dTo = ClassExten.ConvertDateTo(model.DateTo);
all = all.Where(u => u.createDate <= dTo);
}
all = all.OrderByDescending(u => u.createDate);
var numOfOrders = all.Select(u => u.id).Count();
var currPage = model.PageNumber - 1;
var data = all.Skip((model.PageNumber - 1) * model.PageSize).Take(model.PageSize).ToList();
ViewBag.Index = (currPage * model.PageSize);
ViewBag.TotalItem = numOfOrders;
ViewBag.PageSize = model.PageSize;
if (numOfOrders > model.PageSize)
{
ViewBag.pages = NTSPRODUCT.Models.Phantrang.PhanTrang(model.PageSize, currPage, numOfOrders, "");
}
return(PartialView(data));
}
// GET: NewSite
public ActionResult Index(string id)
{
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault(u => u.conLang.Equals(lang));
ViewBag.conf = conf;
string page = "1"; //so phan trang hien tai
var pagesize = 6; //so ban ghi tren 1 trang
var numOfNews = 0; //tong so ban ghi co duoc truoc khi phan trang
int curpage = 0; // trang hien tai dung cho phan trang
if (Request["page"] != null)
{
page = Request["page"];
curpage = Convert.ToInt32(page) - 1;
}
pagesize = conf.viewNewPageList.Value;
var all = (from a in db.News.AsNoTracking()
where a.newLang.Equals(lang) &&
a.status == Constants.Active
orderby a.newOrder
select a).AsQueryable();
List <string> cateid = new List <string>();
if (!string.IsNullOrEmpty(id))
{
var cateP = db.Categorys.FirstOrDefault(u => u.cateLang.Equals(lang) && u.cateType == ClassExten.typeNew && u.cateKey.Equals(id));
if (cateP != null)
{
ViewBag.cateP = cateP;
#region [load seo]
ViewBag.title = cateP.titleSeo;
ViewBag.description = cateP.desSeo;
ViewBag.keywords = cateP.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + cateP.cateImage;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
if (cateP.cate_cap != 3)
{
cateid = GetListId(cateP.id, cateP.cate_cap.Value);
}
else
{
cateid.Add(cateP.id);
}
}
all = all.Where(u => cateid.Contains(u.groupId));
}
else
{
ViewBag.key_tintuc = ClassExten.GetLangKey("news");
#region [load seo]
ViewBag.title = conf.titleSeo;
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
}
numOfNews = all.Select(u => u.id).Count();
var data = all.Skip(curpage * pagesize).Take(pagesize).ToList();
var url = Request.Path;
if (numOfNews > pagesize)
{
ViewBag.pages = NTSPRODUCT.Models.Phantrang.PhanTrangSite(pagesize, curpage, numOfNews, url);
}
return(View(data));
}
private ShoppingCartViewModel CountCart()
{
ShoppingCartViewModel cartGet = ClassExten.GetCokiesCart();
return(cartGet);
}
//dat hang
public ActionResult Dathang(Customer model)
{
ShoppingCartViewModel shoppCart;
var cartGet = ClassExten.GetCokiesCart();
if (cartGet == null)
{
return(Json(new { ok = 2, mess = "Lỗi không tìm thấy giỏ hàng" }, JsonRequestBehavior.AllowGet));
}
else
{
shoppCart = cartGet;
}
model.id = Guid.NewGuid().ToString();
model.active = true;
model.type = 1;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
string host = Request.Url.Host;
Oder or = new Oder();
Oderdt dt;
var content = "<p><b>Danh sách sản phẩm đơn hàng:</b></p>";
string cssth = "style='padding-top:12px;padding-bottom:12px;text-align:left; background-color: #4CAF50;color: white; padding: 8px; '";
string csstd = "style='border: 1px solid #ddd; padding: 8px; '";
var list = shoppCart;
if (list.CartItems.Count > 0)
{
try
{
content += "<table style='border-collapse: collapse; width: 100%'>";
content += "<tr>";
content += "<th " + cssth + ">Sản phẩm</th>";
content += "<th " + cssth + ">Số lượng</th>";
content += "<th " + cssth + ">Giá</th>";
content += "<th " + cssth + ">Tổng tiền</th>";
content += "</tr>";
string email = model.email;
var cus = db.Customers.FirstOrDefault(u => u.email == email);
or.createDate = DateTime.Now;
or.id = Guid.NewGuid().ToString();
or.total = list.CartTotal + conf.priceShip;
// or.noteSite = model.noteSite;
or.noteSite = string.Empty;
or.status = ClassExten.Bill_Status.MoiTao;
or.priceShip = conf.priceShip;
or.createDate = DateTime.Now;
if (cus != null)
{
or.cusId = cus.id;
}
else
{
db.Customers.Add(model);
or.cusId = model.id;
}
db.Oders.Add(or);
var hostUrl = Request.Url.Host;
string title = "Thông tin đơn hàng tại " + hostUrl;
string titleAdmin = "Thông tin đơn hàng từ khách: " + model.fullName + " tại " + hostUrl;
for (int i = 0; i < list.CartItems.Count; i++)
{
dt = new Oderdt();
dt.id = Guid.NewGuid().ToString();
dt.oderId = or.id;
dt.proId = list.CartItems[i].productId;
dt.quantity = list.CartItems[i].count;
dt.priceNow = list.CartItems[i].price;
dt.priceCount = list.CartItems[i].price * list.CartItems[i].count;
content += "<tr>";
content += "<td " + csstd + "><a href='http://" + hostUrl + "/chi-tiet/" + list.CartItems[i].key + "' title='" + list.CartItems[i].productName + "'>" + list.CartItems[i].productName + "</a></td>";
content += "<td " + csstd + ">" + list.CartItems[i].count + "</td>";
content += "<td " + csstd + ">" + list.CartItems[i].price.ToString("N0") + "</td>";
content += "<td " + csstd + ">" + dt.priceCount.Value.ToString("N0") + "</td>";
content += "</tr>";
db.Oderdts.Add(dt);
}
db.SaveChanges();
if (Request.Cookies["cartNTS"] != null)
{
var c = new HttpCookie("cartNTS");
c.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(c);
}
content += "</table>";
switch (conf.typeSendMail)
{
case 2:
{
//Chỉ gửi Admin
ClassExten.SendMail(conf.email_Inbox, conf.email_Send, conf.emailPass, conf.mail_Port.Value, titleAdmin, content);
}
break;
case 3:
{
//Chỉ gửi cho khách
ClassExten.SendMail(model.email, conf.email_Send, conf.emailPass, conf.mail_Port.Value, title, content);
}
break;
case 4:
{
//gửi full
ClassExten.SendMail(model.email, conf.email_Send, conf.emailPass, conf.mail_Port.Value, title, content);
ClassExten.SendMail(conf.email_Inbox, conf.email_Send, conf.emailPass, conf.mail_Port.Value, titleAdmin, content);
}
break;
default:
break;
}
return(Json(new { ok = 1, mess = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception c)
{
return(Json(new { ok = 0, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { ok = 2, mess = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ChangeLangSite(string lang)
{
ClassExten.ChangelangSite(lang);
return(Json(JsonRequestBehavior.AllowGet, "ok"));
}
public ActionResult ThuongHieu(string id)
{
ViewBag.key = id;
#region [con fig]
ViewBag.lang = lang;
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
ViewBag.conf = conf;
#endregion
List <string> cateid = new List <string>();
var all = (from a in db.Products.AsNoTracking()
where a.active == true
orderby a.proOrder
select a).AsQueryable();
if (!string.IsNullOrEmpty(id))
{
#region [xu ly lay sp]
var cateP = db.Brands.FirstOrDefault(u => u.bkKey.Equals(id));
if (cateP == null)
{
return(Redirect("/danh-muc"));
}
ViewBag.cateP = cateP;
all = all.Where(u => u.brandId.Equals(cateP.id));
#endregion
#region [load seo]
ViewBag.title = conf.titleSeo;
ViewBag.description = conf.desSeo;
ViewBag.keywords = conf.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + conf.logoTop;
ViewBag.favicon = ClassExten.GetUrlHost() + conf.favicon;
#endregion
}
else
{
return(Redirect("/danh-muc"));
}
string page = "1"; //so phan trang hien tai
var pagesize = 6; //so ban ghi tren 1 trang
var numOfNews = 0; //tong so ban ghi co duoc truoc khi phan trang
int curpage = 0; // trang hien tai dung cho phan trang
if (Request["page"] != null)
{
page = Request["page"];
curpage = Convert.ToInt32(page) - 1;
}
pagesize = conf.viewProPageList.Value;
numOfNews = all.Select(u => u.id).Count();
var data = all.Skip(curpage * pagesize).Take(pagesize).ToList();
var url = Request.Path;
if (numOfNews > pagesize)
{
ViewBag.pages = NTSPRODUCT.Models.Phantrang.PhanTrangSite(pagesize, curpage, numOfNews, url);
}
return(View(data));
}
// GET: ProductSite
//sản phẩm(trai la giai phap, ben phai la san pham)
public ActionResult Index(string id)
{
#region [con fig]
Config conf;
if (ConfigModel.listConfig == null)
{
ConfigModel.listConfig = db.Configs.ToList();
}
conf = ConfigModel.listConfig.FirstOrDefault();
ViewBag.conf = conf;
#endregion
var all = (from a in db.Products.AsNoTracking()
where a.pLang.Equals(lang) &&
a.active == true
orderby a.proOrder
select a).AsQueryable();
#region [xu ly lay sp]
if (!string.IsNullOrEmpty(id))
{
if (ConfigModel.listCate == null)
{
ConfigModel.listCate = db.Categorys.Where(u => u.cateActive == true && u.cateType == ClassExten.typePro).ToList();
}
var cateP = ConfigModel.listCate.FirstOrDefault(u => u.cateKey.Equals(id) && u.cateType == ClassExten.typePro);
ViewBag.cateP = cateP;
List <string> cateId = new List <string>();
#region [load seo]
ViewBag.title = cateP.titleSeo;
ViewBag.description = cateP.desSeo;
ViewBag.keywords = cateP.keySeo;
ViewBag.url = HttpContext.Request.Url.AbsoluteUri;
ViewBag.img = ClassExten.GetUrlHost() + cateP.cateImage;
#endregion
if (cateP != null)
{
cateId.AddRange(GetListId(cateP.id, cateP.cate_cap.Value));
all = all.Where(u => cateId.Contains(u.groupId));
}
}
#endregion
string page = "1"; //so phan trang hien tai
var pagesize = 6; //so ban ghi tren 1 trang
var numOfNews = 0; //tong so ban ghi co duoc truoc khi phan trang
int curpage = 0; // trang hien tai dung cho phan trang
if (Request["page"] != null)
{
page = Request["page"];
curpage = Convert.ToInt32(page) - 1;
}
pagesize = conf.viewProPageList.Value;
numOfNews = all.Select(u => u.id).Count();
var data = all.Skip(curpage * pagesize).Take(pagesize).ToList();
var url = Request.Path;
if (numOfNews > pagesize)
{
ViewBag.pages = NTSPRODUCT.Models.Phantrang.PhanTrangSite(pagesize, curpage, numOfNews, url);
}
return(View(data));
}
