/// <summary> /// Gets the list image album. /// </summary> /// <param name="albumId">The album identifier.</param> /// <returns>list image album</returns> public ActionResult GetListImageAlbum(int albumId) { GalleryModels sv = new GalleryModels(); List <ImageAlbum> list = new List <ImageAlbum>(); List <ImageSlideObject> objs = new List <ImageSlideObject>(); if (albumId > 0) { list = sv.GetListImagebyCategory(albumId); if (list.Count > 0) { foreach (var it in list) { ImageSlideObject ia = new ImageSlideObject(); ia.url = it.ImagesFull; ia.caption = it.ImagesName; objs.Add(ia); } } } else { } var jsonSerialiser = new JavaScriptSerializer(); var json = jsonSerialiser.Serialize(objs); var results = json; return(this.Json(results)); }
public int update(GalleryModels item) { int rs = 0; StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("UPDATE "); sqlBuilder.Append("gov_gallery "); sqlBuilder.Append("SET "); sqlBuilder.Append("title = @2, "); sqlBuilder.Append("total_view = @3, "); sqlBuilder.Append("avatar = @4, "); sqlBuilder.Append("attach_filepath = @5, "); sqlBuilder.Append("update_username = @6, "); sqlBuilder.Append("update_datetime = @7 "); sqlBuilder.Append("WHERE "); sqlBuilder.Append("id=@8"); this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); objCmd.Parameters.AddWithValue("@2", item.Title); objCmd.Parameters.AddWithValue("@3", item.TotalView); objCmd.Parameters.AddWithValue("@4", item.Avatar); objCmd.Parameters.AddWithValue("@5", item.AttachFilepath); objCmd.Parameters.AddWithValue("@6", item.UpdateUsername); objCmd.Parameters.AddWithValue("@7", item.UpdateDatetime); objCmd.Parameters.AddWithValue("@8", item.Id); rs = objCmd.ExecuteNonQuery(); return rs; }
public int insert(GalleryModels item) { int rs = 0; StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("INSERT "); sqlBuilder.Append("INTO "); sqlBuilder.Append("gov_gallery "); sqlBuilder.Append("( "); sqlBuilder.Append("title, "); sqlBuilder.Append("total_view, "); sqlBuilder.Append("avatar, "); sqlBuilder.Append("attach_filepath, "); sqlBuilder.Append("update_username, "); sqlBuilder.Append("update_datetime"); sqlBuilder.Append(") "); sqlBuilder.Append("values("); sqlBuilder.Append("@2, @3, @4, @5, @6, @7"); sqlBuilder.Append(")"); this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); objCmd.Parameters.AddWithValue("@2", item.Title); objCmd.Parameters.AddWithValue("@3", item.TotalView); objCmd.Parameters.AddWithValue("@4", item.Avatar); objCmd.Parameters.AddWithValue("@5", item.AttachFilepath); objCmd.Parameters.AddWithValue("@6", item.UpdateUsername); objCmd.Parameters.AddWithValue("@7", item.UpdateDatetime); rs = objCmd.ExecuteNonQuery(); return rs; }
/// <summary> /// Posts the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <param name="cate_id">The cate identifier.</param> /// <param name="cate_type">Type of the cate.</param> /// <returns>Posts the specified</returns> public ActionResult LookbookDetail(int?id, string cate_type) { /////lookbook detail GalleryModels sv = new GalleryModels(); CatalogModels cateModels = new CatalogModels(); C_Catalog cateItem = new C_Catalog(); id = RouteData.Values["id"] != null?Convert.ToInt16(RouteData.Values["id"].ToString()) : 0; var link = RouteData.Values["Link"] != null ? RouteData.Values["Link"].ToString() : string.Empty; if (string.IsNullOrEmpty(cate_type)) { cate_type = CommonGlobal.CateGallery; } if (id == 0) { return(this.HttpNotFound()); } else { cateItem = cateModels.GetbyID((int)id); if (cateItem.CatalogID == 0) { return(this.HttpNotFound()); } ViewBag.Title = cateItem.CategoryName + " | " + GeneralModels.GetContent(CommonGlobal.PageName, this.Lang); ////breadcrumbs string strbreadcrumbs = string.Empty; strbreadcrumbs = string.Format("<li><a href=\"" + Url.Action("lookbook", "gallery") + "\">" + App_GlobalResources.Lang.mnuGallery + "</a></li>"); if (cateItem != null) { strbreadcrumbs += string.Format("<li><a href=\"" + Url.RouteUrl("_lookbook", new { controller = "gallery", action = "LookbookDetail", id = id, Link = cateItem.Link != null ? cateItem.Link : string.Empty, cate_type = cate_type }) + "\">" + cateItem.CategoryName + "</a></li>"); ViewBag.cate_name = cateItem.CategoryName; } strbreadcrumbs += string.Format("<li>" + cateItem.CategoryName + "</li>"); ViewBag.str_breadcrumbs = strbreadcrumbs; ViewBag.back_link = Url.RouteUrl("_lookbook", new { controller = "gallery", action = "LookbookDetail", id = id, Link = cateItem.Link != null ? cateItem.Link : string.Empty, cate_type = cate_type }); ViewBag.heading = cateItem.CategoryName; this.AddMeta(CommonGlobal.Keyword, cateItem.CategoryName); this.AddMeta(CommonGlobal.Description, this.ClearHtml(HttpUtility.HtmlDecode(cateItem.Description))); ViewBag.id = id; ViewBag.cate_id = id; ViewBag.cate_type = cate_type; ViewBag.ImagePath = cateItem.ImagePath; ViewBag.MoreInfo = cateItem.MoreInfo; return(this.PartialView("../page/lookbookDetail")); } }
public ActionResult IndexGallery(int?page, int TypeId = 0) { int defautPagesize = 10; int total = 0; int currentPageIndex = page.HasValue ? page.Value - 1 : 0; IGalleryService gallerySrv = IoC.Resolve <IGalleryService>(); GalleryModels model = new GalleryModels(); model.GalleryTypes = galleryTypeSrv.Query.OrderBy(p => p.TitleVNI).ToList(); model.TypeID = TypeId == 0 ? model.GalleryTypes.FirstOrDefault().Id : TypeId; var lst = gallerySrv.GetbyType(TypeId, currentPageIndex, defautPagesize, out total); model.Galleries = new PagedList <Gallery>(lst, currentPageIndex, defautPagesize, total); return(View(model)); }
public List<GalleryModels> select(int page, int limit) { int offset = (page - 1) * limit; StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("SELECT "); sqlBuilder.Append("* "); sqlBuilder.Append("FROM "); sqlBuilder.Append("gov_gallery gglr "); sqlBuilder.Append(getBaseSQL()); if (page > 0 && limit > 0) { sqlBuilder.Append(" LIMIT @limit "); sqlBuilder.Append(" OFFSET @offset "); } this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); if (page > 0 && limit > 0) { objCmd.Parameters.AddWithValue("@limit", limit); objCmd.Parameters.AddWithValue("@offset", offset); } MySqlDataReader dataReader = objCmd.ExecuteReader(); List<GalleryModels> lstMenu = new List<GalleryModels>(); GalleryModels item; while (dataReader.Read()) { item = new GalleryModels(); item.Id = Convert.ToInt32(dataReader["id"]); item.Title = dataReader["title"].ToString(); item.TotalView = Convert.ToInt32(dataReader["total_view"]); item.Avatar = dataReader["avatar"].ToString(); item.AttachFilepath = dataReader["attach_filepath"].ToString(); item.UpdateUsername = dataReader["update_username"].ToString(); item.UpdateDatetime = Convert.ToDateTime(dataReader["update_datetime"]); lstMenu.Add(item); } getConnection().Close(); return lstMenu; }
public ActionResult List_album_images(FormCollection collection) { CatalogModels cateModels = new CatalogModels(); GalleryModels galleryModels = new GalleryModels(); C_Catalog cate = new C_Catalog(); ImageAlbum imgPro = new ImageAlbum(); StringBuilder sb = new StringBuilder(); List <SelectListItem> list_select_catalog = new List <SelectListItem>(); var list_album_images_view = new Web.Areas.Admin.ViewModels.List_album_images_view(); this.TryUpdateModel(list_album_images_view); int total_record = 0; int level = 0; bool rt = true; bool is_valid = true; list_album_images_view.Cate_type = CommonGlobal.GetCatalogTypeName(list_album_images_view.Type); ////tab sb.Append("<li class=\"active\"><a class=\"active\" href=\"" + Url.Action("index", "dashboard", new { act = "list_catalog", ctrl = "adminCatalog", type = list_album_images_view.Type, page = "1", parent = list_album_images_view.Parent }) + "\"><span><span>Danh sách " + CommonGlobal.GetCatalogTypeName(list_album_images_view.Type) + "</span></span></a></li>"); list_album_images_view.Html_link_tab = sb.ToString(); ////list page size and paging list_album_images_view.List_page_size = this.GetSizePagingPublic(list_album_images_view.Page_size); ////acton and parent action list_album_images_view.Act = "list_album_images"; list_album_images_view.Ctrl = "adminLink"; list_album_images_view.Parent_action = HttpContext.Request.RequestContext.RouteData.Values["action"].ToString(); list_album_images_view.Parent_controller = HttpContext.Request.RequestContext.RouteData.Values["controller"].ToString(); ////delete image if (list_album_images_view.Id > 0 && list_album_images_view.Type_act == CommonGlobal.Delete) { ////check permission delete if (UserModels.CheckPermission(this.Session["mem"] != null ? this.Session["mem"].ToString() : string.Empty, list_album_images_view.Act, list_album_images_view.Ctrl, list_album_images_view.Type_act, list_album_images_view.Type)) { imgPro = galleryModels.GetImageById(list_album_images_view.Id); if (imgPro != null) { ////delete old image if (!string.IsNullOrEmpty(imgPro.Images)) { string strImg = imgPro.Images; strImg = "~" + strImg; string fileDelete = Server.MapPath(strImg); if (System.IO.File.Exists(fileDelete)) { System.IO.File.Delete(fileDelete); } string fileDelete2 = Server.MapPath(strImg.Replace("sc_small_", "sc_full_")); if (System.IO.File.Exists(fileDelete2)) { System.IO.File.Delete(fileDelete2); } } ////delete image product rt = galleryModels.Delete_Images(list_album_images_view.Id); if (rt) { list_album_images_view.Message = "Bạn đã xóa ảnh " + list_album_images_view.Id; } else { list_album_images_view.Message = "Xóa không thành công"; } } else { list_album_images_view.Message = "Không tìm thấy ảnh : " + list_album_images_view.Id; } } else { list_album_images_view.Message = " Bạn không có quyền thực thi hành động xóa."; } } else { if (list_album_images_view.Type_act == CommonGlobal.Add) { ////check permission add if (UserModels.CheckPermission(this.Session["mem"] != null ? this.Session["mem"].ToString() : string.Empty, list_album_images_view.Act, list_album_images_view.Ctrl, list_album_images_view.Type_act, list_album_images_view.Type)) { ////validation server if (list_album_images_view.Album == 0) { is_valid = false; list_album_images_view.Message = "Bạn cần lựa chọn album"; } if (list_album_images_view.File_image == null) { is_valid = false; list_album_images_view.Message = "Bạn cần chọn ảnh"; } var max_length = 1024 * 1024 * 10; ////10MB var length_all = 0; foreach (HttpPostedFileBase fi in list_album_images_view.File_image) { if (fi != null) { length_all = length_all + fi.ContentLength; } } if (length_all == 0) { is_valid = false; } if (length_all > max_length) { is_valid = false; list_album_images_view.Message = "Bạn đã không thể đăng quá nhiều ảnh (Tổng dung lượng tối đa 10MB)"; } if (is_valid) { ////upload multi images foreach (HttpPostedFileBase fi in list_album_images_view.File_image) { if (fi != null && fi.ContentLength > 0 && CommonGlobal.IsImage(fi) == true) { ////add new image var imgPathTemp = "images/photogallery/" + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/"; var name_time = DateTime.Now.Day + DateTime.Now.Month + DateTime.Now.Year + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Ticks + string.Empty; imgPro = new ImageAlbum(); string image_small = imgPathTemp + "sc_small_" + name_time + "_" + CommonGlobal.CompleteNamefileImages(fi.FileName); string image_lager = imgPathTemp + "sc_full_" + name_time + "_" + CommonGlobal.CompleteNamefileImages(fi.FileName); //////save images for multi file this.Savephoto(null, fi, imgPathTemp, image_small, image_lager); imgPro.Images = "/" + image_small; imgPro.ImagesFull = "/" + image_lager; imgPro.CatalogID = list_album_images_view.Album; list_album_images_view.ImagePath = "/" + image_small; rt = galleryModels.Add_Images(imgPro); if (rt) { list_album_images_view.Message = "Bạn đã thêm ảnh thành công!"; } else { if (list_album_images_view.Message != string.Empty) { list_album_images_view.Message = "updload ảnh không thành công: " + CommonGlobal.CompleteNamefileImages(fi.FileName); } else { list_album_images_view.Message += "; " + CommonGlobal.CompleteNamefileImages(fi.FileName); } } list_album_images_view.File_image = null; } } } } else { list_album_images_view.Message = " Bạn không có quyền thực thi thêm ảnh cho album "; } } else { list_album_images_view.Message = string.Empty; } } ////list language list_album_images_view.List_language = this.List_select_language(list_album_images_view.Lang); ////list category cateModels.List_catalog_parent(0, level, list_album_images_view.Parent, list_album_images_view.Type, list_album_images_view.Lang, ref list_select_catalog); list_album_images_view.List_parent = list_select_catalog; ////get list product list_album_images_view.Page_list_image = galleryModels.AdminGetAllImageGallery(list_album_images_view.Parent, list_album_images_view.Type, list_album_images_view.Lang, list_album_images_view.Page, list_album_images_view.Page_size, list_album_images_view.Order_by, list_album_images_view.Order_type, out total_record); list_album_images_view.Total_record = total_record; list_album_images_view.Order_by = list_album_images_view.Order_by; list_album_images_view.Order_type = list_album_images_view.Order_type; return(this.PartialView("../control/list_album_images", list_album_images_view)); }
public ActionResult List_album_images(int?parent, int?id, string type, string act, string ctrl, string type_act, string lang, string search, int?page, int?page_size, string order_by, string order_type) { CatalogModels cateModels = new CatalogModels(); GalleryModels galleryModels = new GalleryModels(); C_Catalog cate = new C_Catalog(); ImageAlbum img = new ImageAlbum(); StringBuilder sb = new StringBuilder(); List <SelectListItem> list_select_catalog = new List <SelectListItem>(); var list_album_images_view = new Web.Areas.Admin.ViewModels.List_album_images_view(); int total_record = 0; int level = 0; /////type is get type catalog /////ex : LB - Lookbook ///// : GL - Gallery /////parent is array parent id if (string.IsNullOrEmpty(type)) { type = Request.QueryString["type"] != null ? Request.QueryString["type"].ToString() : CommonGlobal.CateLookBook; } if (string.IsNullOrEmpty(act)) { act = Request.QueryString["act"] != null ? Request.QueryString["act"].ToString() : "list_album_images"; } if (string.IsNullOrEmpty(ctrl)) { ctrl = Request.QueryString["ctrl"] != null ? Request.QueryString["ctrl"].ToString() : "adminLink"; } if (page == null || page == 0) { page = Request.QueryString["page"] != null?Convert.ToInt32(Request.QueryString["page"].ToString()) : 1; } if (page_size == null) { page_size = int.Parse(Util.GetConfigValue("NumberPageSizeAdmin", "30")); } if (parent == null) { parent = Request.QueryString["parent"] != null?Convert.ToInt32(Request.QueryString["parent"].ToString()) : 0; } if (string.IsNullOrEmpty(lang)) { lang = LanguageModels.ActiveLanguage().LangCultureName; } if (id != null && type_act != null && type_act == CommonGlobal.Delete) { ////check permission delete if (UserModels.CheckPermission(this.Session["mem"] != null ? this.Session["mem"].ToString() : string.Empty, act, ctrl, type_act, type)) { img = galleryModels.GetImageById((int)id); if (img != null) { ////delete old image if (!string.IsNullOrEmpty(img.Images)) { string strImg = img.Images; strImg = "~" + strImg; string fileDelete = Server.MapPath(strImg); if (System.IO.File.Exists(fileDelete)) { System.IO.File.Delete(fileDelete); } string fileDelete2 = Server.MapPath(strImg.Replace("sc_small_", "sc_full_")); if (System.IO.File.Exists(fileDelete2)) { System.IO.File.Delete(fileDelete2); } } ////delete imgage album bool rt = galleryModels.Delete_Images((int)id); if (rt) { list_album_images_view.Message = "Bạn đã xóa ảnh " + id; } else { list_album_images_view.Message = "Xóa không thành công"; } } else { list_album_images_view.Message = "Không tìm thấy ảnh : " + id; } } else { list_album_images_view.Message = " Bạn không có quyền thực thi hành động xóa."; } } if (string.IsNullOrEmpty(order_by) || string.IsNullOrEmpty(order_type)) { order_by = "ID"; order_type = "asc"; } if (parent != 0) { cate = cateModels.GetbyID((int)parent); list_album_images_view.Category_name = cate.CategoryName; } list_album_images_view.Type = type; list_album_images_view.Cate_type = CommonGlobal.GetCatalogTypeName(type); list_album_images_view.Parent = (int)parent; list_album_images_view.Lang = lang; list_album_images_view.Type_act = type_act; ////tab sb.Append("<li class=\"active\"><a class=\"active\" href=\"" + Url.Action("index", "dashboard", new { act = "list_catalog", ctrl = "adminCatalog", type = type, page = "1", parent = parent }) + "\"><span><span>Danh sách " + CommonGlobal.GetCatalogTypeName(type) + "</span></span></a></li>"); list_album_images_view.Html_link_tab = sb.ToString(); ////list language list_album_images_view.List_language = this.List_select_language(this.Lang); ////list category for filter cateModels.List_catalog_parent(0, level, (int)parent, type, lang, ref list_select_catalog); list_album_images_view.List_parent = list_select_catalog; ////list page size and paging list_album_images_view.List_page_size = this.GetSizePagingPublic((int)page_size); list_album_images_view.Page = (int)page; list_album_images_view.Page_size = (int)page_size; ////list product list_album_images_view.Page_list_image = galleryModels.AdminGetAllImageGallery((int)parent, type, lang, (int)page, (int)page_size, order_by, order_type, out total_record); list_album_images_view.Order_by = order_by; list_album_images_view.Order_type = order_type; list_album_images_view.Total_record = total_record; ////acton and parent action list_album_images_view.Act = act; list_album_images_view.Ctrl = ctrl; list_album_images_view.Parent_action = HttpContext.Request.RequestContext.RouteData.Values["action"].ToString(); list_album_images_view.Parent_controller = HttpContext.Request.RequestContext.RouteData.Values["controller"].ToString(); return(this.PartialView("../control/list_album_images", list_album_images_view)); }