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();
}
}
