public async Task <object> UpdateProductBrandToZero(string userId) { var pUserId = Guid.Parse(userId); try { var deleteProdBrand = await HanomaContext.ProductBrand.FirstOrDefaultAsync(p => p.CreateBy == pUserId); if (deleteProdBrand != null) { HanomaContext.ProductBrand.RemoveRange(deleteProdBrand); HanomaContext.SaveChanges(); } var updateAspNetUserProfiles = await HanomaContext.AspNetUserProfiles.FirstOrDefaultAsync(p => p.UserId == userId); if (updateAspNetUserProfiles != null) { updateAspNetUserProfiles.ProductBrand_ID = 0; HanomaContext.SaveChanges(); } } catch (Exception ex) { throw ex; } return(new object()); }
public async Task <List <DashBoashProductBrand_Result> > GetDashBoard(string UserId) { var userProfile = HanomaContext.AspNetUserProfiles.FirstOrDefault(p => p.UserId == UserId); if (userProfile != null && userProfile.ProductBrand_ID > 0) { try { //init param var Tag = new SqlParameter("@pTag", (object)DBNull.Value); var ProductBrandID = new SqlParameter("@pProductBrandID", userProfile.ProductBrand_ID); var result = await HanomaContext.Set <DashBoashProductBrand_Result>() .FromSqlRaw($"EXECUTE dbo.DashBoashProductBrand " + $"@pTag = @pTag, " + $"@pProductBrandID = @pProductBrandID ", Tag, ProductBrandID) .AsNoTracking() .ToListAsync(); return(result); } catch (Exception ex) { } } return(new List <DashBoashProductBrand_Result>()); }
public int UpdateImgProductBrand(ProductBrand model, ImageUploadDTO imgLogo, ImageUploadDTO imgBanner, int ProductBrandId, string UserId) { var pUserId = Guid.Parse(UserId); if (model != null) { var prodBrandSave = HanomaContext.ProductBrand.Find(ProductBrandId); if (prodBrandSave != null) { try { if (imgLogo.Base64 != null) { prodBrandSave.Logo = String.Format("{0}-mobile-logo.{1}", ProductBrandId, imgLogo.ExtensionType.Replace("image/", "")); } if (imgBanner.Base64 != null) { prodBrandSave.Banner = String.Format("{0}-mobile-banner.{1}", ProductBrandId, imgBanner.ExtensionType.Replace("image/", "")); } HanomaContext.SaveChanges(); return(model.ProductBrand_ID); } catch (Exception ex) { return(0); } } } return(ProductBrandId); }
public async Task <Tuple <int, IEnumerable <ProductBrand_Search_Result> > > GetListBrandPagging(int page, int pageSize, int?LocationId, int active, int?productCategoryId, string keyword) { var Keyword = new SqlParameter("@Keyword", String.IsNullOrEmpty(keyword) ? (object)DBNull.Value : keyword); var Active = new SqlParameter("@Active", active); var PageSize = new SqlParameter("@PageSize", pageSize); var CurrentPage = new SqlParameter("@CurrentPage", page); var ProductCategory_ID = new SqlParameter("@ProductCategory_ID", productCategoryId ?? (object)DBNull.Value); var Location_Id = new SqlParameter("@Location_ID", LocationId ?? (object)DBNull.Value); var ItemCount = new SqlParameter("@ItemCount", "") { Direction = System.Data.ParameterDirection.Output, DbType = System.Data.DbType.Int32 }; var output = await HanomaContext.Set <ProductBrand_Search_Result>() .FromSqlRaw($"EXECUTE dbo.ProductBrand_Search " + $"@Keyword = @Keyword, " + $"@Active = @Active, @PageSize = @PageSize,@Location_ID = @Location_ID, @ProductCategory_ID = @ProductCategory_ID, @CurrentPage = @CurrentPage, @ItemCount = @ItemCount OUTPUT", Keyword, Active, PageSize, Location_Id, ProductCategory_ID, CurrentPage, ItemCount) .AsNoTracking() .ToListAsync(); var ItemCountRes = Convert.ToInt32(ItemCount.Value); return(new Tuple <int, IEnumerable <ProductBrand_Search_Result> >(ItemCountRes, output)); }
public async Task <IEnumerable <GetMenuProdCateByUser_Result> > GetMenuProdCateByUser(string UserId, int?productTypeId, int?statusTypeId, int parentId = 656) { var pUserId = new SqlParameter("@UserId", UserId ?? (object)DBNull.Value); var pParenId = new SqlParameter("@ParenId", parentId); var pProductTypeId = new SqlParameter("@ProductTypeId", productTypeId ?? (object)DBNull.Value); var pStatusTypeId = new SqlParameter("@StatusTypeId", statusTypeId ?? (object)DBNull.Value); try { var output = await HanomaContext.Set <GetMenuProdCateByUser_Result>() .FromSqlRaw($"EXECUTE GetMenuProdCateByUser @UserId = @UserId, " + $"@ParenId = @ParenId, " + $"@ProductTypeId = @ProductTypeId, " + $"@StatusTypeId = @StatusTypeId ", pUserId, pParenId, pProductTypeId, pStatusTypeId) .AsNoTracking() .ToListAsync(); return(output); } catch (Exception ex) { return(new List <GetMenuProdCateByUser_Result>()); } }
public async Task <IEnumerable <ProductBrand_Search_Brand_V2_Result> > GetListProductBrand(ProductBrandFilter filter) { var Keyword = new SqlParameter("@Keyword", filter.Keyword); var StatusType_ID = new SqlParameter("@StatusType_ID", filter.StatusTypeId); var PageSize = new SqlParameter("@PageSize", filter.PageSize); var CurrentPage = new SqlParameter("@CurrentPage", filter.Page); var ProductType_ID = new SqlParameter("@ProductType_ID", filter.ProductTypeID); var ProductCategory_ID = new SqlParameter("@ProductCategory_ID", filter.ProductCategoryID); var AccesoryCategory_ID = new SqlParameter("@AccesoryCategory_ID", filter.AccesoryCategoryID); var Location_ID = new SqlParameter("@Location_ID", filter.LocationID); var result = await HanomaContext.Set <ProductBrand_Search_Brand_V2_Result>() .FromSqlRaw($"EXECUTE dbo.ProductBrand_Search_Brand_V2 " + $"@Keyword = @Keyword, " + $"@ProductType_ID = @ProductType_ID, " + $"@ProductCategory_ID = @ProductCategory_ID, " + $"@AccesoryCategory_ID = @AccesoryCategory_ID, " + $"@Location_ID = @Location_ID, " + $"@StatusType_ID = @StatusType_ID, " + $"@PageSize = @PageSize, " + $"@CurrentPage = @CurrentPage ", Keyword, ProductType_ID, ProductCategory_ID, AccesoryCategory_ID, Location_ID, StatusType_ID, PageSize, CurrentPage ) .AsNoTracking() .ToListAsync(); return(result); }
public async Task <CountHistoryShopingCart_Result> GetCountHistoryShopingCart(CountHistoryShoppingCart model) { var pUserId = new SqlParameter("@UserId", model.UserId ?? (object)DBNull.Value); var pProductBrandId = new SqlParameter("@ProductBrandId", model.ProductBrandId ?? (object)DBNull.Value); var pFromDate = new SqlParameter("@FromDate", model.FromDate ?? (object)DBNull.Value); var pToDate = new SqlParameter("@ToDate", model.ToDate ?? (object)DBNull.Value); var pShopingCartCode = new SqlParameter("@ShopingCartCode", model.ShopingCartCode ?? (object)DBNull.Value); try { var output = await HanomaContext.Set <CountHistoryShopingCart_Result>() .FromSqlRaw($"EXECUTE dbo.CountHistoryShopingCart " + $"@UserId = @UserId, " + $"@ProductBrandId = @ProductBrandId, " + $"@ShopingCartCode = @ShopingCartCode, " + $"@FromDate = @FromDate, " + $"@ToDate = @ToDate ", pUserId, pProductBrandId, pShopingCartCode, pFromDate, pToDate ) .AsNoTracking() .ToListAsync(); return(output.FirstOrDefault()); } catch (Exception ex) { } return(new CountHistoryShopingCart_Result()); }
public async Task <List <GetDashBoard_Result> > GetDashBoardPharse2(string UserId, int?CustomerFilter, int?PostFilter, int?OrderFilter, int?FinanceFilter) { var userProfile = HanomaContext.AspNetUserProfiles.FirstOrDefault(p => p.UserId == UserId); if (userProfile != null && userProfile.ProductBrand_ID > 0) { try { //init param var pProductBrandID = new SqlParameter("@pProductBrandID", userProfile.ProductBrand_ID); var pCustomerFilter = new SqlParameter("@pCustomerFilter", CustomerFilter ?? (object)DBNull.Value); var pPostFilter = new SqlParameter("@pPostFilter", PostFilter ?? (object)DBNull.Value); var pOrderFilter = new SqlParameter("@pOrderFilter", OrderFilter ?? (object)DBNull.Value); var pFinanceFilter = new SqlParameter("@pFinanceFilter", FinanceFilter ?? (object)DBNull.Value); var result = await HanomaContext.Set <GetDashBoard_Result>() .FromSqlRaw($"EXECUTE dbo.GetDashBoard " + $"@pProductBrandID = @pProductBrandID, " + $"@pCustomerFilter = @pCustomerFilter, " + $"@pPostFilter = @pPostFilter, " + $"@pOrderFilter = @pOrderFilter, " + $"@pFinanceFilter = @pFinanceFilter ", pProductBrandID, pCustomerFilter, pPostFilter, pOrderFilter, pFinanceFilter) .AsNoTracking() .ToListAsync(); return(result); } catch (Exception ex) { } } return(new List <GetDashBoard_Result>()); }
public async Task <ArticleSearchDTO> SearchArticle(string keyword, int?ArticleCategory_ID, int?ArticleTypeId, int?page, int?PageSize) { var output = new ArticleSearchDTO(); var pKeyword = new SqlParameter("@Keyword", keyword); var pArticleCategory_ID = new SqlParameter("@ArticleCategory_ID", ArticleCategory_ID ?? (object)DBNull.Value); var pArticleTypeId = new SqlParameter("@ArticleType_ID", ArticleTypeId ?? (object)DBNull.Value); var pPage = new SqlParameter("@CurrentPage", page ?? 1); var pPageSize = new SqlParameter("@PageSize", PageSize ?? 10); var pActiveCount = new SqlParameter("@ActiveCount", SqlDbType.Int) { Direction = ParameterDirection.Output }; var pDeActiveCount = new SqlParameter("@DeActiveCount", SqlDbType.Int) { Direction = ParameterDirection.Output }; var pItemCount = new SqlParameter("@ItemCount", SqlDbType.Int) { Direction = ParameterDirection.Output }; //var pExceptionArticleID = new SqlParameter("@ExceptionArticle_ID", ArticleCategory_ID ?? (object)DBNull.Value); output.Data = await HanomaContext.Set <Article_Search_Result>() .FromSqlRaw( $"EXECUTE dbo.Article_Search_Mobile @Keyword = @Keyword, @ArticleCategory_ID = @ArticleCategory_ID, @ArticleType_ID = @ArticleType_ID,@CurrentPage = @CurrentPage,@PageSize = @PageSize,@ActiveCount = @ActiveCount out, @DeActiveCount = @DeActiveCount out, @ItemCount = @ItemCount out", pKeyword, pArticleCategory_ID, pArticleTypeId, pPage, pPageSize, pActiveCount, pDeActiveCount, pItemCount) .AsNoTracking() .ToListAsync(); output.CurrentPage = page ?? 1; output.PageSize = PageSize ?? 10; output.TotalRecord = (int)pItemCount.Value; output.TotalPage = (int)pActiveCount.Value; return(output); }
public async Task AddNewFCMMessage(FCMMessage model) { FCMMessage item = new FCMMessage(); item = model; HanomaContext.Add(item); await HanomaContext.SaveChangesAsync(); }
public Task UpdateData(FCMMessage Content) { //FCMMessage CurrentFCMMessage = HanomaContext.FCMMessage.FirstOrDefault(p => p.FCMMessage_ID == FCMMessage_ID); FCMMessage CurrentFCMMessage = new FCMMessage(); CurrentFCMMessage.Title = Content.Title; CurrentFCMMessage.Body = Content.Body; CurrentFCMMessage.Content = Content.Content; CurrentFCMMessage.UserName = ""; CurrentFCMMessage.UserID = Content.UserID; CurrentFCMMessage.NotificationType = Content.NotificationType; CurrentFCMMessage.Form_ID = Content.Form_ID; CurrentFCMMessage.ParameterId = Content.ParameterId ?? 0; CurrentFCMMessage.FullUrl = Content.FullUrl; CurrentFCMMessage.Topic = Content.Topic; CurrentFCMMessage.CreateDate = DateTime.Now; CurrentFCMMessage.CreateBy = Content.UserID; CurrentFCMMessage.UserID = Content.UserID; HanomaContext.FCMMessage.Add(CurrentFCMMessage); HanomaContext.SaveChangesAsync(); //Insert FCMMessageToken //if (Content.Topic == "Global") //{ // var ItemClient = HanomaContext.FCMClient.Select(p => p.UserID).Distinct().ToList(); // foreach (var p in ItemClient) // { // FCMMessageForTokken item = new FCMMessageForTokken(); // if (p != null) item.UserID = p.Value; // item.FCMMessage_ID = CurrentFCMMessage.FCMMessage_ID; // item.CreateBy = Guid.Parse(User_ID); // item.CreateDate = DateTime.Now; // HanomaContext.FCMMessageForTokken.Add(item); // HanomaContext.SaveChangesAsync(); // } //} //else //{ // var ItemClient = HanomaContext.FCMClient.Where(p => p.Topic == Content.Topic).Select(i => i.UserID).Distinct().ToList(); // if (ItemClient != null) // { // foreach (var p in ItemClient) // { // FCMMessageForTokken item = new FCMMessageForTokken(); // if (p != null) item.UserID = p.Value; // item.FCMMessage_ID = CurrentFCMMessage.FCMMessage_ID; // item.CreateBy = Guid.Parse(User_ID); // item.CreateDate = DateTime.Now; // HanomaContext.FCMMessageForTokken.Add(item); // HanomaContext.SaveChangesAsync(); // } // } //} return(Task.CompletedTask); }
public async Task UpdateImgBannerProductBrand(string fileName, int ProductBrandId) { var prodBrand = HanomaContext.ProductBrand.Find(ProductBrandId); if (prodBrand != null) { prodBrand.Banner = fileName; HanomaContext.SaveChanges(); } }
public int AddNewData(string UserID) { FCMMessage CurrentFCMMessage = new FCMMessage(); CurrentFCMMessage.CreateDate = DateTime.Now; CurrentFCMMessage.CreateBy = Guid.Parse(UserID); HanomaContext.FCMMessage.Add(CurrentFCMMessage); HanomaContext.SaveChangesAsync(); return(CurrentFCMMessage.FCMMessage_ID); }
public async Task UpgradePackageBrand(int ProductBrandId, int ProductBrandTypeId) { var prodBrand = HanomaContext.ProductBrand.Find(ProductBrandId); if (prodBrand != null) { prodBrand.ProductBrandType_ID = ProductBrandTypeId; HanomaContext.SaveChanges(); } }
public ProductController(IRepositoryWrapper repoWrapper, ILoggerManager logger, IMapper mapper, HanomaContext _hanomaContext, IDistributedCache distributedCache, IPaymentRepositoryWrapper repoPaymentWrapper, IConfiguration configuration) { hanomaContext = _hanomaContext; _repoWrapper = repoWrapper; _logger = logger; _mapper = mapper; _distributedCache = distributedCache; _repoPaymentWrapper = repoPaymentWrapper; _configuration = configuration; }
public async Task UpdateImgLogoLibrary(string fileName, int LibraryId) { var lib = HanomaContext.Library.Find(LibraryId); if (lib != null) { lib.Image = fileName; HanomaContext.SaveChanges(); } }
public async Task <List <GetArticleHome_Result> > GetArtByCateHome(string keyword) { var pKeyword = new SqlParameter("@Keyword", keyword); return(await HanomaContext.Set <GetArticleHome_Result>() .FromSqlRaw( $"EXECUTE dbo.GetArticleHome @Keyword = @Keyword", pKeyword) .AsNoTracking() .ToListAsync()); }
public void CreateNewUserProfile(string userId, string Email, string Phone = null, int?accountType = 1) { try { var profileExist = HanomaContext.AspNetUserProfiles.FirstOrDefault(x => x.UserId.Equals(userId)); if (profileExist != null) { return; } var regtype = String.IsNullOrEmpty(Phone) ? "Email" : "Phone"; if (regtype == "Email") { //SendEmailToCEO(userId, Email); } else { //SendEmailToCEO(userId, Phone); } var roles = HanomaContext.AspNetRoles.ToList(); var productBrand_ID = 0; HanomaContext.AspNetUserRoles.Add(new AspNetUserRoles() { UserId = userId, RoleId = roles.FirstOrDefault(x => x.Name.Equals("Thành viên")).Id }); var profilers = new AspNetUserProfiles { UserId = userId, //FullName = Email, Phone = Phone, AccountType = 1, //accountType ?? 1, ProductBrand_ID = productBrand_ID, RegType = regtype, RegisterDate = DateTime.Now, LastActivityDate = DateTime.Now, Rank = 1, Location_ID = -1 }; var profile = HanomaContext.AspNetUserProfiles.Add(profilers); HanomaContext.SaveChanges(); } catch (Exception exception) { throw exception; } }
public void UpdateFCMClient(Guid fcmClientId, FCMClient fcmClient) { var fcmClientItem = HanomaContext.FCMClient.Find(fcmClientId); if (fcmClientItem != null) { fcmClientItem.LastSeen = DateTime.Now; fcmClientItem.UserID = fcmClient.UserID; fcmClientItem.UserName = fcmClient.UserName; fcmClientItem.Topic = fcmClient.UserID.ToString(); HanomaContext.SaveChanges(); } }
public void UpdateUserProfiler(string userId, int productBrandId) { try { var profiler = HanomaContext.AspNetUserProfiles.FirstOrDefault(x => x.UserId.Equals(userId)); profiler.ProductBrand_ID = productBrandId; HanomaContext.SaveChanges(); } catch (Exception exception) { // log.Error(exception); } }
public async Task <List <ProductHighLight_Search_Result> > GetSponsorProduct(int CategoryId, int?ProductTypeId, int Top) { var pProductCategoryId = new SqlParameter("@ProductCategory_ID", CategoryId); var pProductTypeId = new SqlParameter("@ProductType_ID", ProductTypeId); var output = await HanomaContext.Set <ProductHighLight_Search_Result>() .FromSqlRaw($"EXECUTE dbo.ProductHighLight_Search " + $"@ProductCategory_ID = @ProductCategory_ID, " + $"@ProductType_ID = @ProductType_ID ", pProductCategoryId, pProductTypeId) .AsNoTracking() .ToListAsync(); return(output); }
public void UpdateUrl(int libraryId) { try { var lib = HanomaContext.Library.FirstOrDefault(x => x.Library_ID == libraryId); var urlNew = FormatURL(lib.Title) + "-" + lib.Library_ID.ToString(); lib.URL = urlNew; HanomaContext.SaveChanges(); } catch (Exception exception) { //log.Error(exception); } }
public void UpdateUrlProductBrand(int productBrandId) { try { var productBrand = HanomaContext.ProductBrand.FirstOrDefault(x => x.ProductBrand_ID == productBrandId); var urlNew = FormatURL(productBrand.Name) + "-" + productBrand.ProductBrand_ID.ToString(); productBrand.URL = urlNew; HanomaContext.SaveChanges(); } catch (Exception exception) { //log.Error(exception); } }
public async Task <List <ProductBrand> > GetTopBrand(int topX) { var BlockName = new SqlParameter("@BlockName", "enterprise_reputation"); var output = await HanomaContext.Set <ProductBrand>() .FromSqlRaw($" SELECT TOP {topX} P.* FROM dbo.ProductBrand AS P WITH (NOLOCK)" + $" INNER JOIN dbo.ProductBrandBlockProductBrand AS BBP WITH(NOLOCK) ON BBP.ProductBrand_id = P.ProductBrand_ID" + $" INNER JOIN dbo.ProductBrandBlock AS BB WITH(NOLOCK) ON BBP.ProductBrandBlock_id = BB.ProductBrandBlock_id" + $" WHERE BB.Name = @BlockName", BlockName) .AsNoTracking() .ToListAsync(); return(output); }
public void CreateUserSocial(string LoginProvider, string ProviderKey, string UserId) { var checkExist = HanomaContext.AspNetUserLogins.FirstOrDefault(p => p.LoginProvider == LoginProvider && p.ProviderKey == ProviderKey); if (checkExist == null) { AspNetUserLogins item = new AspNetUserLogins(); item.LoginProvider = LoginProvider; item.ProviderKey = ProviderKey; item.UserId = UserId; HanomaContext.AspNetUserLogins.Add(item); HanomaContext.SaveChangesAsync(); } }
public async Task <bool> UpdateBrandReferralCode(int ProductBrandId, string ReferralCode) { var prodBrand = HanomaContext.ProductBrand.Find(ProductBrandId); if (prodBrand != null) { prodBrand.ReferralCode = ReferralCode; prodBrand.ReferralCodeDate = DateTime.Now; HanomaContext.SaveChangesAsync(); return(true); } else { return(false); } }
public async Task <IEnumerable <Video_Search_Mobile_Result> > GetVideoByCate(int?VideoCategory_ID, int ArticleTypeId, int?page, int PageSize) { var pVideoCategory_ID = new SqlParameter("@VideoCategory_ID", VideoCategory_ID ?? (object)DBNull.Value); var pArticleTypeId = new SqlParameter("@ArticleType_ID", ArticleTypeId); var pPage = new SqlParameter("@CurrentPage", page ?? 1); var pPageSize = new SqlParameter("@PageSize", PageSize); var pStatusTypeID = new SqlParameter("@StatusType_ID", 4); var result = await HanomaContext.Set <Video_Search_Mobile_Result>() .FromSqlRaw( $"EXECUTE dbo.Video_Search_Mobile @VideoCategory_ID=@VideoCategory_ID, @StatusType_ID = @StatusType_ID, @ArticleType_ID = @ArticleType_ID,@CurrentPage = @CurrentPage,@PageSize = @PageSize ", pVideoCategory_ID, pStatusTypeID, pArticleTypeId, pPage, pPageSize) .AsNoTracking() .ToListAsync(); return(result); }
public async Task <bool> DeleteDeliveryAddress(int Id, string UserId) { var pUserId = Guid.Parse(UserId); var item = await HanomaContext.DeliveryAddress.FirstOrDefaultAsync(p => p.CreateBy == pUserId && p.Id == Id); if (item == null) { return(false); } else { HanomaContext.DeliveryAddress.Remove(item); await HanomaContext.SaveChangesAsync(); return(true); } }
public async Task <int> SubscriptionEmail(string email) { var result = new Subscription(); var subscription = await HanomaContext.Subscription.FirstOrDefaultAsync(x => x.Email.Equals(email)); var model = new Subscription { Email = email, CreateDate = DateTime.Now, Active = true }; await HanomaContext.Subscription.AddAsync(model); await HanomaContext.SaveChangesAsync(); return(model.Subscription_ID); }
public async Task <bool> PostShopingCartAction(ShoppingCartDetailDTO model) { var item = HanomaContext.ShoppingCartDetail.Find(model.Id); if (item != null) { item.StatusCart = model.StatusCart; item.ReasonCancel = model.ReasonCancel; // Lý do hủy item.IsCancelByBuyer = model.IsCancelByBuyer; item.LastEditBy = Guid.Parse(model.UserId); item.LastEditDate = DateTime.Now; await HanomaContext.SaveChangesAsync(); } else { return(false); } return(true); }