public async Task <ActionResult> Add(AddModelYearRequestModel viewModel)
{
// First, make sure that the Modelyear itself is accounted for.
if ((await ModelYearManager.GetAllAsync <ModelYear>(
x => x.Year.Value.Year == viewModel.Year &&
x.Model.Id == viewModel.ModelId)).Any() == false)
{
var model = (await ModelYearManager.GetAllAsync <Model>(x => x.Id == viewModel.ModelId)).Single();
var year = (await ModelYearManager.GetAllAsync <Year>(x => x.Value.Year == viewModel.Year)).Single();
ModelYearManager.SaveOrUpdateAsync(new ModelYear {
Model = model, Year = year
}).Wait();
}
// Then, cross check with the Colors in which the ModelYear is available.
var modelYear = (await ModelYearManager.GetAllAsync <ModelYear>(
x => x.Year.Value.Year == viewModel.Year &&
x.Model.Id == viewModel.ModelId)).First();
// Remember, the Color Id is what we want here not the joining table.
// ReSharper disable once InvertIf
if (modelYear.Colors.All(x => x.Color.Id != viewModel.ColorId))
{
var color = (await ModelYearManager.GetAllAsync <Paint>(x => x.Id == viewModel.ColorId)).Single();
ModelYearManager.SaveOrUpdateAsync(new ModelYearColor {
ModelYear = modelYear, Color = color
}).Wait();
}
// Then simply relist the model years.
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Get()
{
var responseModels = (await ModelYearManager.GetAllAsync <ModelYearColor>())
.Select(Mapper.Map <ModelYearColor, ModelYearResponseModel>)
.OrderBy(x => x.ManufacturerName)
.ThenBy(x => x.ModelName)
.ThenByDescending(x => x.Year)
.ThenBy(x => x.ColorName).ToArray();
return(Json(responseModels, AllowGet));
}
public async Task <ActionResult> Index()
{
var viewModels = (await ModelYearManager.GetAllAsync <ModelYearColor>())
.Select(Mapper.Map <ModelYearColor, ModelYearViewModel>)
.OrderBy(x => x.ManufacturerName)
.ThenBy(x => x.ModelName)
.ThenByDescending(x => x.Year)
.ThenBy(x => x.ColorName).ToArray();
return(View(viewModels));
}