/// <summary> /// Phương thức kiểm tra password /// </summary> /// <param name="userName">userName</param> /// <param name="passWord">password</param> /// <returns> /// True: Nếu thông tin hợp lệ /// False: Nếu thông tin không hợp lệ /// </returns> public bool CheckPassword(string userName, string passWord) { try { var userEntities = new BuyGroup365Entities(); List <GetUserByUserNameAndPassword_Result> user = userEntities.GetUserByUserNameAndPassword(userName, Common.util.Common.GetMd5Sum(passWord)).ToList(); if (user.Any()) { return(true); } else { return(false); } } catch (SqlException ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.SqlExceptionUnhandler, "Sql Exeption"); } catch (Exception ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.Unhandler, "Unhandler Exception"); } }
public List <SearchProductByName_Result> SearchListProductByName(string key) { var ProductEntities = new BuyGroup365Entities(); var listResults = ProductEntities.SearchProductByName(key).ToList(); return(listResults); }
public List <SearchProductByType_Result> GetBySellerByCatalogID(long id, int page = 0, int Page_Size = 3) { string strQuery = BuildQuery(id, page, Page_Size); BuyGroup365Entities entitis = new BuyGroup365Entities(); var result = entitis.Database.SqlQuery <SearchProductByType_Result>(strQuery).ToList(); return(result); }
public List <SearchNewByGroupID_Result> ListByNewsIdNewsGroup(long?newsGroupId, ref int totalRecord, int pageIndex = 1, int pageSize = 2) { var NewEntities = new BuyGroup365Entities(); var listResults = NewEntities.SearchNewByGroupID(newsGroupId, pageIndex, pageSize).ToList(); totalRecord = NewEntities.SearchNewByGroupID(newsGroupId, 1, 10000).Count(); return(listResults); }
public List <SearchProductByName1_Result> SearchProductName(string key) { var ProductEntities = new BuyGroup365Entities(); var listResults = ProductEntities.SearchProductByName1(key).ToList(); //var ProductEntities = new BuyGroup365Entities(); // var listResults = ProductEntities().Where(p => p. == brandId && p.Status == 1).OrderByDescending(p => p.ModifyDate).Take(size).ToList(); ; // var listResults = GetDynamicQuery().Where(x => x.ProductName.Contains(key)).Select(x => new { ProductName = x.ProductName, Price = x.Price, ImgSource = x.ProductImages.Where(z => z.IsAvatar == 1).Select(z => z.ImgSource) }).ToArray(); return(listResults); }
public static void SetListModule(HttpSessionStateBase httpSessionState, long userId, bool isSupperUser) { if (!isSupperUser) { var userEntities = new BuyGroup365Entities(); var listResult = userEntities.GetAllModuleByUserId(userId).ToList(); string listModule = listResult.Aggregate("", (current, re) => current + (re.WebMethod + ";")); listModule += "/User/Info;/User/ChangePassword;/User/UpdateInfo"; SetSessionModule(listModule, httpSessionState); } else { SetSessionModule("IsSupperUser", httpSessionState); } }
public List <Product> GetByKey(string key, int?statusProduct, int?isOfProduct, long?shopid, long?CatalogIDProduct) { var ProductEntities = new BuyGroup365Entities(); List <Product> ListPro = new List <Product>(); IQueryable <Product> listResults = GetDynamicQuery(); if (CatalogIDProduct != -1) { Product pro1 = new Product(); var listcatalog = ProductEntities.CatalogProducts.Where(p => p.CatalogId == CatalogIDProduct).ToList(); foreach (var re in listcatalog) { if (!string.IsNullOrEmpty(key)) { var obj = GetById(re.ProductId); if (obj.ProductName.Contains(key) || obj.Code.Contains(key)) { ListPro.Add(obj); } } else { var obj = GetById(re.ProductId); ListPro.Add(obj); } } } else { if (!string.IsNullOrEmpty(key)) { ListPro = listResults.Where(x => x.ProductName.Contains(key)).ToList(); } else { ListPro = listResults.ToList(); } } return(ListPro); }
public List <SearchProductByType_Result> ListByProductsIdCatalogID(int id) { string urlParam = string.Empty; string k = ""; long ids = 0; if (id == null) { id = 0; } int page = 1; int Page_Size = 30; double?priceForm = 0, priceTo = 0; string order = "new"; string strQuery = BuildQuery(id, ids, priceForm, priceTo, order, page, Page_Size, urlParam, k); BuyGroup365Entities entitis = new BuyGroup365Entities(); var result = entitis.Database.SqlQuery <SearchProductByType_Result>(strQuery).ToList(); return(result); }
public bool CheckExistUserName(string userName) { try { var userEntities = new BuyGroup365Entities(); var user = userEntities.GetUserByUserName(userName); if (user != null && user.Any()) { return(true); } return(false); } catch (SqlException ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.SqlExceptionUnhandler, "Sql Exeption"); } catch (Exception ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.Unhandler, "Unhandler Exception"); } }
public ActionResult GetBrandShowcase(string type, string info) { string priceDis; string[] splitImg; long brandId = long.Parse(type); ManufacturersBusiness manufacturersBusiness = new ManufacturersBusiness(); Manufacturer brand = manufacturersBusiness.GetById(brandId); BuyGroup365Entities entitis = new BuyGroup365Entities(); List <SearchProductByBrand_Result> listProduct = entitis.SearchProductByBrand(brandId, 1, 4).ToList(); String html = "<div class=\"mage-magictabs mc-" + type + "\">" + "<div class=\"row\"><div class=\"col-xs-12 col-sm-4 trademark-info\">" + "<div class=\"brand-info\"><div class=\"brand-description\"><div class=\"trademark-logo\">" + "<img alt=\"\" src=\"" + brand.Icon + "\"></div>" + "<div class=\"trademark-desc\">" + brand.Description + "</div></div>" + "<a class=\"trademark-link\" href=\"/search-dm0?mid=" + brandId + "\">Xem toàn bộ sản phẩm</a></div> </div> <div class=\"col-xs-12 col-sm-8 trademark-product\">" + "<ul class=\"flexisel-content products-grid featured zoomOut play\">"; foreach (var item in listProduct) { html += "<li class=\"item item-animate\">" + "<div class=\"per-product\">" + "<div class=\"images-container\">" + "<div class=\"product-hover\">"; if (item.IsVip) { html += "<span class=\"sticker top-left\"><span class=\"labelvip\">Vip</span></span>"; } else if (item.IsAttractive) { html += "<span class=\"sticker top-left\"><span class=\"labelnew\">Hot</span></span>"; } html += "<a href=\"" + Common.util.Function.InitUrlDetaiProduct(item.FriendlyUrl, item.Id) + "\" title=\"\" class=\"product-image\">" + "<img class=\"img-responsive\" src=\""; splitImg = item.ImgSource.Split('?'); html += splitImg[0] + "Medium/" + splitImg[1] + "\" width=\"300\" height=\"366\" alt=\"\">" + "</a>" + "</div>" + "</div>" + "<div class=\"products-textlink clearfix\">" + "<h2 class=\"product-name\">" + "<a href=\"" + Common.util.Function.InitUrlDetaiProduct(item.FriendlyUrl, item.Id) + "\" title=\"\">" + item.ProductName + "</a>" + "</h2>"; priceDis = string.Empty; if (item.Cost > item.Price) { priceDis = "<p class=\"old-price\"><span class=\"price\">" + item.Cost.ToString("N0") + "<sup class=\"u-price\">đ</sup></span></p>"; } html += "<div class=\"price-box\">" + priceDis + "<p class=\"special-price\"><span class=\"price\" itemprop=\"price\">" + item.Price.ToString("N0") + "<sup class=\"u-price\">đ</sup></span></p></div>" + "<div class=\"ratings\"><div class=\"rating-box\"><div class=\"rating\" style=\"width:" + InitStar(item.Rate) + "%\"></div></div></div>" + "</div></div> </li>"; } Response.Write(html.ToString()); return(null); }
// // GET: /Home/ //public ActionResult Index() //{ // return View(); //} public ActionResult GetProduct(string type, string info) { BuyGroup365Entities entitis = new BuyGroup365Entities(); string priceDis; string[] splitImg; int intType = 1; if (type.Equals("featured")) { intType = 1; } else if (type.Equals("newproduct")) { intType = 2; } else if (type.Equals("saleproduct")) { intType = 5; } long CatalogId = 0; try { CatalogId = long.Parse(info); } catch { } var listProduct = entitis.SearchProductByType(intType, CatalogId, 1, 12); String html = "<div class=\"mage-magictabs mc-" + type + "\">" + "<ul class=\"flexisel-content products-grid featured zoomOut play\">"; foreach (var item in listProduct) { html += "<li class=\"item item-animate\">" + "<div class=\"per-product\">" + "<div class=\"images-container\">" + "<div class=\"product-hover\">"; if (item.IsVip) { html += "<span class=\"sticker top-left\"><span class=\"labelvip\">Vip</span></span>"; } else if (item.IsAttractive) { html += "<span class=\"sticker top-left\"><span class=\"labelnew\">Hot</span></span>"; } html += "<a href=\"" + Common.util.Function.InitUrlDetaiProduct(item.FriendlyUrl, item.Id) + "\" title=\"\" class=\"product-image\">" + "<img class=\"img-responsive\" src=\""; splitImg = item.ImgSource.Split('?'); html += splitImg[0] + "Small/" + splitImg[1] + "\" alt=\"" + item.ProductName + "\">" + "</a>" + "</div>" + "<div class=\"actions-no hover-box\">" + "<a class=\"detail_links\" href=\"" + Common.util.Function.InitUrlDetaiProduct(item.FriendlyUrl, item.Id) + "\"></a>" + "<div class=\"actions\">" + "<ul class=\"add-to-links pull-left-none\">" + "<li class=\"pull-left-none\"><a href=\"javaScript: void(0);\" onclick=\"SetWishlist(" + item.Id + ")\" title=\"Add to Wishlist\" class=\"link-wishlist\"><i class=\"fa fa-heart-o icons\"></i>Add to Wishlist</a></li>" + "<li class=\"pull-left-none\"><span class=\"separator\">|</span> <a href=\"javaScript: void(0);\" onclick=\"CompareProduct(" + item.Id + ")\" title=\"Add to Compare\" class=\"link-compare\"><i class=\"fa fa-signal icons\"></i>Add to Compare</a></li>" + "<li class=\"link-view pull-left-none\">" + "<a title=\"Quick View\" href=\"http://buygroup365.com/Ajax/QuickView/" + item.Id + "\" class=\"link-quickview\"><i class=\"fa fa-search icons\"></i>Quick View</a>" + "</li>" + "</ul>" + "</div>" + // "<div class=\"actions-cart\">" + // "<button type=\"button\" title=\"Add to Cart\" class=\"button btn-cart pull-left-none\" onclick=\"\" magiccartevent=\"http://buygroup365.com/Ajax/QuickView/4\"><span><span>Add to Cart</span></span></button>" + // "</div>" + "</div>" + "</div>" + "<div class=\"products-textlink clearfix\">" + "<h2 class=\"product-name\">" + "<a href=\"" + Common.util.Function.InitUrlDetaiProduct(item.FriendlyUrl, item.Id) + "\" title=\"\">" + item.ProductName + "</a>" + "</h2>"; priceDis = string.Empty; if (item.Cost > item.Price) { priceDis = "<p class=\"old-price\"><span class=\"price\">" + item.Cost.ToString("N0") + "<sup class=\"u-price\">đ</sup></span></p>"; } html += "<div class=\"price-box\">" + priceDis + "<p class=\"special-price\"><span class=\"price\" itemprop=\"price\">" + item.Price.ToString("N0") + "<sup class=\"u-price\">đ</sup></span></p></div>" + "<div class=\"ratings\"><div class=\"rating-box\"><div class=\"rating\" style=\"width:" + InitStar(item.Rate) + "%\"></div></div></div>" + "</div></div> </li>"; } html += "</ul></div></div>"; Response.Write(html.ToString()); return(null); }
/// <summary> /// Phương thức kiểm tra thông tin đăng nhập dành cho branch /// </summary> /// <param name="userName">UserNamw</param> /// <param name="passWord">Password</param> /// <param name="locationId">ID Rạp</param> /// <param name="computerIp">IP máy</param> /// <param name="computerName">Tên máy</param> /// <returns>UserInfo</returns> public UserInfo CheckLoginBranch(string userName, string passWord, string locationId, string computerIp, string computerName) { try { var userInfo = new UserInfo(); var userEntities = new BuyGroup365Entities(); List <GetUserByUserNameAndPassword_Result> user = userEntities.GetUserByUserNameAndPassword(userName, Common.util.Common.GetMd5Sum(passWord)).ToList(); if (user.Any()) { GetUserByUserNameAndPassword_Result userLogin = user.ElementAt(0); //Kiểm tra xem có phải nhân viên rạp này không if (userLogin.CompanyId == 0 || userLogin.CompanyId == long.Parse(locationId) || userLogin.IsSuperUser) { userInfo.ScreenName = userLogin.Screenname; userInfo.UserId = userLogin.Id; userInfo.UserName = userLogin.Username; //Nếu đã là supper admin thì gán luôn if (userLogin.IsSuperUser) { userInfo.IsSuperUser = true; } else //Ngược lại xem có thuộc Group BRANCH_ADMIN không (Admin BRANCH_ADMIN ~ Supperadmin) { List <GroupInfo> listGroup = new UserUserGroupBusiness().GetByUserId(userInfo.UserId); foreach (GroupInfo group in listGroup) { if (group.Code.Equals("BRANCH_ADMIN")) { userInfo.IsSuperUser = true; break; } } } if (userLogin.DiscountPercent != null) { userInfo.DisountPercent = (float)userLogin.DiscountPercent; } if (userLogin.Status == (int)Common.util.Common.USER_STATUS.ACTIVE) { if (userLogin.Expireddate == null) { userInfo.Status = true; userInfo.StatusMessage = "Trạng thái tốt."; } else { if (((DateTime)userLogin.Expireddate) >= DateTime.Now) { userInfo.Status = true; userInfo.StatusMessage = "Trạng thái tốt."; } else { userInfo.Status = false; userInfo.StatusMessage = "Tài khoản đã hết hạn."; } } } else { userInfo.Status = false; userInfo.StatusMessage = userLogin.Status == (int)Common.util.Common.USER_STATUS.NOACTIVE ? "Tài khoản chưa được active." : "Tài khoản đang bị khóa."; } } else { userInfo.Status = false; userInfo.StatusMessage = "Bạn không được cấp quyền truy cập vào rạp này ."; } } else { userInfo.Status = false; userInfo.StatusMessage = "Tên đăng nhập hoặc mật khẩu không hợp lệ."; } _logger.Info("userInfo: " + JsonConvert.SerializeObject(userInfo)); return(userInfo); } catch (SqlException ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.SqlExceptionUnhandler, "Sql Exeption"); } catch (Exception ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.Unhandler, "Unhandler Exception"); } }
/// <summary> /// Phương thức kiểm tra thông tin đăng nhập /// </summary> /// <param name="userName">UserNamw</param> /// <param name="passWord">Password</param> /// <param name="locationId">ID Rạp</param> /// <param name="computerIp">IP máy</param> /// <param name="computerName">Tên máy</param> /// <returns>UserInfo</returns> public UserInfo CheckLogin(string userName, string passWord, string locationId, string computerIp, string computerName) { try { var userInfo = new UserInfo(); var userEntities = new BuyGroup365Entities(); var user = userEntities.GetUserByUserNameAndPassword(userName, Common.util.Common.GetMd5Sum(passWord)).ToList(); if (user.Any()) { GetUserByUserNameAndPassword_Result userLogin = user.ElementAt(0); userInfo.ScreenName = userLogin.Screenname; userInfo.UserId = userLogin.Id; userInfo.UserName = userLogin.Username; userInfo.IsSuperUser = userLogin.IsSuperUser; if (userLogin.DiscountPercent != null) { userInfo.DisountPercent = (float)userLogin.DiscountPercent; } userInfo.ModifyDate = userLogin.Modifydate; if (userLogin.Status == (int)Common.util.Common.USER_STATUS.ACTIVE) { if (userLogin.Expireddate == null) { userInfo.Status = true; userInfo.StatusMessage = "Trạng thái tốt."; } else { if (((DateTime)userLogin.Expireddate) >= DateTime.Now) { userInfo.Status = true; userInfo.StatusMessage = "Trạng thái tốt."; } else { userInfo.Status = false; userInfo.StatusMessage = "Tài khoản đã hết hạn."; } } } else { userInfo.Status = false; userInfo.StatusMessage = userLogin.Status == (int)Common.util.Common.USER_STATUS.NOACTIVE ? "Tài khoản chưa được active." : "Tài khoản đang bị khóa."; } } else { userInfo.Status = false; userInfo.StatusMessage = "Tên đăng nhập hoặc mật khẩu không hợp lệ."; } _logger.Info("userInfo: " + JsonConvert.SerializeObject(userInfo)); return(userInfo); } catch (SqlException ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.SqlExceptionUnhandler, "Sql Exeption"); } catch (Exception ex) { _logger.Error("", ex); throw ObjectUtil.CreateFaultException(CodedException.Unhandler, "Unhandler Exception"); } }