public void DeleteNewsByNewsId(int id) { NewsImageService imageService = new NewsImageService(); using (var transaction = dbContext.Database.BeginTransaction()) { try { var news = GetNewsById(id); if (news != null) { var newsImages = imageService.GetNewsImageByNewsId(news.Id); foreach (NewsImage images in newsImages) { NewsImageRepository.Delete(images); } Save(); } NewsRepository.Delete(news); Save(); transaction.Commit(); //return order.ID; } catch (Exception ex) { transaction.Rollback(); throw ex.InnerException; } } }
public void UpdateNews(NewsModel news) { using (var transaction = dbContext.Database.BeginTransaction()) { try { var newsobj = GetNewsById(news.Id); if (newsobj != null) { newsobj.Note = news.Note; newsobj.VideoPath = news.VideoPath; newsobj.WhenCreated = DateTime.Now; } NewsRepository.Update(newsobj); Save(); NewsImageService imageService = new NewsImageService(); if (newsobj != null) { var newsImages = imageService.GetNewsImageByNewsId(newsobj.Id); foreach (NewsImage images in newsImages) { NewsImageRepository.Delete(images); } Save(); } //newNewsId = test.Id; //NewsImageService aa = new NewsImageService(); if (news.NewsImage != null) { foreach (var image in news.NewsImage.ToList()) { if (image != null) { image.NewsId = newsobj.Id; image.ImagePath = "http://cmistest.indas.on.ca/group/images/" + newsobj.GroupHeadId + "/" + image.ImagePath; NewsImageRepository.Insert(image); Save(); //aa.AddNewsImage(image); //Save(); } } } transaction.Commit(); //return news.Id; } catch (Exception ex) { transaction.Rollback(); throw ex.InnerException; } } }
//data update with transaction public void AddNews(NewsModel news /*, string Host*/) { using (var transaction = dbContext.Database.BeginTransaction()) { try { int newNewsId = 0; News test = new News(); test.GroupHeadId = news.GroupHeadId; test.Title = news.Title; test.Note = news.Note; test.VideoPath = news.VideoPath; test.Viewer = 0; test.Comment = 0; test.WhoCreated = 1; test.WhenCreated = DateTime.Now;; NewsRepository.Insert(test); Save(); newNewsId = test.Id; NewsImageService aa = new NewsImageService(); if (news.NewsImage != null) { foreach (var image in news.NewsImage.ToList()) { if (image != null) { image.NewsId = newNewsId; image.ImagePath = "http://cmistest.indas.on.ca/group/images/" + test.GroupHeadId + "/" + image.ImagePath; NewsImageRepository.Insert(image); Save(); //aa.AddNewsImage(image); //Save(); } } } transaction.Commit(); //return news.Id; } catch (Exception ex) { transaction.Rollback(); throw ex.InnerException; } } }