public void Save() { using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) { tblGalleryImage gal = (from c in db.tblGalleryImages where c.GalleryImageID == this.GalleryImageID select c).FirstOrDefault(); if (gal == null || this.GalleryID == Guid.Empty) { gal = new tblGalleryImage(); gal.GalleryID = this.GalleryID; gal.GalleryImageID = Guid.NewGuid(); } gal.GalleryImage = this.GalleryImage; gal.ImageOrder = this.ImageOrder; if (gal.GalleryImageID != this.GalleryImageID) { db.tblGalleryImages.InsertOnSubmit(gal); } db.SubmitChanges(); this.GalleryImageID = gal.GalleryImageID; } }
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 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(); } }