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);
}
}
