public ActionResult Details(Guid guid)
{
YoumotoDbContext context = new YoumotoDbContext();
var manufacturer = ManufacturerPersister.LoadSingle(context, guid);
return(this.View(new ManufacturerViewModel.Details(manufacturer)));
}
public static IEnumerable <Garage> LoadRandomPaged(
YoumotoDbContext context,
GarageTypes garageType,
Int32 skip,
Int32 take)
{
var garages = context.Garages
.Where(runner => garageType == GarageTypes.Any || runner.GarageType == garageType)
.Where(runner => runner.GaragePictures.Any())
.ToList();
List <Garage> result = new List <Garage>();
List <Int32> taken = new List <Int32>();
Random randomizer = new Random();
for (Int32 index = 0; index < take; index++)
{
Int32 randomIndex = 0;
do
{
randomIndex = randomizer.Next(0, garages.Count);
}while (taken.Contains(randomIndex));
taken.Add(randomIndex);
result.Add(garages[randomIndex]);
}
return(result);
}
public ActionResult Details(Guid guid)
{
var context = new YoumotoDbContext();
var vehicle = VehiclePersister.LoadSingle(context, guid);
return(View(new VehicleViewModel.Details(vehicle)));
}
public ActionResult Render(Guid?guid, Int32?width = null, Int32?height = null)
{
this.Response.Clear();
YoumotoDbContext context = new YoumotoDbContext();
Picture picture = guid == null ? null : PicturePersister.LoadSingle(context, guid.Value);
if (picture == null)
{
var bitmap = ESolutions.Youmoto.Web.UI.Properties.Resources.NoImage;
this.Response.ContentType = "image/png";
bitmap.Save(this.Response.OutputStream, ImageFormat.Png);
}
else
{
var bitmap = picture.GetBitmap(width, height);
this.Response.ContentType = "image/jpg";
Int64 compression = width.HasValue || height.HasValue ? 60L : 100L;
EncoderParameters parameters = new EncoderParameters(1);
parameters.Param[0] = new EncoderParameter(Encoder.Quality, compression);
ImageCodecInfo codec = ImageCodecInfo.GetImageEncoders().FirstOrDefault(runner => runner.FormatID == ImageFormat.Jpeg.Guid);
bitmap.Save(this.Response.OutputStream, codec, parameters);
}
this.Response.End();
return(null);
}
public SearchResultViewModel Search(String searchTerm, Int32 skip, Int32 take)
{
YoumotoDbContext context = new YoumotoDbContext();
var searchResult = Searcher.PerformFreetextSearch(context, searchTerm, skip, take);
return(new SearchResultViewModel(searchResult));
}
public IEnumerable <VehicleViewModel.Preview> LoadVehicles(Int32 skip = 0, Int32 take = 5)
{
YoumotoDbContext context = this.context ?? new YoumotoDbContext();
return(VehiclePersister
.LoadPaged(context, skip, take)
.Select(runner => new VehicleViewModel.Preview(runner)));
}
/// <summary>
/// Loads news articles paged.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="skipCount">The skip.</param>
/// <param name="takeCount">The take.</param>
/// <returns></returns>
public static IEnumerable <News> LoadLatestPaged(YoumotoDbContext context, Int32 skipCount, Int32 takeCount)
{
return(context.News
.OrderByDescending(runner => runner.Date)
.Skip(skipCount)
.Take(takeCount)
.ToList());
}
public static IEnumerable <Vehicle> LoadPaged(YoumotoDbContext context, Int32 skip, Int32 take)
{
return(context.Vehicles
.Where(runner => runner.VehiclePictures.Any())
.OrderBy(runner => runner.Guid)
.Skip(skip)
.Take(take));
}
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 IEnumerable <GarageViewModels.Preview> LoadGarages(Int32 skip = 0, Int32 take = 5)
{
YoumotoDbContext context = this.context ?? new YoumotoDbContext();
return(GaragePersister
.LoadRandomPaged(context, GarageTypes.Any, skip, take)
.Select(runner => new GarageViewModels.Preview(runner)));
}
public ActionResult Details(Guid guid)
{
YoumotoDbContext context = new YoumotoDbContext();
var garage = GaragePersister.LoadSingle(context, guid);
var viewModel = new GarageViewModels.Details(garage);
return(View(viewModel));
}
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 void TestLoadSingleWithNonExistingGuid()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
var picture = PicturePersister.LoadSingle(context, new Guid("{633CEC22-87CF-4D27-9FA6-578322675617}"));
Assert.IsNull(picture);
}
}
public IEnumerable <ManufacturerViewModel.Preview> LoadManufacturers(Int32 skip = 0, Int32 take = 5)
{
YoumotoDbContext context = this.context ?? new YoumotoDbContext();
return(ManufacturerPersister
.LoadPaged(context, skip, take)
.Select(runner => new ManufacturerViewModel.Preview(runner))
.ToList());
}
public void SearchExact()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
//var guid = Guid.NewGuid();
//context.Vehicles.Add(new Vehicle() { Guid = guid });
//context.SearchMatrix.Add(new SearchMatrixView() { });
//context.SaveChanges();
}
}
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 IEnumerable <VehicleSearchViewModel> SearchVehicles(String searchTerm)
{
YoumotoDbContext context = new YoumotoDbContext();
var result = Searcher.PerformVehicleSearch(context, searchTerm);
return(result.Select(runner => new Models.VehicleSearchViewModel()
{
Guid = runner.Guid,
Fullname = runner.Fullname
}));
}
public void CreateAndSaveVehicle()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
Vehicle vehicle = Vehicle.Create(VehicleTests.vehicleName);
context.Vehicles.Add(vehicle);
context.SaveChanges();
Assert.AreEqual(VehicleTests.vehicleName, vehicle.Name);
}
}
public static IEnumerable <Vehicle> LoadRandomPaged(YoumotoDbContext context, Int32 take)
{
var vehicleQuery = context.Vehicles.Where(runner => runner.VehiclePictures.Any());
var count = vehicleQuery.Count();
var maxSkip = count - take;
var randomSkip = new Random().Next(0, maxSkip);
return(vehicleQuery
.OrderBy(runner => runner.Guid)
.Skip(randomSkip)
.Take(take));
}
public void CreateAndSaveManufacturer()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
Manufacturer manufacturer = Manufacturer.Create(ManufacturerTests.manufacturerName);
context.Manufacturers.Add(manufacturer);
context.SaveChanges();
Assert.AreEqual(ManufacturerTests.manufacturerName, manufacturer.Name);
}
}
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 static IEnumerable <Manufacturer> LoadPaged(YoumotoDbContext context, Int32 skip, Int32 take)
{
return(context.Manufacturers
.Where(runner => runner.PictureGuid.HasValue)
.Where(runner =>
runner.ManufacturerVehicles.Any(x => x.Vehicle.VehiclePictures.Any()) ||
runner.Series.Any(x => x.SeriesVehicles.Any(y => y.Vehicle.VehiclePictures.Any()))
)
.OrderBy(runner => runner.Name)
.Skip(skip)
.Take(take));
}
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));
}
public void TestLoadSingleWithExistingGuid()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
Picture newPicture = PicturePersister.Create();
context.Pictures.Add(newPicture);
context.SaveChanges();
var picture = PicturePersister.LoadSingle(context, newPicture.Guid);
Assert.IsNotNull(picture);
Assert.AreEqual(newPicture, picture);
}
}
//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 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 CreateAndSaveSeries()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
Manufacturer manufacturer = Manufacturer.Create(SeriesTests.manufacturerName);
Series series = Series.Create(manufacturer, SeriesTests.seriesName);
context.Manufacturers.Add(manufacturer);
context.Series.Add(series);
context.SaveChanges();
Assert.AreEqual(SeriesTests.seriesName, series.Name);
}
}
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 void CreateAndSaveGarage()
{
using (var context = new YoumotoDbContext(Effort.DbConnectionFactory.CreateTransient()))
{
//User user = User.Create(GarageTests.userEmail, GarageTests.userPassword, GarageTests.userPassword);
//context.Users.Add(user);
//Vehicle vehicle = Vehicle.Create(GarageTests.vehicleName);
//context.Vehicles.Add(vehicle);
//Garage garage = Garage.Create(user, vehicle, GarageTests.garageTitle);
//context.Garages.Add(garage);
//context.SaveChanges();
}
}
