public void Handle(FuelTypeModel fuelTypeModel)
{
AvailableFuelTypes = new ObservableCollection <FuelTypeModel>(SqliteDataAccess.LoadAllFuelTypes());
SelectedFuelType = fuelTypeModel;
NotifyOfPropertyChange(() => AvailableFuelTypes);
NotifyOfPropertyChange(() => SelectedFuelType);
}
public async Task <bool> AddType([FromBody] FuelTypeModel type)
{
var result = await _carContract.AddType(_mapper.Map <FuelTypeModel, FuelTypePOCO>(type));
if (result)
{
return(true);
}
return(false);
}
private void AddFuelType()
{
FuelTypeModel fuelTypeModelToAdd = new FuelTypeModel {
TypeOfFuel = TxtFuelTypeName
};
fuelTypeModelToAdd.Id = SqLiteDataAccessCarRefuelTrackerModule.AddFuelType(fuelTypeModelToAdd).Id;
_eventAggregator.GetEvent <ObjectEvent>().Publish(fuelTypeModelToAdd);
LogHelper.WriteToLog(appLogger, $"Fueltype {TxtFuelTypeName} added", LogState.Info);
Close?.Invoke();
}
public void PostFuelTypeReturnsBadRequestWhenModelIsInvalid()
{
var invalidModel = new FuelTypeModel();
_sut.ModelState.AddModelError("name", "name is required");
var result = _sut.PostEntity(invalidModel) as BadRequestResult;
Assert.That(result, Is.Not.Null);
_fuelTypeRepositoryMock.Verify(m => m.Add(It.IsAny <FuelType>()), Times.Never);
}
/// <summary>
/// Assign the values from the TextBox to the FuelTypeModel Properties. Save the FuelTypeModel in the Database.
/// Logs the Event in the LogFileName. Closes the Add FuelTypeView
/// </summary>
public void AddFuelType()
{
LogHelper.WriteToLog("FuelType creation started", LogState.Debug);
FuelTypeModel = new FuelTypeModel();
FuelTypeModel.TypeOfFuel = FuelTypeName;
FuelTypeModel = SqliteDataAccess.AddFuelType(FuelTypeModel);
EventAggregationProvider.EventAggregator.PublishOnUIThread(FuelTypeModel);
if (FuelTypeModel.TypeOfFuel != null && FuelTypeModel.TypeOfFuel != "")
{
LogHelper.WriteToLog("Brand created", LogState.Info);
}
TryClose();
}
public void UpdateFuelTypeReturnsBadRequestWhenIdFromModelDoesNotMatchIdFromQueryParameter()
{
var invalidModel = new FuelTypeModel
{
Id = 1
};
var result = _sut.UpdateEntity(invalidModel, invalidModel.Id + 1) as BadRequestObjectResult;
Assert.That(result, Is.Not.Null);
_fuelTypeRepositoryMock.Verify(m => m.Update(It.IsAny <int>(), It.IsAny <FuelType>()), Times.Never);
}
/// <summary>
/// Removes the given FuelTypeModel from the Database and also all cars with the deleted FuelType
/// </summary>
/// <param name="fuelTypeModel">FuelTypeModel to delete</param>
public static void RemoveFuelTypeFromDatabase(FuelTypeModel fuelTypeModel)
{
try
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Query($"DELETE FROM TypeOfFuel WHERE id = {fuelTypeModel.Id}");
cnn.Query($"DELETE FROM Car WHERE typeoffuelid = {fuelTypeModel.Id}");
}
}
catch (SQLiteException ex)
{
LogHelper.WriteToLog(appLogger, ex.Message, LogState.Error);
}
}
public void UpdateFuelTypeReturnsNotFoundWhenFuelTypeIsNotFound()
{
var invalidModel = new FuelTypeModel
{
Id = 1
};
_fuelTypeRepositoryMock.Setup(m => m.Update(It.IsAny <int>(), It.IsAny <FuelType>()))
.Returns(false);
var result = _sut.UpdateEntity(invalidModel, invalidModel.Id) as NotFoundObjectResult;
Assert.That(result, Is.Not.Null);
_fuelTypeRepositoryMock.Verify(m => m.Update(It.IsAny <int>(), It.IsAny <FuelType>()), Times.Once);
}
public IViewComponentResult Invoke()
{
var fuelTypes = new FuelTypeModel
{
FuelTypes = this.fuelTypeService
.GetAllTypesAsync()
.Result
.OrderBy(m => m.Name)
.Select(m => new SelectListItem
{
Text = m.Name,
Value = m.Id
}).ToList()
};
return(this.View(WebConstants.ViewComponentDefault, fuelTypes));
}
public void UpdateFuelTypeReturnsOkWhenEverythingIsCorrect()
{
var validModel = new FuelTypeModel
{
Id = 1,
Name = ""
};
_fuelTypeRepositoryMock.Setup(m => m.Update(It.IsAny <int>(), It.IsAny <FuelType>()))
.Returns(true);
var result = _sut.UpdateEntity(validModel, validModel.Id) as OkResult;
Assert.That(result, Is.Not.Null);
_fuelTypeRepositoryMock.Verify(m => m.Update(It.IsAny <int>(), It.IsAny <FuelType>()), Times.Once);
}
public void PostFuelTypeReturnsOkWhenModelIsValid()
{
var validModel = new FuelTypeModel
{
Name = "name"
};
_mapperMock.Setup(m => m.Map <FuelTypeReturnModel>(It.IsAny <FuelType>()))
.Returns(new FuelTypeReturnModel());
_mapperMock.Setup(m => m.Map <FuelType>(It.IsAny <FuelTypeModel>()))
.Returns(new FuelType());
var result = _sut.PostEntity(validModel) as OkObjectResult;
Assert.That(result, Is.Not.Null);
Assert.That((FuelTypeReturnModel)result.Value, Is.Not.Null);
_fuelTypeRepositoryMock.Verify(m => m.Add(It.IsAny <FuelType>()), Times.Once);
}
/// <summary>
/// Adds a FuelTypeModel to the Database
/// </summary>
/// <param name="fuelType">FuelTypeModel to add</param>
/// <returns>FuelTypeModel with Id from Database</returns>
public static FuelTypeModel AddFuelType(FuelTypeModel fuelType)
{
try
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
int fueltTypeInDatabase =
cnn.Query <int>($"SELECT id FROM TypeOfFuel WHERE TypeOfFuel = '{fuelType.TypeOfFuel}'").Count();
if (fueltTypeInDatabase == 0)
{
fuelType.Id =
cnn.Query <int>($"INSERT INTO TypeOfFuel (TypeOfFuel) VALUES('{fuelType.TypeOfFuel}'); " +
$"SELECT last_insert_rowid()", fuelType).First();
}
return(fuelType);
}
}
catch (SQLiteException ex)
{
LogHelper.WriteToLog(appLogger, ex.Message, LogState.Error);
return(new FuelTypeModel());
}
}
public FuelTypeController(FuelDbContext fuelContext, IStringLocalizer stringLocalizer)
{
_fuelTypeModel = new FuelTypeModel(fuelContext, stringLocalizer);
}
