public string Insert ( string name, string description, string code, string link, byte state, DateTime createdAt, DateTime updatedAt ) { using (var entities = new V308CMSEntities()) { var menuConfig = (from item in entities.MenuConfig where item.Name == name select item ).FirstOrDefault(); if (menuConfig == null) { var newMenuConfig = new MenuConfig { Name = name, Description = description, Code = code, Link = link, State = state, CreatedAt = createdAt, UpdatedAt = updatedAt }; entities.MenuConfig.Add(newMenuConfig); entities.SaveChanges(); return("ok"); } return("exists"); } }
public List <Account> GetList(int state = 0) { using (var entities = new V308CMSEntities()) { IEnumerable <Account> data = (from user in entities.Account select user ).ToList(); if (state > 0) { data = state == 1 ? (from user in data where user.Status == true select user ).ToList() : (from user in data where user.Status == false select user ).ToList(); } return((from user in data orderby user.ID descending select user ).ToList()); } }
public string Update(Banner data) { using (var entities = new V308CMSEntities()) { var bannerUpdate = (from banner in entities.Banner where banner.Id == data.Id select banner).FirstOrDefault(); if (bannerUpdate != null) { bannerUpdate.Name = data.Name; bannerUpdate.Description = data.Description; bannerUpdate.Position = data.Position; bannerUpdate.Width = data.Width; bannerUpdate.Height = data.Height; bannerUpdate.StartDate = data.StartDate; bannerUpdate.EndDate = data.EndDate; bannerUpdate.ImageUrl = data.ImageUrl; bannerUpdate.Status = data.Status; bannerUpdate.CreatedAt = data.CreatedAt; bannerUpdate.UpdatedAt = data.UpdatedAt; entities.SaveChanges(); return("ok"); } return("not_exists"); } }
public JsonResult getShopCart() { V308CMSEntities mEntities = new V308CMSEntities(); AccountRepository accountRepository = new AccountRepository(mEntities); ProductRepository productRepository = new ProductRepository(mEntities); try { ShopCart mShopCart; if (Session["ShopCart"] != null) { mShopCart = (ShopCart)Session["ShopCart"]; return(Json(new { code = 1, count = 1, totalprice = String.Format("{0: 0,0}", (mShopCart.getTotalPrice())), message = "Không tìm thấy sản phẩm.", html = V308HTMLHELPER.createShopCart(mShopCart) })); } else { return(Json(new { code = 0, count = 1, totalprice = 0, message = "Không tìm thấy sản phẩm." })); } } catch (Exception ex) { return(Json(new { code = 0, count = 1, totalprice = 0, message = "Có lỗi xảy ra. Vui lòng thử lại." })); } finally { mEntities.Dispose(); accountRepository.Dispose(); } }
public ActionResult NewsDetail(int pId = 0) { V308CMSEntities mEntities = new V308CMSEntities(); NewsRepository newsRepository = new NewsRepository(mEntities); NewsPage mCommonModel = new NewsPage(); StringBuilder mStr = new StringBuilder(); News mNews; try { //lay chi tiet san pham mNews = newsRepository.LayTinTheoId(pId); if (mNews != null) { mCommonModel.pNews = mNews; //mListLienQuan = newsRepository.LayTinTucLienQuan(mNews.ID, (int)mNews.TypeID, 4); //tao Html tin tuc lien quan } else { mCommonModel.Html = "Không tìm thấy sản phẩm"; } return(View(mCommonModel)); } catch (Exception ex) { return(Content("<h2>Có lỗi xảy ra trên hệ thống ! Vui lòng thử lại sau.</h2>")); } finally { mEntities.Dispose(); newsRepository.Dispose(); } }
public string CreateOrUpdate(Permission data) { using (var entities = new V308CMSEntities()) { var permissionUpdate = (from permission in entities.Permission where permission.GroupPermission == data.GroupPermission && permission.RoleId == data.RoleId select permission ).FirstOrDefault(); if (permissionUpdate != null) { if (permissionUpdate.Value != data.Value) { permissionUpdate.Value = data.Value; entities.SaveChanges(); return("update_ok"); } return("update_exists"); } else { string insertResult = Insert(data); //return $"create_{insertResult}"; return(string.Format("create_{0}", insertResult)); } } }
public string Update(int id, string name, int parentId, string icon, string description, string image, string imageBanner, int number, DateTime createdDate, bool status, bool isHome) { using (var entities = new V308CMSEntities()) { var productType = (from type in entities.ProductType where type.ID == id select type ).FirstOrDefault(); if (productType != null) { productType.Name = name; productType.Parent = parentId; productType.Icon = icon; productType.Description = description; if (!string.IsNullOrWhiteSpace(image) && productType.Image != image) { productType.Image = image; } if (!string.IsNullOrWhiteSpace(imageBanner) && productType.ImageBanner != imageBanner) { productType.ImageBanner = imageBanner; } productType.Number = number; productType.Date = createdDate; productType.Status = status; productType.IsHome = isHome; entities.SaveChanges(); return("ok"); } return("not_exists"); } }
public string DeleteAll(string listId) { using (var entities = new V308CMSEntities()) { var listProductDelete = (from item in entities.Product. Include("ProductImages"). Include("ProductColor"). Include("ProductSize"). Include("ProductAttribute"). Include("ProductSaleOff").AsEnumerable() where listId.Contains(item.ID.ToString()) select item ).ToList(); var productDeleted = ""; if (listProductDelete.Count > 0) { foreach (var product in listProductDelete) { Delete(product.ID); productDeleted = productDeleted + "," + product.ID; } return("ok"); } return("not_exists"); } }
public string Insert( string name, string phone, string manager, string address, DateTime createdAt, DateTime updatedAt, byte state ) { using (var entities = new V308CMSEntities()) { var storeItem = (from store in entities.Store where store.Name == name select store).FirstOrDefault(); if (storeItem == null) { var store = new Store { Name = name, Phone = phone, Manager = manager, Address = address, CreatedAt = createdAt, UpdatedAt = updatedAt, State = state }; entities.Store.Add(store); entities.SaveChanges(); return("ok"); } return("exists"); } }
public string Insert( string name, string code, string description, DateTime createdAt, DateTime updatedAt, byte state ) { using (var entities = new V308CMSEntities()) { var colorItem = (from color in entities.Color where color.Name == name select color).FirstOrDefault(); if (colorItem == null) { var color = new Color { Name = name, Code = code, Description = description, CreatedAt = createdAt, UpdatedAt = updatedAt, State = state }; entities.Color.Add(color); entities.SaveChanges(); return("ok"); } return("exists"); } }
public string Insert(EmailConfig config) { using (var entities = new V308CMSEntities()) { var emailConfig = (from item in entities.EmailConfig where item.Name == config.Name select item ).FirstOrDefault(); if (emailConfig == null) { var newEmailConfig = new EmailConfig { Name = config.Name, Type = config.Type, Host = config.Host, Port = config.Port, UserName = config.UserName, Password = config.UserName, CreatedDate = config.CreatedDate }; entities.EmailConfig.Add(newEmailConfig); entities.SaveChanges(); return("ok"); } return("exists"); } }
public string Insert( string name, DateTime createdAt, DateTime updatedAt, byte state ) { using (var entities = new V308CMSEntities()) { var unitItem = (from unit in entities.Unit where unit.Name == name select unit).FirstOrDefault(); if (unitItem == null) { var unit = new Unit { Name = name, CreatedAt = createdAt, UpdatedAt = updatedAt, State = state }; entities.Unit.Add(unit); entities.SaveChanges(); return("ok"); } return("exists"); } }
public string Insert(string name, string image, string detail, bool status, int order, DateTime createdDate) { using (var entities = new V308CMSEntities()) { var distributorItem = (from distributor in entities.ProductDistributor where distributor.Name == name select distributor).FirstOrDefault(); if (distributorItem == null) { var distributor = new ProductDistributor { Name = name, Image = image, Detail = detail, Status = status, Number = order, Date = createdDate }; entities.ProductDistributor.Add(distributor); entities.SaveChanges(); return("ok"); } return("exists"); } }
public string Update( int id, string name, string image, string detail, bool status, int order, DateTime createdDate) { using (var entities = new V308CMSEntities()) { var distributorItem = (from distributor in entities.ProductDistributor where distributor.ID == id select distributor).FirstOrDefault(); if (distributorItem != null) { distributorItem.Name = name; distributorItem.Image = image; distributorItem.Detail = detail; distributorItem.Status = status; distributorItem.Number = order; distributorItem.Date = createdDate; entities.SaveChanges(); return("ok"); } return("not_exists"); } }
public ActionResult ChuyenBiet() { V308CMSEntities mEntities = new V308CMSEntities(); NewsRepository newsRepository = new NewsRepository(mEntities); TinTucChuyenBiet Str = new TinTucChuyenBiet(); List <News> mKhuyenMai = null; List <News> mCauDo = null; List <News> mSalon = null; List <News> mTamsu = null; try { mKhuyenMai = newsRepository.LayDanhSachTinTheoGroupId(5, 9); mCauDo = newsRepository.LayDanhSachTinTheoGroupId(5, 10); mSalon = newsRepository.LayDanhSachTinTheoGroupId(5, 11); mTamsu = newsRepository.LayDanhSachTinTheoGroupId(5, 12); Str.khuyenmai = V308HTMLHELPER.TaoDanhSachTinCauDo(mKhuyenMai, "Khuyến Mại", 9); Str.caudo = V308HTMLHELPER.TaoDanhSachTinCauDo(mCauDo, "Câu Đố", 10); Str.tamsu = V308HTMLHELPER.TaoDanhSachTinCauDo(mTamsu, "Tâm Sự", 11); Str.salon = V308HTMLHELPER.TaoDanhSachTinCauDo(mSalon, "Salon", 12); return(View(Str)); } catch (Exception ex) { return(Content("<dx></dx>")); } finally { mEntities.Dispose(); newsRepository.Dispose(); } }
public string Update(int id, string name, string phone, string manager, string address, DateTime createdAt, DateTime updatedAt, byte state) { using (var entities = new V308CMSEntities()) { var storeItem = (from store in entities.Store where store.Id == id select store).FirstOrDefault(); if (storeItem != null) { storeItem.Name = name; storeItem.Phone = phone; storeItem.Manager = manager; storeItem.Address = address; storeItem.CreatedAt = createdAt; storeItem.UpdatedAt = updatedAt; storeItem.State = state; entities.SaveChanges(); return("ok"); } return("not_exists"); } }
public ActionResult DanhSachTinLienQuan(int pGroupId, int pNewsId) { V308CMSEntities mEntities = new V308CMSEntities(); NewsRepository newsRepository = new NewsRepository(mEntities); List <News> mList = null; string str = ""; try { //lay danh sach tin lien quan mList = newsRepository.LayDanhSachTinTheoGroupId(6, pGroupId); //tao HTML str = V308HTMLHELPER.TaoDanhSachNhomTinLienQuan(mList, pNewsId); return(View((object)str)); } catch (Exception ex) { return(Content("<dx></dx>")); } finally { mEntities.Dispose(); newsRepository.Dispose(); } }
public News Find(int id) { using (var entities = new V308CMSEntities()) { return(entities.News.FirstOrDefault(news => news.ID == id)); } }
public string ChangeState(int id) { using (var entities = new V308CMSEntities()) { var productTypeItem = ( from item in entities.ProductType.Include("ListProduct") where item.ID == id select item ).FirstOrDefault(); if (productTypeItem != null) { productTypeItem.Status = !productTypeItem.Status; entities.SaveChanges(); if (productTypeItem.ListProduct != null && productTypeItem.ListProduct.Count > 0) { foreach (var product in productTypeItem.ListProduct) { product.Status = productTypeItem.Status; entities.SaveChanges(); } } return("ok"); } return("not_exists"); } }
public string Update(News data) { using (var entities = new V308CMSEntities()) { var newsItem = (from news in entities.News where news.ID == data.ID select news).FirstOrDefault(); if (newsItem != null) { newsItem.Title = data.Title; newsItem.TypeID = data.TypeID; newsItem.Image = data.Image; newsItem.Summary = data.Summary; newsItem.Detail = data.Detail; newsItem.Keyword = data.Keyword; newsItem.Description = data.Description; newsItem.Order = data.Order; newsItem.Hot = data.Hot; newsItem.Fast = data.Fast; newsItem.Featured = data.Featured; newsItem.Status = data.Status; newsItem.Site = data.Site; entities.SaveChanges(); return("ok"); } return("not_exists"); } }
public List <ProductType> GetListByType(int level, int categoryId = 0) { using (var entities = new V308CMSEntities()) { if (level == (int)ProductCategoryLevelEnum.Root) { return((from category in entities.ProductType where category.Parent == 0 orderby category.Date.Value descending select category).ToList()); } if (level == (int)ProductCategoryLevelEnum.Parent || level == (int)ProductCategoryLevelEnum.Child) { if (categoryId > 0) { return((from category in entities.ProductType where category.Parent == categoryId orderby category.Date.Value descending select category).ToList()); } } return(new List <ProductType>()); } }
public ActionResult ProfileUser() { V308CMSEntities mEntities = new V308CMSEntities(); MarketRepository marketRepository = new MarketRepository(mEntities); AccountRepository accountRepository = new AccountRepository(mEntities); HeaderPage mHeaderPage = new HeaderPage(); List <Market> mList; Account mAccount; try { //Check xem dang nhap chưa thi hien thi menu khac // && Session["ShopCart"] != null if (HttpContext.User.Identity.IsAuthenticated == true && Session["UserId"] != null) { //lay thong tin chi tiet user mAccount = accountRepository.LayTinTheoId(Int32.Parse(Session["UserId"].ToString())); mHeaderPage.IsAuthenticated = true; mHeaderPage.Account = mAccount; } return(View(mHeaderPage)); } catch (Exception ex) { return(Content("<dx></dx>")); } finally { mEntities.Dispose(); marketRepository.Dispose(); } }
public JsonResult ThucHienThanhToan(string pFullName, string pEmail, string pMobile, string pAddress, string pAddressDelivery, string pCity, string pDistrict, string pTimeDelivery, string pDayDelivery) { V308CMSEntities mEntities = new V308CMSEntities(); AccountRepository accountRepository = new AccountRepository(mEntities); ShopCart mShopCart; List <Product> mList; ProductOrder mProductOrder = new ProductOrder(); try { if (HttpContext.User.Identity.IsAuthenticated == true && Session["UserId"] != null) { if (Session["ShopCart"] != null) { mShopCart = (ShopCart)Session["ShopCart"]; mList = mShopCart.List; mProductOrder.AccountID = (int)Session["UserId"]; mProductOrder.Address = pAddress + "____" + pAddressDelivery; mProductOrder.Date = DateTime.Now; mProductOrder.Detail = "Đơn mua hàng - Giao ngày:" + pDayDelivery + " - Giờ giao: " + pTimeDelivery; mProductOrder.Email = pEmail; mProductOrder.FullName = pFullName; mProductOrder.Phone = pMobile; mProductOrder.Status = 0; //mProductOrder.ProductDetail = V308HTMLHELPER.TaoDanhSachSanPhamGioHang(mList); mProductOrder.ProductDetail = JsonSerializer.SerializeToString <ShopCart>(mShopCart); mProductOrder.Price = mShopCart.getTotalPrice(); mEntities.AddToProductOrder(mProductOrder); mEntities.SaveChanges(); Session["ShopCart"] = new ShopCart(); //Gửi email báo cho người mua và quản trị về việc mua hàng //gửi email cho khách string EmailContent = "Thông tin đơn hàng của " + pFullName + " từ C-FOOD: <br/> " + V308HTMLHELPER.TaoDanhSachSanPhamGioHang(mList) + " <br/> Email: " + pEmail + "<br/> Mobile: " + pMobile + " <br/> Ngày : " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + ""; //V308Mail.SendMail(pEmail, "Thông tin đơn hàng của " + pFullName + " từ C-FOOD: " + " - " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "", EmailContent); //gửi email tới admin string EmailContent2 = "Thông tin đơn hàng của " + pFullName + " từ C-FOOD: <br/> " + V308HTMLHELPER.TaoDanhSachSanPhamGioHang(mList) + " <br/> Email: " + pEmail + "<br/> Mobile: " + pMobile + " <br/> Ngày : " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + ""; //V308Mail.SendMail("*****@*****.**", "Thông tin đơn hàng của " + pFullName + " từ C-FOOD: " + " - " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "", EmailContent2); return(Json(new { code = 1, message = "Hoàn thành mua bán. Chúng tôi sẽ liên lạc ngay với bạn qua số điện thoại bạn đã cung cấp." })); } else { return(Json(new { code = 3, message = "Giỏ hàng chưa có sản phẩm nào." })); } } else { return(Json(new { code = 2, message = "Vui lòng đăng nhập." })); } } catch (Exception ex) { return(Json(new { code = 0, message = "Có lỗi xảy ra. Vui lòng thử lại." })); } finally { mEntities.Dispose(); accountRepository.Dispose(); } }
public ActionResult HeadMenu() { V308CMSEntities mEntities = new V308CMSEntities(); NewsRepository newsRepository = new NewsRepository(mEntities); List <NewsGroups> mNewsGroupsList; NewsPage mNewsPage = new NewsPage(); try { //lay cac menu của MENU mNewsGroupsList = newsRepository.LayNhomTinAll(); //Tao danh sach cac nhom tin mNewsPage.HtmlNhomTin = V308HTMLHELPER.TaoDanhSachMenu(mNewsGroupsList); return(View(mNewsPage)); } catch (Exception ex) { return(Content("Xảy ra lỗi hệ thống ! Vui lòng thử lại.")); } finally { mEntities.Dispose(); newsRepository.Dispose(); } }
public JsonResult addEmail(string pEmail) { V308CMSEntities mEntities = new V308CMSEntities(); EmailRepository emailRepository = new EmailRepository(mEntities); try { if (ValidateInput.IsValidEmailAddress(pEmail)) { VEmail mVEmail = new VEmail() { CreatedDate = DateTime.Now, State = true, Type = 1, Value = pEmail }; mEntities.AddToVEmail(mVEmail); mEntities.SaveChanges(); return(Json(new { code = 1, message = "Email đã được thêm vào hệ thống." })); } else { return(Json(new { code = 0, message = "Email bạn nhập không chính xác." })); } } catch (Exception ex) { return(Json(new { code = 0, message = "Có lỗi xảy ra. Vui lòng thử lại." })); } finally { mEntities.Dispose(); emailRepository.Dispose(); } }
public ActionResult Footer() { V308CMSEntities mEntities = new V308CMSEntities(); NewsRepository newsRepository = new NewsRepository(mEntities); List <NewsGroups> mNewsGroupsList; List <NewsGroupPage> mNewsGroupPageList = new List <NewsGroupPage>(); try { //lay cac nhom con cua: 14 la nhom cha Footer mNewsGroupsList = newsRepository.getNewsGroupAffterParent(14); foreach (NewsGroups it in mNewsGroupsList) { NewsGroupPage mNewsGroupPage = new NewsGroupPage(); //lay danh sach cac tin ben trong List <News> mList = newsRepository.LayTinTheoGroupId(it.ID); mNewsGroupPage.Name = it.Name; mNewsGroupPage.TypeId = it.ID; mNewsGroupPage.NewsList = mList; mNewsGroupPageList.Add(mNewsGroupPage); } return(View(mNewsGroupPageList)); } catch (Exception ex) { return(Content("Xảy ra lỗi hệ thống ! Vui lòng thử lại.")); } finally { mEntities.Dispose(); newsRepository.Dispose(); } }
public string Update(Account account) { using (var entities = new V308CMSEntities()) { var userUpdate = (from user in entities.Account where user.ID == account.ID select user ).FirstOrDefault(); if (userUpdate != null) { userUpdate.UserName = account.UserName; userUpdate.FullName = account.FullName; userUpdate.Email = account.Email; userUpdate.Address = account.Address; userUpdate.Phone = account.Phone; userUpdate.Gender = account.Gender; userUpdate.Status = account.Status; userUpdate.Avata = account.Avata; userUpdate.Gender = account.Gender; userUpdate.Date = account.Date; return("ok"); } return("not_exists"); } }
public ActionResult SlideSide() { V308CMSEntities mEntities = new V308CMSEntities(); ImagesRepository imagesRepository = new ImagesRepository(mEntities); ImagesPage mImagesPage = new ImagesPage(); Image AnhTrai; Image AnhPhai; StringBuilder mStr = new StringBuilder(); CommonModel mCommonModel = new CommonModel(); try { AnhTrai = imagesRepository.GetImageByTypeId(3, 1).FirstOrDefault(); AnhPhai = imagesRepository.GetImageByTypeId(2, 1).FirstOrDefault(); mImagesPage.Html = AnhTrai.LinkImage; mImagesPage.HtmlNhom = AnhPhai.LinkImage; return(View(mImagesPage)); } catch (Exception ex) { Console.Write(ex); return(Content("<h2>Có lỗi xảy ra trên hệ thống ! Vui lòng thử lại sau.</h2>")); } finally { mEntities.Dispose(); imagesRepository.Dispose(); } }
public override void OnActionExecuting(ActionExecutingContext filterContext) { V308CMSEntities mEntities = new V308CMSEntities(); SiteRepository config = new SiteRepository(mEntities); dynamic ViewBag = filterContext.Controller.ViewBag; ViewBag.linkDomain = System.Configuration.ConfigurationManager.AppSettings["link_domain"]; ViewBag.productLink = System.Configuration.ConfigurationManager.AppSettings["product_link"]; try { ViewBag.domain = Theme.domain; ViewBag.ThemesPath = "/Content/themes/" + Theme.domain; ViewBag.MoneyShort = "vnđ"; ViewBag.SiteName = config.SiteConfig("site-name"); ViewBag.Hotline = config.SiteConfig("hotline"); ViewBag.CompanyFullname = config.SiteConfig("company-fullname"); ViewBag.FooterCompanyContact = config.SiteConfig("company-footer-contact"); ViewBag.CompanyHeaderAddress = config.SiteConfig("company-header-address"); ViewBag.FacebookPage = config.SiteConfig("affiliate-facebook-page"); } catch (Exception ex) { Console.Write(ex); } finally { mEntities.Dispose(); config.Dispose(); } }
public ActionResult MarketList(int ptype = 0) { V308CMSEntities mEntities = new V308CMSEntities(); MarketRepository marketRepository = new MarketRepository(mEntities); List <Market> mList = new List <Market>(); try { //lay danh sach nhom tin mList = marketRepository.getMarketByType(100, ptype); ViewBag.MkType = ptype; //lay danh sach cac tin theo nhom return(View(mList)); } catch (Exception ex) { Console.WriteLine("error :", ex); return(Content("<dx></dx>")); } finally { mEntities.Dispose(); marketRepository.Dispose(); } }