public IEnumerable <NewsViewModel.Preview> LoadNews(Int32 skip = 0, Int32 take = 5) { YoumotoDbContext context = this.context ?? new YoumotoDbContext(); return(NewsPersister .LoadLatestPaged(context, skip, take) .Select(runner => new NewsViewModel.Preview(runner))); }
public ActionResult Details(Guid guid) { YoumotoDbContext context = new YoumotoDbContext(); var news = NewsPersister.LoadSingle(context, guid); var viewModel = new NewsViewModel.Details(news); return(View(viewModel)); }
public NewsViewModel.Preview CreateNews(String title) { YoumotoDbContext context = this.context ?? new YoumotoDbContext(); News newNews = NewsPersister.Create(title); context.News.Add(newNews); context.SaveChanges(); return(new NewsViewModel.Preview(newNews)); }
public void UpdateNews(Guid guid, String title, String text, String sourceLink) { YoumotoDbContext context = this.context ?? new YoumotoDbContext(); var item = NewsPersister.LoadSingle(context, guid); item.Title = title ?? String.Empty; item.Text = text ?? String.Empty; item.SourceLink = sourceLink ?? String.Empty; item.UpdateTimeStamp = DateTime.UtcNow; context.SaveChangesAsync(); }
public void CreateAndSaveNews() { using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient())) { News news = NewsPersister.Create(NewsTests.newsTitle); context.News.Add(news); context.SaveChanges(); Assert.AreEqual(NewsTests.newsTitle, news.Title); } }
public NewsViewModel.Details AddPicture(Guid newsGuid, String pictureUrl) { YoumotoDbContext context = this.context ?? new YoumotoDbContext(); var result = NewsPersister.LoadSingle(context, newsGuid); var newPicture = NewsPersister.CreatePicture(result, pictureUrl); context.NewsPictures.Add(newPicture); context.SaveChanges(); return(new Models.NewsViewModel.Details(result)); }
//Methods #region CreateTestNews private List <News> CreateTestNews(int newsCount, YoumotoDbContext context) { List <News> testNews = new List <News>(); newsCount.Times(index => { News news = NewsPersister.Create(NewsTests.newsTitle + index.ToString()); news.Date = DateTime.UtcNow.AddDays(newsCount * -1).AddDays(index); testNews.Add(news); context.News.Add(news); }); return(testNews); }
public NewsViewModel.Details DeleteVehicle(Guid newsVehicleGuid) { YoumotoDbContext context = this.context ?? new YoumotoDbContext(); var item = NewsPersister.LoadSingleVehicle(context, newsVehicleGuid); var news = item.News; context.NewsVehicles.Remove(item); context.SaveChanges(); var result = new Models.NewsViewModel.Details(news); return(result); }
public NewsViewModel.Details AddVehicle(Guid newsGuid, Guid vehicleGuid) { YoumotoDbContext context = this.context ?? new YoumotoDbContext(); var result = NewsPersister.LoadSingle(context, newsGuid); var vehicle = VehiclePersister.LoadSingle(context, vehicleGuid); var newPicture = NewsPersister.CreateVehicle(result, vehicle); context.NewsVehicles.Add(newPicture); context.SaveChanges(); return(new Models.NewsViewModel.Details(result)); }
public void CreateNewsPicture() { using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient())) { String url = "https://www.youmoto.com/test.jpg"; News news = NewsPersister.Create("MyTitle"); NewsPicture newsPicture = NewsPersister.CreatePicture(news, url); context.News.Add(news); context.SaveChanges(); Assert.AreEqual(1, context.News.Count()); Assert.AreEqual(1, context.NewsPictures.Count()); Assert.AreEqual(1, context.News.First().NewsPictures.Count()); Assert.AreEqual(url, context.News.First().NewsPictures.First().ImageLink); } }
public void LoadNewsPagedSecoundChunk() { Int32 newsCount = 5; using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient())) { List <News> testNews = this.CreateTestNews(newsCount, context); context.SaveChanges(); var paged = NewsPersister.LoadLatestPaged(context, 2, 2).ToList(); Assert.AreEqual(2, paged.Count()); Assert.AreEqual(testNews[newsCount - 3].Guid, paged[0].Guid); Assert.AreEqual(testNews[newsCount - 4].Guid, paged[1].Guid); } }