public void Save() { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { tblGallery gal = (from c in db.tblGalleries where c.GalleryID == this.GalleryID select c).FirstOrDefault(); if (gal == null || this.GalleryID == Guid.Empty) { gal = new tblGallery(); gal.SiteID = this.SiteID; gal.GalleryID = Guid.NewGuid(); } gal.GalleryTitle = this.GalleryTitle; if (gal.GalleryID != this.GalleryID) { db.tblGalleries.InsertOnSubmit(gal); } db.SubmitChanges(); this.GalleryID = gal.GalleryID; } }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { gTheID = new Guid(Request.QueryString["id"].ToString()); } GalleryFancyBox1.GalleryID = gTheID; GalleryFancyBox1.ShowHeading = true; GalleryFancyBox1.ScaleImage = true; GalleryFancyBox1.ThumbSize = 100; GalleryFancyBox1.SiteID = SiteData.CurrentSiteID; if (gTheID != Guid.Empty) { GalleryFancyBox2.ShowHeading = true; GalleryFancyBox2.ScaleImage = true; GalleryFancyBox2.ThumbSize = 50; GalleryFancyBox2.SiteID = SiteData.CurrentSiteID; using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { GalleryFancyBox2.GalleryIDs = (from c in db.tblGalleries where c.SiteID == SiteData.CurrentSiteID select c.GalleryID).ToList(); } } }
public void Save() { if (!string.IsNullOrEmpty(this.GalleryImage)) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { tblGalleryImageMeta gal = (from c in db.tblGalleryImageMetas where c.GalleryImage.ToLower() == this.GalleryImage.ToLower() select c).FirstOrDefault(); if (gal == null || this.GalleryImageMetaID == Guid.Empty) { gal = new tblGalleryImageMeta(); gal.SiteID = this.SiteID; gal.GalleryImageMetaID = Guid.NewGuid(); gal.GalleryImage = this.GalleryImage; } gal.ImageTitle = this.ImageTitle; gal.ImageMetaData = this.ImageMetaData; if (gal.GalleryImageMetaID != this.GalleryImageMetaID) { db.tblGalleryImageMetas.InsertOnSubmit(gal); } db.SubmitChanges(); this.GalleryImageMetaID = gal.GalleryImageMetaID; } } }
public List <GalleryImageEntry> GalleryImageEntryListGetByGalleryID(Guid galleryID) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { List <GalleryImageEntry> ge = (from c in db.tblGalleryImages where c.GalleryID == galleryID select new GalleryImageEntry(c)).ToList(); return(ge); } }
public GalleryImageEntry GalleryImageEntryGetByID(Guid galleryImageID) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { GalleryImageEntry ge = (from c in db.tblGalleryImages where c.GalleryImageID == galleryImageID select new GalleryImageEntry(c)).FirstOrDefault(); return(ge); } }
public List <GalleryGroup> GalleryGroupListGetBySiteID() { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { List <GalleryGroup> ge = (from c in db.tblGalleries where c.SiteID == this.ThisSite.SiteID select new GalleryGroup(c)).ToList(); return(ge); } }
public GalleryGroup GalleryGroupGetByID(Guid galleryID) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { GalleryGroup ge = (from c in db.tblGalleries where c.SiteID == this.ThisSite.SiteID && c.GalleryID == galleryID select new GalleryGroup(c)).FirstOrDefault(); return(ge); } }
public List <GalleryMetaData> GetGalleryMetaDataListByGalleryID(Guid galleryID) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { List <GalleryMetaData> imageData = (from g in db.tblGalleryImageMetas join gg in db.tblGalleryImages on g.GalleryImage.ToLower() equals gg.GalleryImage.ToLower() where g.SiteID == this.ThisSite.SiteID && gg.GalleryID == galleryID select new GalleryMetaData(g)).ToList(); return(imageData); } }
public GalleryImageEntry GalleryImageEntryGetByFilename(Guid galleryID, string galleryImage) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { GalleryImageEntry ge = (from c in db.tblGalleryImages where c.GalleryID == galleryID && c.GalleryImage.ToLower() == galleryImage.ToLower() orderby c.ImageOrder ascending select new GalleryImageEntry(c)).FirstOrDefault(); return(ge); } }
public void GalleryImageCleanup(Guid galleryID, List <string> lst) { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { var lstDel = (from g in db.tblGalleryImages where g.GalleryID == galleryID && !lst.Contains(g.GalleryImage.ToLower()) select g).ToList(); db.tblGalleryImages.DeleteAllOnSubmit(lstDel); db.SubmitChanges(); } }
public GalleryGroup GalleryGroupGetByName(string galleryTitle) { GalleryGroup ge = null; using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { if (!string.IsNullOrEmpty(galleryTitle)) { ge = (from c in db.tblGalleries where c.SiteID == this.ThisSite.SiteID && c.GalleryTitle.ToLower() == galleryTitle.ToLower() select new GalleryGroup(c)).FirstOrDefault(); } } return(ge); }
public GalleryMetaData GalleryMetaDataGetByFilename(string galleryImage) { GalleryMetaData ge = null; using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { if (!string.IsNullOrEmpty(galleryImage)) { ge = (from c in db.tblGalleryImageMetas where c.SiteID == this.ThisSite.SiteID && c.GalleryImage.ToLower() == galleryImage.ToLower() select new GalleryMetaData(c)).FirstOrDefault(); } } return(ge); }