/// <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");
}
}
