private async Task <IActionResult> PutSetting(int id, Setting setting) { if (id != setting.Setting_ID) { return(BadRequest()); } _context.Entry(setting).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SettingExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
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 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 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 <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); }
public async Task <bool> PostContactAds(ContactAdsDTO model) { try { var modelContact = new ContactAds(); modelContact.Name = model.Name; modelContact.Address = model.Address; modelContact.Content = model.Content; modelContact.Mobile = model.Mobile; modelContact.Email = model.Email; modelContact.CreateDate = DateTime.Now; modelContact.LastEditDate = DateTime.Now; modelContact.Status = 1; HanomaContext.ContactAds.Add(modelContact); await HanomaContext.SaveChangesAsync(); } catch (Exception ex) { return(false); } return(true); }
public async Task <List <ShoppingCartDetail> > PostShopingCart(List <PostShoppingCart> model) { var output = new List <ShoppingCartDetail>(); try { if (model != null) { foreach (var item in model) { ShoppingCartMaster itemMaster = new ShoppingCartMaster(); itemMaster.UserId = Guid.Parse(item.UserId); itemMaster.ProductBrandId = item.ProductBrandID; itemMaster.DeliveryAddress = item.DeliveryAddress; itemMaster.TotalAmount = item.TotalAmmout; itemMaster.CreateBy = Guid.Parse(item.UserId); itemMaster.CreateDate = DateTime.Now; itemMaster.LastEditBy = Guid.Parse(item.UserId); itemMaster.LastEditDate = DateTime.Now; HanomaContext.ShoppingCartMaster.Add(itemMaster); await HanomaContext.SaveChangesAsync(); foreach (var p in item.LstShopCartDetail) { var lastId = await HanomaContext.ShoppingCartDetail.OrderByDescending(p => p.Id).FirstOrDefaultAsync(); ShoppingCartDetail itemDetail = new ShoppingCartDetail(); itemDetail.ShoppingCartMasterId = itemMaster.Id; itemDetail.ShopingCartCode = "HNM" + String.Format("{0:D7}", lastId == null ? 1 : lastId.Id + 1); itemDetail.ProductId = p.ProductId; var itemProduct = await HanomaContext.Product.FindAsync(p.ProductId); if (itemProduct != null) // Get price from server { itemDetail.Price = p.Price; } itemDetail.Qty = p.Qty; itemDetail.DisCount = p.Discount; itemDetail.Remark = p.Remark; itemDetail.StatusCart = 1; // Waiting confirm itemDetail.CreateBy = Guid.Parse(item.UserId); itemDetail.CreateDate = DateTime.Now; itemDetail.LastEditBy = Guid.Parse(item.UserId); itemDetail.LastEditDate = DateTime.Now; HanomaContext.ShoppingCartDetail.Add(itemDetail); await HanomaContext.SaveChangesAsync(); // output.Add(itemDetail); } } } else { return(output); } } catch (Exception ex) { return(output); } return(output); }
public async Task <bool> PostDeliveryAddress(DeliveryAddressDTO model) { try { if (model != null) { var pUserId = Guid.Parse(model.UserId); var item = await HanomaContext.DeliveryAddress.FirstOrDefaultAsync(p => p.Id == model.Id && p.CreateBy == pUserId); if (item == null) { //Add Delivery var addItem = new DeliveryAddress(); addItem.UserId = pUserId; addItem.UserName = model.UserName; addItem.PhoneNumber = model.PhoneNumber; addItem.LocationId = model.LocationId; addItem.DistrictId = model.DistrictId; addItem.Address = model.Address; addItem.IsDefault = model.IsDefault; addItem.CreateBy = pUserId; addItem.CreateDate = DateTime.Now; addItem.LastEditBy = pUserId; addItem.LastEditDate = DateTime.Now; HanomaContext.DeliveryAddress.Add(addItem); await HanomaContext.SaveChangesAsync(); //Update Default if (model.IsDefault == true) { var lstItem = await HanomaContext.DeliveryAddress.Where(p => p.CreateBy == pUserId).ToListAsync(); foreach (var p in lstItem) { if (p.Id == addItem.Id) { continue; } var pItem = await HanomaContext.DeliveryAddress.FirstOrDefaultAsync(x => x.Id == p.Id); pItem.IsDefault = false; await HanomaContext.SaveChangesAsync(); } } } else { //Update item.UserName = model.UserName; item.PhoneNumber = model.PhoneNumber; item.LocationId = model.LocationId; item.DistrictId = model.DistrictId; item.Address = model.Address; item.IsDefault = model.IsDefault; item.LastEditBy = pUserId; item.LastEditDate = DateTime.Now; await HanomaContext.SaveChangesAsync(); //Update Default if (model.IsDefault == true) { var lstItem = await HanomaContext.DeliveryAddress.Where(p => p.CreateBy == pUserId).ToListAsync(); foreach (var p in lstItem) { if (p.Id == model.Id) { continue; } var pItem = await HanomaContext.DeliveryAddress.FirstOrDefaultAsync(x => x.Id == p.Id); pItem.IsDefault = false; await HanomaContext.SaveChangesAsync(); } } } } } catch (Exception ex) { return(false); } return(true); }
public async Task <int> PostProductBrand(ProductBrand model, ImageUploadDTO imgLogo, ImageUploadDTO imgBanner, string UserId) { var pUserId = Guid.Parse(UserId); if (model != null) { var prodBrandSave = HanomaContext.ProductBrand.Find(model.ProductBrand_ID); if (prodBrandSave == null) { var productBrandNew = new ProductBrand { Location_ID = model.Location_ID, Name = model.Name, TradingName = model.TradingName, BrandName = model.BrandName, BusinessArea = model.BusinessArea, Address = model.Address, Telephone = model.Telephone, Mobile = model.Mobile, Website = model.Website, Description = model.Description, Email = model.Email, LastEditDate = DateTime.Now, CreateDate = DateTime.Now, Verified = true, Active = true, URL = null, CreateBy = new Guid(UserId), LastEditBy = new Guid(UserId), District = model.District, PostalCode = model.PostalCode, Country_ID = model.Country_ID, EmailDisplay = model.EmailDisplay, MapCode = model.MapCode, ReferralCode = model.ReferralCode, ProductBrandType_ID = 1 // Gian hàng quy mô nhỏ }; try { HanomaContext.ProductBrand.Add(productBrandNew); await HanomaContext.SaveChangesAsync(); UpdateUrlProductBrand(productBrandNew.ProductBrand_ID); UpdateProductBrandIdOfProduct(UserId, productBrandNew.ProductBrand_ID); UpgradeAccountAfterRegister(UserId); UpdateUserProfiler(UserId, productBrandNew.ProductBrand_ID); return(productBrandNew.ProductBrand_ID); } catch (Exception ex) { productBrandNew.ProductBrand_ID = 0; return(productBrandNew.ProductBrand_ID); } } else { try { var urlNew = FormatURL(model.Name) + "-" + model.ProductBrand_ID.ToString(); prodBrandSave.Location_ID = model.Location_ID; prodBrandSave.Name = model.Name; prodBrandSave.TradingName = model.TradingName; prodBrandSave.BrandName = model.BrandName; prodBrandSave.BusinessArea = model.BusinessArea; prodBrandSave.Address = model.Address; prodBrandSave.Telephone = model.Telephone; prodBrandSave.Mobile = model.Mobile; prodBrandSave.Website = model.Website; prodBrandSave.Description = model.Description; prodBrandSave.Email = model.Email; prodBrandSave.LastEditDate = DateTime.Now; prodBrandSave.Verified = true; prodBrandSave.Active = true; prodBrandSave.URL = urlNew; prodBrandSave.LastEditBy = pUserId; prodBrandSave.District = model.District; prodBrandSave.PostalCode = model.PostalCode; prodBrandSave.Country_ID = model.Country_ID; prodBrandSave.EmailDisplay = model.EmailDisplay; prodBrandSave.MapCode = model.MapCode; prodBrandSave.ReferralCode = model.ReferralCode; await HanomaContext.SaveChangesAsync(); UpdateUserProfiler(UserId, model.ProductBrand_ID); return(model.ProductBrand_ID); } catch (Exception ex) { return(0); } } } return(model.ProductBrand_ID); }
public async Task Log(LogAPI apiLogItem) { _db.LogAPI.Add(apiLogItem); await _db.SaveChangesAsync(); }
public Task <int> SaveChangesAsync() { return(_hanomaContext.SaveChangesAsync()); }
public async Task <int> PostLibrary(Library model, ImageUploadDTO imgLogo, string UserId) { var pUserId = Guid.Parse(UserId); if (model != null) { var libSave = HanomaContext.Library.Find(model.Library_ID); if (libSave == null) { var libraryNew = new Library { LibraryCategory_ID = model.LibraryCategory_ID, LibraryType_ID = model.LibraryType_ID, Title = model.Title, SubTitle = model.SubTitle, Image = model.Image, Description = model.Description, Content = model.Content, Author = model.Author, CreateDate = DateTime.Now, Counter = model.Counter, Active = true, URL = null, CreateBy = new Guid(UserId), LastEditBy = new Guid(UserId), LastEditDate = model.LastEditDate, Tag = model.Tag, Keyword = model.Keyword, AllowComment = model.AllowComment, MetaTitle = model.MetaTitle, MetaDescription = model.MetaDescription, AuthorPhone = model.AuthorPhone, MetaKeywords = model.MetaKeywords, AuthorEmail = model.AuthorEmail, AuthorJob = model.AuthorJob, AuthorCompany = model.AuthorCompany, ProductCategoryID = model.ProductCategoryID, ManufactoryID = model.ManufactoryID, ModelID = model.ModelID, StatusType_ID = 2, }; try { HanomaContext.Library.Add(libraryNew); await HanomaContext.SaveChangesAsync(); UpdateUrl(libraryNew.Library_ID); return(libraryNew.Library_ID); } catch (Exception ex) { libraryNew.Library_ID = 0; return(libraryNew.Library_ID); } } else { try { var urlNew = FormatURL(model.Title) + "-" + model.Library_ID.ToString(); libSave.LibraryCategory_ID = model.LibraryCategory_ID; libSave.LibraryType_ID = model.LibraryType_ID; libSave.Title = model.Title; libSave.SubTitle = model.SubTitle; libSave.Image = model.Image; libSave.Description = model.Description; libSave.Content = model.Content; libSave.Author = model.Author; libSave.CreateDate = DateTime.Now; libSave.Counter = model.Counter; libSave.Active = true; libSave.URL = null; libSave.CreateBy = new Guid(UserId); libSave.LastEditBy = new Guid(UserId); libSave.LastEditDate = model.LastEditDate; libSave.Tag = model.Tag; libSave.Keyword = model.Keyword; libSave.AllowComment = model.AllowComment; libSave.MetaTitle = model.MetaTitle; libSave.MetaDescription = model.MetaDescription; libSave.AuthorPhone = model.AuthorPhone; libSave.MetaKeywords = model.MetaKeywords; libSave.AuthorEmail = model.AuthorEmail; libSave.AuthorJob = model.AuthorJob; libSave.AuthorCompany = model.AuthorCompany; libSave.ProductCategoryID = model.ProductCategoryID; libSave.ManufactoryID = model.ManufactoryID; libSave.ModelID = model.ModelID; libSave.StatusType_ID = -1; await HanomaContext.SaveChangesAsync(); return(model.Library_ID); } catch (Exception ex) { return(0); } } } return(model.Library_ID); }