public void SetAdditionalData(UpdateMaintenanceDataInputModel model)
{
StringBuilder updateQuery = new StringBuilder();
updateQuery.Append($"update {model.TableName} t ");
updateQuery.Append($" set t.monthsdriven = {model.MonthsDriven} , t.kilometersdriven = {model.KilometersDriven} ");
int recordId = GetLastRecordId(model.TableName, model.MotorcycleId);
updateQuery.Append($" where t.id = {recordId} ");
CommandExecuter.CommandExecuter.ExecuteNonQuery(updateQuery.ToString());
}
private void AddKilometersAndMonthsDriven(string maintenanceType, int motorcycleId, string changeDate, int kilometersOnChange)
{
if (maintenanceService.IsNotLast(maintenanceType, motorcycleId))
{
CalculationDataModel calcDataModel = maintenanceService.GetCalculationDataModel(maintenanceType, motorcycleId);
int monthsDriven = maintenanceService.CalculateMonthsDriven(DateTime.ParseExact(changeDate, "dd.MM.yyyy", CultureInfo.InvariantCulture), calcDataModel.ChangeDate);
int kilometersDriven = maintenanceService.CalculateKilometersDriven(kilometersOnChange, calcDataModel.KilometersOnChange);
UpdateMaintenanceDataInputModel updateModel = new UpdateMaintenanceDataInputModel
{
KilometersDriven = kilometersDriven,
MonthsDriven = monthsDriven,
TableName = maintenanceType,
MotorcycleId = motorcycleId,
};
maintenanceService.SetAdditionalData(updateModel);
}
}