public void LoadRandomBanner() { var svArticle = new ArticleService(); var sqlWhere = "IsDelete = 0 AND IsShow = 1 AND WebID = 1"; var data = new List <b2bBanner>(); var Banner = new b2bBanner(); if (MemoryCache.Default["BannerHome"] != null) { data = (List <b2bBanner>)MemoryCache.Default["BannerHome"]; var rand = new Random(); Banner = data[rand.Next(data.Count)]; } else { data = svArticle.SelectData <b2bBanner>("*", sqlWhere, "ListNo ASC", 1, 10); if (data != null && svArticle.TotalRow > 0) { MemoryCache.Default.Add("BannerHome", data, DateTime.Now.AddMinutes(10)); var rand = new Random(); Banner = data[rand.Next(data.Count)]; } ; } ViewBag.Banner = data; }
public ActionResult ChangeListNoBanner(List <int> id) { if (!CheckIsLogin()) { return(Redirect(res.Pageviews.PvMemberSignIn)); } var svBanner = new BannerService(); var banner = new b2bBanner(); try { List <int> list = new List <int>(); var id_banner1 = id[1]; var id_banner2 = id[0]; banner = svBanner.SelectData <b2bBanner>("*", " BannerID = " + id_banner1 + " AND WebID = 1").First(); list.Add(banner.ListNo); banner = svBanner.SelectData <b2bBanner>("*", " BannerID = " + id_banner2 + " AND WebID = 1").First(); list.Add(banner.ListNo); svBanner.UpdateBannerListNo(id, list); } catch (Exception ex) { CreateLogFiles(ex); } return(Json(new { IsResult = svBanner.IsResult, MsgError = GenerateMsgError(svBanner.MsgError), ID = id })); }
public ActionResult EditBanner(string BannerId) { var svBanner = new BannerService(); var banner = new b2bBanner(); List <b2bBanner> bannerAll = new List <b2bBanner>(); RememberURL(); if (!CheckIsLogin()) { return(Redirect(res.Pageviews.PvMemberSignIn)); } else { GetStatusUser(); SetPager(); banner = svBanner.SelectData <b2bBanner>(" * ", "IsDelete = 0 AND WebID = 1 And BannerID =" + BannerId).First(); bannerAll = svBanner.SelectData <b2bBanner>("BannerID, ListNo", "ListNo != 0 AND WebID = 1"); ViewBag.Count = bannerAll.Count(); ViewBag.data = banner; } return(View()); }
public ActionResult DelData(List <bool> Check, List <int> ID, List <short> RowVersion, string PrimaryKeyName) { BannerService svBanner = new BannerService(); var banner = new b2bBanner(); List <b2bBanner> bannerAll = new List <b2bBanner>(); List <int> listID = new List <int>(); List <int> listListNo = new List <int>(); if (PrimaryKeyName == "BannerId") { if (Check.Count() == 1) { banner = svBanner.SelectData <b2bBanner>("BannerID, ListNo", " BannerID = " + ID[0] + " AND WebID = 1").First(); try { svBanner.DelData <b2bBanner>(Check, ID, RowVersion, PrimaryKeyName); } catch (Exception ex) { CreateLogFiles(ex); } bannerAll = svBanner.SelectData <b2bBanner>("BannerID, ListNo", "ListNo > " + banner.ListNo + " AND WebID = 1"); for (var i = 0; i < bannerAll.Count(); i++) { listID.Add(bannerAll[i].BannerID); listListNo.Add(bannerAll[i].ListNo - 1); } svBanner.UpdateBannerListNo(listID, listListNo); } else { //for (var a = 0; a < Check.Count(); a++) //{ var num = 1; for (var i = 0; i < ID.Count(); i++) { if (Check[i] == true) { BannerService svBanner1 = new BannerService(); banner = svBanner1.SelectData <b2bBanner>("BannerID, ListNo", " BannerID = " + ID[i] + " AND WebID = 1").First(); svBanner.UpdateByCondition <b2bBanner>("ListNo = 0 , IsDelete = 1", "BannerID = " + ID[i]); //svBanner.DelData<b2bBanner>(Check, ID, RowVersion, PrimaryKeyName); bannerAll = svBanner.SelectData <b2bBanner>("BannerID, ListNo", "ListNo > " + banner.ListNo + " AND WebID = 1"); for (var j = 0; j < bannerAll.Count(); j++) { listID.Add(bannerAll[j].BannerID); listListNo.Add(bannerAll[j].ListNo - num); } svBanner.UpdateBannerListNo(listID, listListNo); listID.Clear(); listListNo.Clear(); num++; } } //break; //} } } if (svBanner.IsResult) { return(Json(new { Result = true })); } else { return(Json(new { Result = false })); } }
public ActionResult EditBanner(FormCollection form) { var svBanner = new BannerService(); var banner = new b2bBanner(); List <b2bBanner> bannerAll = new List <b2bBanner>(); List <int> listID = new List <int>(); List <int> listListNo = new List <int>(); int listnoNew = Convert.ToInt32(form["ListNo"]); banner = svBanner.SelectData <b2bBanner>("BannerID, ListNo,BannerImgPath", " BannerID = " + form["BannerID"] + " AND WebID = 1").First(); if (banner.ListNo > listnoNew) { bannerAll = svBanner.SelectData <b2bBanner>("BannerID, ListNo", "ListNo BETWEEN " + listnoNew + " AND " + (banner.ListNo - 1) + " AND WebID = 1"); for (var i = 0; i < bannerAll.Count(); i++) { listID.Add(bannerAll[i].BannerID); listListNo.Add(bannerAll[i].ListNo + 1); } svBanner.UpdateBannerListNo(listID, listListNo); } else { bannerAll = svBanner.SelectData <b2bBanner>("BannerID, ListNo", "ListNo BETWEEN " + (banner.ListNo + 1) + " AND " + listnoNew + " AND WebID = 1"); for (var i = 0; i < bannerAll.Count(); i++) { listID.Add(bannerAll[i].BannerID); listListNo.Add(bannerAll[i].ListNo - 1); } svBanner.UpdateBannerListNo(listID, listListNo); } var sqlUpdate = ""; var RowVersion = DataManager.ConvertToShort(Convert.ToInt32(form["RowVersion"]) + 1); sqlUpdate = "BannerTitle = N'" + form["Title"] + "' , BannerLink = N'" + form["Link"] + "' , IsShow = " + form["isShow"] + ", ListNo = " + Convert.ToInt32(form["ListNo"]) + ", ModifiedDate = '" + DateTime.Now + "' , ModifiedBy = '" + LogonCompName + "' , RowVersion = " + RowVersion; if (banner.BannerImgPath != form["ImgPath"]) { sqlUpdate += ", BannerImgPath = '" + form["ImgPath"] + "'"; } try{ svBanner.UpdateByCondition <b2bBanner>(sqlUpdate, " BannerID = " + banner.BannerID); } catch (Exception ex) { CreateLogFiles(ex); } /* New Img */ if (svBanner.IsResult == true) { if (!string.IsNullOrEmpty(form["ImgPath"])) { if (banner.BannerImgPath != form["ImgPath"]) { imgManager = new FileHelper(); imgManager.DirPath = "Banner/H1/" + banner.BannerID; imgManager.DirTempPath = "Temp/Banner/" + "BannerHome"; imgManager.ImageName = form["ImgPath"]; imgManager.FullHeight = 0; imgManager.FullWidth = 0; imgManager.ThumbHeight = 150; imgManager.ThumbWidth = 150; imgManager.SaveImageFromTemp(); } } } return(Redirect("~/Admin/Banner")); }
public ActionResult AddBanner(FormCollection form) { var svBanner = new BannerService(); var banner = new b2bBanner(); var BannerImgPath = banner.BannerImgPath; List <b2bBanner> bannerAll = new List <b2bBanner>(); List <int> listID = new List <int>(); List <int> listListNo = new List <int>(); int listnoNew = Convert.ToInt32(form["ListNo"]); var count = svBanner.SelectData <b2bBanner>(" * ", " CreatedDate = GetDate() AND RowFlag > 0 AND WebID = 1"); int Count = count.Count + 1; string Code = AutoGenCode("B", Count); bannerAll = svBanner.SelectData <b2bBanner>("BannerID, ListNo", "ListNo >= " + listnoNew + " AND WebID = 1"); if (bannerAll.Count() != 0) { for (var i = 0; i < bannerAll.Count(); i++) { listID.Add(bannerAll[i].BannerID); listListNo.Add(bannerAll[i].ListNo + 1); } svBanner.UpdateBannerListNo(listID, listListNo); } var IsShow = false; if (form["isShow"] == "1") { IsShow = true; } else { IsShow = false; } banner.BannerCode = Code; banner.BannerTitle = form["Title"]; banner.BannerLink = form["Link"]; banner.BannerImgPath = form["ImgPath"]; banner.WebID = 1; banner.PagePosition = "H1"; banner.IsShow = IsShow; banner.ListNo = Convert.ToInt32(form["ListNo"]); banner.Rowflag = "1"; banner.CreatedDate = DateTime.Now; banner.CreatedBy = LogonCompName; banner.IsDelete = false; banner.ModifiedDate = DateTime.Now; banner.ModifiedBy = LogonCompName; banner.RowVersion = 1; #region Save b2bBanner svBanner.SaveData <b2bBanner>(banner, "BannerID"); #endregion #region SaveBannerImg if (svBanner.IsResult && svBanner.IsResult) { if (!string.IsNullOrEmpty(form["ImgPath"])) { if (banner.BannerImgPath != BannerImgPath) { imgManager = new FileHelper(); imgManager.DirPath = "Banner/H1/" + banner.BannerID; imgManager.DirTempPath = "Temp/Banner/" + "BannerHome"; imgManager.ImageName = form["ImgPath"]; imgManager.FullHeight = 0; imgManager.FullWidth = 0; imgManager.ThumbHeight = 150; imgManager.ThumbWidth = 150; imgManager.SaveImageFromTemp(); } } } #endregion return(Redirect("~/Admin/Banner")); }