public SliderDS.SlidesRow GetSlide(int Id) { DataView dv = GetSlides(string.Format("Id = {0}", Id)); SliderDS.SlidesRow row = (SliderDS.SlidesRow)dv[0].Row; return(row); }
/* Start Slider */ public DataRow AddSlide(string title, string description, int orderNbr, string imageUrl) { SliderDS.SlidesRow row = DS.Slides.NewSlidesRow(); row.Title = title; row.Description = description; row.OrderNbr = orderNbr; row.ImageUrl = imageUrl; ds.Slides.Rows.Add(row); AcceptChanges(); return(row); }
public bool DeleteSlide(int Id) { DataView dv = this.GetSlides(string.Format("Id = {0}", Id)); if (dv.Count <= 0) { return(false); } SliderDS.SlidesRow row = (SliderDS.SlidesRow)dv[0].Row; row.Delete(); AcceptChanges(); return(true); }
public bool UpdateSlide(int Id, string title, string description, int orderNbr, string imageUrl) { DataView dv = this.GetSlides(string.Format("Id = {0}", Id)); if (dv.Count <= 0) { return(false); } SliderDS.SlidesRow row = (SliderDS.SlidesRow)dv[0].Row; row.Title = title; row.Description = description; row.OrderNbr = orderNbr; row.ImageUrl = imageUrl; row.Table.AcceptChanges(); AcceptChanges(); return(true); }
//some comments /// <summary> /// Updates the existing slide /// </summary> /// <param name="Id">Id of the current slide</param> /// <param name="title">Title of the slide</param> /// <param name="description">Description of the slide</param> /// <param name="orderNbr">The order number of the current slide</param> /// <param name="imageUrl">The name of the newly uploaded image</param> /// <param name="ImageFile">The request file comming form the form</param> /// <param name="OriginalImagePath">The server mapped path of the existing image</param> /// <param name="URL">A URL to be used if needed (links)</param> /// <returns>False if not found and true if updated</returns> public bool UpdateSlide(int Id, string title, string description, int orderNbr, string imageUrl, HttpPostedFile ImageFile, string OriginalImagePath, string URL) { DataView dv = this.GetSlides(string.Format("Id = {0}", Id)); if (dv.Count <= 0) { return(false); } //if file input holds image file if (ImageFile != null) { if (OriginalImagePath != null && File.Exists(OriginalImagePath)) { File.Delete(OriginalImagePath); } string imagePath = WebContext.Server.MapPath("~/images/slides/" + imageUrl + ".jpg"); ImageFile.SaveAs(imagePath); } else { FileInfo fi = new FileInfo(OriginalImagePath); fi.MoveTo(WebContext.Server.MapPath("~/images/slides/" + imageUrl + ".jpg")); } SliderDS.SlidesRow row = (SliderDS.SlidesRow)dv[0].Row; row.Title = title != null ? title : row.Title; row.Description = description != null ? description : row.Description;; row.OrderNbr = orderNbr != -1 ? orderNbr : row.OrderNbr; row.ImageUrl = imageUrl != null ? imageUrl : row.ImageUrl; row.URL = URL != null ? URL : ""; row.Table.AcceptChanges(); AcceptChanges(); return(true); }
/* Start Slider */ /// <summary> /// Adds a new slide /// </summary> /// <param name="Title">Title of the new slide that will also be used to rename the image</param> /// <param name="Description">Description of the slide</param> /// <param name="OrderNbr">The Order Number of the slide</param> /// <param name="ImageFile">The image file to be added for the slide</param> /// <param name="URL">A URL to be used if needed (links)</param> /// <returns>DataRow, the created slide as a row</returns> public DataRow AddSlide(string Title, string Description, int OrderNbr, HttpPostedFile ImageFile, string URL) { SliderDS.SlidesRow row = DS.Slides.NewSlidesRow(); row.Title = Title; row.Description = Description; row.OrderNbr = OrderNbr; row.URL = URL; ds.Slides.Rows.Add(row); AcceptChanges(); string fileName = StringUtils.ToURL(Title) + "-" + row.Id; string imagePath = WebContext.Server.MapPath("~/images/slides/" + fileName + ".jpg"); ImageFile.SaveAs(imagePath); row.ImageUrl = fileName; AcceptChanges(); return(row); }
/// <summary> /// Deletes the existing slide based on it's unique ID /// </summary> /// <param name="Id">Id of the slide to be deleted</param> /// <returns>If slide not found it returns false else true</returns> public bool DeleteSlide(int Id) { DataView dv = this.GetSlides(string.Format("Id = {0}", Id)); if (dv.Count <= 0) { return(false); } SliderDS.SlidesRow row = (SliderDS.SlidesRow)dv[0].Row; row.Delete(); AcceptChanges(); string path = WebContext.Server.MapPath("~/" + lw.CTE.Folders.MainSliderFolder); string ImageName = string.Format("{0}\\{1}", path, Id + ".jpg"); if (File.Exists(ImageName)) { File.Delete(ImageName); } return(true); }