private void CreateNewCoolant(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;
}
CreateCoolantInputModel model = new CreateCoolantInputModel
{
Make = MakeTextBox.Text,
MotorcycleId = GlobalVariables.CurrentBikeId,
KilometersOnChange = int.Parse(KilometersOnChangeTextBox.Text),
ChangeDate = ChangeDateDatePicker.Value.ToString("dd.MM.yyyy"),
Price = double.Parse(PriceTextBox.Text),
};
coolantService.CreateCoolant(model);
AddKilometersAndMonthsDriven(maintenanceType, model.MotorcycleId, model.ChangeDate, model.KilometersOnChange);
}
public void CreateCoolant(CreateCoolantInputModel model)
{
StringBuilder insertIntoCoolandQuerySb = new StringBuilder();
insertIntoCoolandQuerySb.Append($"execute procedure InsertIntoCoolant({model.Price},'{model.Make}','{model.ChangeDate}',{model.MotorcycleId},{model.KilometersOnChange});");
CommandExecuter.CommandExecuter.ExecuteNonQuery(insertIntoCoolandQuerySb.ToString());
}
