/// <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; }