private void CreateNewOil(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;
}
CreateOilInputModel model = new CreateOilInputModel
{
Make = MakeTextBox.Text,
MotorcycleId = GlobalVariables.CurrentBikeId,
KilometersOnChange = int.Parse(KilometersOnChangeTextBox.Text),
ChangeDate = ChangeDateDatePicker.Value.ToString("dd.MM.yyyy"),
Price = double.Parse(PriceTextBox.Text),
};
oilService.CreateOil(model);
AddKilometersAndMonthsDriven(maintenanceType, model.MotorcycleId, model.ChangeDate, model.KilometersOnChange);
}
/// <summary>
/// Creates new oil
/// </summary>
/// <param name="model"></param>
public void CreateOil(CreateOilInputModel model)
{
StringBuilder insertIntoOilQuery = new StringBuilder();
insertIntoOilQuery.Append($"execute procedure InsertIntoOil({model.Price},'{model.Make}','{model.ChangeDate}',{model.MotorcycleId},{model.KilometersOnChange});");
CommandExecuter.CommandExecuter.ExecuteNonQuery(insertIntoOilQuery.ToString());
}
