/// <summary>
/// Fills the torque ratio Listview
/// </summary>
private void PopulateGears()
{
// Clear out any old items
gearListView.Items.Clear();
// Reorder
ReverseGears = ReverseGears.OrderBy(x => x.Ratio).ToList();
ForwardGears = ForwardGears.OrderByDescending(x => x.Ratio).ToList();
// Reverse Gears
int i = 0;
foreach (var gear in ReverseGears)
{
gear.GearIndex = i;
AddGear(gear, i++);
}
// Forward Gears
i = 0;
foreach (var gear in ForwardGears)
{
gear.GearIndex = i;
AddGear(gear, i++);
}
}
private void ConfirmButton_Click(object sender, EventArgs e)
{
// Check UnitName
// Check for a valid identifier string
if (!SiiFileBuilder.IsValidUnitName(unitNameBox.Text))
{
// Tell the user this isnt allowed
MessageBox.Show(
"Invalid Transmission Sii Unit Name. Tokens must be 1 to 12 characters in length, seperated by a dot, "
+ "and contain alpha-numeric or underscores only",
"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning
);
return;
}
// Check engine name
if (transNameBox.Text.Length < 2 || transNameBox.Text.Contains('"'))
{
// Tell the user this isnt allowed
MessageBox.Show(
"Invalid Transmission Name string! The name must be at least 2 characters long and contain no quotes",
"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning
);
return;
}
// Set new attribute values
Transmission.SeriesId = ((TransmissionSeries)seriesModelBox.SelectedItem).Id;
Transmission.UnitName = unitNameBox.Text.Trim();
Transmission.Name = transNameBox.Text.Trim();
Transmission.Price = (int)priceBox.Value;
Transmission.Unlock = (int)unlockBox.Value;
Transmission.DifferentialRatio = diffRatio.Value;
Transmission.Defaults = fileDefaultsTextBox.Lines;
Transmission.Comment = fileCommentTextBox.Lines;
Transmission.Conflicts = conflictsTextBox.Lines;
Transmission.SuitableFor = suitablesTextBox.Lines;
Transmission.Retarder = (hasRetarder.Checked) ? (int)retardPositions.Value : 0;
Transmission.StallTorqueRatio = (hasTorqueConverter.Checked) ? stallRatio.Value : 0.0m;
// Figure out the filename
if (!String.IsNullOrWhiteSpace(filenameTextBox.Text))
{
Transmission.FileName = filenameTextBox.Text.Trim();
}
// Validate and Save
using (AppDatabase db = new AppDatabase())
using (SQLiteTransaction trans = db.BeginTransaction())
{
// Verify that the series.Id and engine.UnitName are unique
string query = "SELECT * FROM `Transmission` WHERE `SeriesId`=@P0 AND `UnitName`=@P1";
var eTrans = db.Query <Transmission>(query, Transmission.SeriesId, Transmission.UnitName).FirstOrDefault();
if (eTrans != null && (NewTransmission || eTrans.Id != Transmission.Id))
{
// Tell the user this isnt allowed
MessageBox.Show(
$"The selected Transmission Series already contains a transmission with the Sii Unit Name of \""
+ Transmission.UnitName + "\"! Please select a different Transmission Series or change the Sii "
+ "Unit Name to something unique.",
"Unique Constraint Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning
);
return;
}
// Wrap database changes in a try-catch block so we can Rollback on error
try
{
// Update the current engine
db.Transmissions.AddOrUpdate(Transmission);
// If pre-existing transmission, delete all changed data
if (!NewTransmission)
{
// Delete any and all TorueRatios from the database
if (GearsChanged)
{
foreach (var gear in Transmission.Gears)
{
db.TransmissionGears.Remove(gear);
}
}
// Set Conflicts
if (ConflictsChanged)
{
foreach (var conflict in Transmission.EngineConflicts)
{
db.AccessoryConflicts.Remove(conflict);
}
}
// Set Suitables
if (SuitablesChanged)
{
foreach (var item in Transmission.SuitableEngines)
{
db.SuitableAccessories.Remove(item);
}
}
// Set Conflicts
if (TrucksChanged)
{
foreach (var item in Transmission.ItemOf)
{
db.TruckTransmissions.Remove(item);
}
}
}
// Add conflicts if any
if ((NewTransmission || ConflictsChanged) && conflictListView.CheckedItems.Count > 0)
{
var ids = conflictListView.CheckedItems.Cast <ListViewItem>().Select(x => (int)x.Tag);
foreach (var item in ids)
{
db.AccessoryConflicts.Add(new AccessoryConflict()
{
EngineId = item,
TransmissionId = Transmission.Id
});
}
}
// Add suitible fors if any
if ((NewTransmission || SuitablesChanged) && suitsListView.CheckedItems.Count > 0)
{
var ids = suitsListView.CheckedItems.Cast <ListViewItem>().Select(x => (int)x.Tag);
foreach (var item in ids)
{
db.SuitableAccessories.Add(new SuitableAccessory()
{
EngineId = item,
TransmissionId = Transmission.Id
});
}
}
// Add trucks if any
if ((NewTransmission || TrucksChanged) && truckListView.CheckedItems.Count > 0)
{
var ids = truckListView.CheckedItems.Cast <ListViewItem>().Select(x => (int)x.Tag);
foreach (var item in ids)
{
db.TruckTransmissions.Add(new TruckTransmission()
{
TruckId = item,
TransmissionId = Transmission.Id
});
}
}
// Add the new torque ratios
if (NewTransmission || GearsChanged)
{
int i = 0;
foreach (var gear in ReverseGears.OrderBy(x => x.Ratio))
{
gear.TransmissionId = Transmission.Id;
gear.GearIndex = i++;
db.TransmissionGears.Add(gear);
}
foreach (var gear in ForwardGears.OrderByDescending(x => x.Ratio))
{
gear.TransmissionId = Transmission.Id;
gear.GearIndex = i++;
db.TransmissionGears.Add(gear);
}
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
// Tell the user about the failed validation error
MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
this.DialogResult = DialogResult.OK;
}
