private void CreateNewOilFilter(string maintenanceType)
{
if (!IsMoney(PriceTextBox.Text))
{
MessageBox.Show("Price must be a number", GlobalConstants.MessageBoxTopInfo);
return;
}
if (!IsKilometers(KilometersOnChangeTextBox.Text))
{
MessageBox.Show("Kilometers must be a number", GlobalConstants.MessageBoxTopInfo);
return;
}
OilFilterInputModel model = new OilFilterInputModel
{
Make = MakeTextBox.Text,
MotorcycleId = GlobalVariables.CurrentBikeId,
KilometersOnChange = int.Parse(KilometersOnChangeTextBox.Text),
ChangeDate = ChangeDateDatePicker.Value.ToString("dd.MM.yyyy"),
Price = double.Parse(PriceTextBox.Text),
};
oilFilterService.CreateOilFilter(model);
AddKilometersAndMonthsDriven(maintenanceType, model.MotorcycleId, model.ChangeDate, model.KilometersOnChange);
}
public void CreateOilFilter(OilFilterInputModel model)
{
StringBuilder insertIntoOilFilterQuery = new StringBuilder();
insertIntoOilFilterQuery.Append($"execute procedure InsertIntoOilFilter({model.Price},'{model.Make}','{model.ChangeDate}',{model.MotorcycleId},{model.KilometersOnChange});");
CommandExecuter.CommandExecuter.ExecuteNonQuery(insertIntoOilFilterQuery.ToString());
}
