public override bool insPhotoAlbum(Guid id, PhotoAlbum ins) { try { using (var db = new CMSdb(_context)) { using (var tran = db.BeginTransaction()) { content_photoalbum cdPhotoAlbum = db.content_photoalbums .Where(p => p.id == ins.Id) .SingleOrDefault(); if (cdPhotoAlbum != null) { throw new Exception("Запись с таким Id уже существует"); } cdPhotoAlbum = new content_photoalbum { id = ins.Id, f_site = _domain, c_path = ins.Path, c_title = ins.Title, c_text = ins.Text, d_date = ins.Date, c_preview = (ins.PreviewImage != null) ? ins.PreviewImage.Url : null }; db.Insert(cdPhotoAlbum); var log = new LogModel() { Site = _domain, Section = LogSection.PhotoAlbums, Action = LogAction.insert, PageId = ins.Id, PageName = ins.Title, UserId = _currentUserId, IP = _ip, }; insertLog(log); tran.Commit(); return(true); } } } catch { return(false); } }
public override bool updPhotoAlbum(Guid id, PhotoAlbum upd) { try { using (var db = new CMSdb(_context)) { using (var tran = db.BeginTransaction()) { content_photoalbum cdPhoto = db.content_photoalbums .Where(p => p.id == upd.Id) .SingleOrDefault(); if (cdPhoto == null) { throw new Exception("Запись с таким Id не найдена"); } cdPhoto.c_title = upd.Title; cdPhoto.c_text = upd.Text; cdPhoto.d_date = upd.Date; cdPhoto.c_preview = (upd.PreviewImage == null) ? cdPhoto.c_preview : upd.PreviewImage.Url; db.Update(cdPhoto); var log = new LogModel() { Site = _domain, Section = LogSection.PhotoAlbums, Action = LogAction.update, PageId = upd.Id, PageName = upd.Title, UserId = _currentUserId, IP = _ip, }; insertLog(log); tran.Commit(); return(true); } } } catch { return(false); } }