private void btnRemove_Click(object sender, EventArgs e)
{
if (listGearBox.SelectedItems.Count > 0)
{
GearBox gearBoxToDelete = new GearBox();
gearBoxToDelete = (GearBox)listGearBox.SelectedItems[0];
foreach (GearBox gb in Program.gearBoxList)
{
if (gb.Equals(gearBoxToDelete))
{
gearBoxToDelete = gb;
}
}
Program.gearBoxList.Remove(gearBoxToDelete);
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
gbta.Delete(gearBoxToDelete.ID, gearBoxToDelete.Name, gearBoxToDelete.Alpha, gearBoxToDelete.AxesDistance, gearBoxToDelete.GearModule, gearBoxToDelete.InputTorque, gearBoxToDelete.OutputTorque, gearBoxToDelete.TorqueRatio, gearBoxToDelete.InputGear.ID, gearBoxToDelete.OutputGear.ID);
}
refreshList();
treeViewGearBox.Nodes.Clear();
propertyGridGearBox.SelectedObject = null;
this.btnRemove.Enabled = false;
this.btnEdit.Enabled = false;
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (DialogResult.OK == MessageBox.Show("You may delete the Shafts, Gears and Gear Boxes associated. Do you want to continue ?", "Caution", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
{
if (listMaterial.SelectedItems.Count > 0)
{
Material materialToDelete = new Material();
materialToDelete = (Material)listMaterial.SelectedItems[0];
Program.materialList.Remove(materialToDelete);
Database1DataSet1TableAdapters.MaterialsTableAdapter mta = new Database1DataSet1TableAdapters.MaterialsTableAdapter();
Database1DataSet1TableAdapters.Shaft1TableAdapter sta = new Database1DataSet1TableAdapters.Shaft1TableAdapter();
Database1DataSet1TableAdapters.GearsTableAdapter gta = new Database1DataSet1TableAdapters.GearsTableAdapter();
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
List<int> shaftIds = Util.listOfShaftIds(materialToDelete.ID, sta);
List<int> gearIds = Util.listOfGearIds(materialToDelete.ID, shaftIds, gta);
try
{
foreach (int g in gearIds)
{
gbta.DeleteInputGearQuery(g);
gbta.DeleteOutputGearQuery(g);
Gear gear = Util.getGearById(g);
Program.gearList.Remove(gear);
}
foreach (int s in shaftIds)
{
gta.DeleteShaftQuery(s);
Shaft shaft = Util.getShaftById(s);
Program.shaftList.Remove(shaft);
}
sta.DeleteQuery(materialToDelete.ID);
mta.Delete(materialToDelete.ID, materialToDelete.Name, materialToDelete.youngsModulus, materialToDelete.Density, materialToDelete.yieldStress);
Util.refreshGearBoxList();
}
catch (Exception ex) { }
}
refreshList();
propertyGridMaterial.SelectedObject = null;
btnRemove.Enabled = false;
btnEdit.Enabled = false;
btnSelect.Enabled = false;
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (DialogResult.OK == MessageBox.Show("You may delete Gears and Gear Boxes associated. Do you want to continue ?", "Caution", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
{
if (listShaft.SelectedItems.Count > 0)
{
Shaft shaftToDelete = new Shaft();
shaftToDelete = (Shaft)listShaft.SelectedItems[0];
Program.shaftList.Remove(shaftToDelete);
Database1DataSet1TableAdapters.Shaft1TableAdapter sta = new Database1DataSet1TableAdapters.Shaft1TableAdapter();
Database1DataSet1TableAdapters.GearsTableAdapter gta = new Database1DataSet1TableAdapters.GearsTableAdapter();
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
List<int> gearIds = Util.listOfGearIds(shaftToDelete.ID, gta);
try
{
foreach (int g in gearIds)
{
gbta.DeleteInputGearQuery(g);
gbta.DeleteOutputGearQuery(g);
Gear gear = Util.getGearById(g);
Program.gearList.Remove(gear);
}
gta.DeleteShaftQuery(shaftToDelete.ID);
sta.Delete(shaftToDelete.ID, shaftToDelete.Name, shaftToDelete.Diameter, shaftToDelete.Material.ID, shaftToDelete.KeyCutWidth, shaftToDelete.KeyCutHeigth, shaftToDelete.KeyCutLength);
Util.refreshGearBoxList();
}
catch (Exception ex) { }
}
refreshList();
treeViewShaft.Nodes.Clear();
propertyGridShaft.SelectedObject = null;
btnRemove.Enabled = false;
btnEdit.Enabled = false;
btnSelect.Enabled = false;
}
}
private void btnValidate_Click(object sender, EventArgs e)
{
Database1DataSet1TableAdapters.Shaft1TableAdapter sta = new Database1DataSet1TableAdapters.Shaft1TableAdapter();
sta.Insert(inputGear.Shaft.Name, inputGear.Shaft.Diameter, inputGear.Shaft.Material.ID, inputGear.Shaft.KeyCutWidth, inputGear.Shaft.KeyCutHeigth, inputGear.Shaft.KeyCutLength);
sta.Insert(outputGear.Shaft.Name, outputGear.Shaft.Diameter, outputGear.Shaft.Material.ID, outputGear.Shaft.KeyCutWidth, outputGear.Shaft.KeyCutHeigth, outputGear.Shaft.KeyCutLength);
inputGear.Shaft.ID = (int)sta.getID(inputGear.Shaft.Name, inputGear.Shaft.Diameter, inputGear.Shaft.Material.ID, inputGear.Shaft.KeyCutWidth, inputGear.Shaft.KeyCutHeigth, inputGear.Shaft.KeyCutLength);
outputGear.Shaft.ID = (int)sta.getID(outputGear.Shaft.Name, outputGear.Shaft.Diameter, outputGear.Shaft.Material.ID, outputGear.Shaft.KeyCutWidth, outputGear.Shaft.KeyCutHeigth, outputGear.Shaft.KeyCutLength);
Database1DataSet1TableAdapters.GearsTableAdapter gta = new Database1DataSet1TableAdapters.GearsTableAdapter();
gta.Insert(inputGear.Name, inputGear.Alpha,inputGear.GearModule, inputGear.Material.ID, inputGear.Torque, inputGear.Shaft.ID, inputGear.WantedRadius, inputGear.Z, inputGear.Phi, inputGear.R_base, inputGear.R_foot, inputGear.R_pitch, inputGear.R_top);
gta.Insert(outputGear.Name, outputGear.Alpha, outputGear.GearModule, outputGear.Material.ID, outputGear.Torque, outputGear.Shaft.ID, outputGear.WantedRadius, outputGear.Z, outputGear.Phi, outputGear.R_base, outputGear.R_foot, outputGear.R_pitch, outputGear.R_top);
inputGear.ID = (int)gta.getID(inputGear.Name, inputGear.Alpha, inputGear.GearModule, inputGear.Material.ID, inputGear.Torque, inputGear.Shaft.ID, inputGear.WantedRadius, inputGear.Z, inputGear.Phi, inputGear.R_base, inputGear.R_foot, inputGear.R_pitch, inputGear.R_top);
outputGear.ID = (int)gta.getID(outputGear.Name, outputGear.Alpha, outputGear.GearModule, outputGear.Material.ID, outputGear.Torque, outputGear.Shaft.ID, outputGear.WantedRadius, outputGear.Z, outputGear.Phi, outputGear.R_base, outputGear.R_foot, outputGear.R_pitch, outputGear.R_top);
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
gbta.Insert(gearBox.Name, gearBox.Alpha, gearBox.AxesDistance, gearBox.GearModule, gearBox.InputTorque, gearBox.OutputTorque, gearBox.TorqueRatio, gearBox.InputGear.ID, gearBox.OutputGear.ID);
gearBox.ID = (int)gbta.getID(gearBox.Name, gearBox.Alpha, gearBox.AxesDistance, gearBox.GearModule, gearBox.InputTorque, gearBox.OutputTorque, gearBox.TorqueRatio, gearBox.InputGear.ID, gearBox.OutputGear.ID);
Program.gearBoxList.Add(gearBox);
Program.gearList.Add(inputGear);
Program.gearList.Add(outputGear);
Program.shaftList.Add(inputGear.Shaft);
Program.shaftList.Add(outputGear.Shaft);
tsStatusLabel.Text = "Gear Box saved !";
}
public static void refreshGearBoxList()
{
Program.gearBoxList.Clear();
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
Database1DataSet1.GearBoxDataTable GearBoxFromDB = new Database1DataSet1.GearBoxDataTable();
gbta.Fill(GearBoxFromDB);
foreach (Database1DataSet1.GearBoxRow row in GearBoxFromDB)
{
GearBox gb = new GearBox();
gb.ID = row.ID;
gb.Name = row.GearBoxName;
gb.Alpha = row.Alpha;
gb.AxesDistance = row.AxesDistance;
gb.GearModule = row.GearModule;
gb.InputTorque = row.InputTorque;
gb.OutputTorque = row.OutputTorque;
gb.TorqueRatio = row.TorqueRatio;
gb.InputGear = Util.getGearById(row.InputGear);
gb.OutputGear = Util.getGearById(row.OutputGear);
Program.gearBoxList.Add(gb);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
// TODO: Save
GearBox gb = new GearBox();
gb.Name = txtName.Text;
gb.Alpha = Convert.ToDouble(numAlpha.Value);
gb.AxesDistance = Convert.ToDouble(numAxisDistance.Value);
gb.GearModule = Convert.ToDouble(numGearModule.Value);
gb.InputGear = inputGear;
gb.OutputGear = outputGear;
gb.OutputTorque = Convert.ToDouble(numOutputTorque.Value);
gb.InputTorque = Convert.ToDouble(numInputTorque.Value);
gb.TorqueRatio = Convert.ToDouble(numTorqueRatio.Value);
if (gb.Name != "" && gb.InputGear != null && gb.OutputGear != null)
{
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
gbta.Insert(gb.Name, gb.Alpha,gb.AxesDistance,gb.GearModule,gb.InputTorque, gb.OutputTorque, gb.TorqueRatio, gb.InputGear.ID, gb.OutputGear.ID);
gb.ID = (int)gbta.getID(gb.Name, gb.Alpha, gb.AxesDistance, gb.GearModule, gb.InputTorque, gb.OutputTorque, gb.TorqueRatio, gb.InputGear.ID, gb.OutputGear.ID);
Program.gearBoxList.Add(gb);
DialogResult = DialogResult.OK;
}
else
{
if (gb.Name == "")
MessageBox.Show("You have to add a Name to your gear box", "Impossible to save the gear box", MessageBoxButtons.OK, MessageBoxIcon.Warning);
else if (gb.InputGear == null)
MessageBox.Show("You have to add a Input Gear to your gear box", "Impossible to save the gear box", MessageBoxButtons.OK, MessageBoxIcon.Warning);
else
MessageBox.Show("You have to add a Output Gear to your gear box", "Impossible to save the gear box", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnRemove_Click_1(object sender, EventArgs e)
{
if (DialogResult.OK == MessageBox.Show("You may delete Gear Boxes associated. Do you want to continue ?", "Caution", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
{
if (listGear.SelectedItems.Count > 0)
{
Gear gearToDelete = new Gear();
gearToDelete = (Gear)listGear.SelectedItems[0];
Program.gearList.Remove(gearToDelete);
Database1DataSet1TableAdapters.GearsTableAdapter gta = new Database1DataSet1TableAdapters.GearsTableAdapter();
Database1DataSet1TableAdapters.GearBoxTableAdapter gbta = new Database1DataSet1TableAdapters.GearBoxTableAdapter();
try
{
gbta.DeleteInputGearQuery(gearToDelete.ID);
gbta.DeleteOutputGearQuery(gearToDelete.ID);
gta.Delete(gearToDelete.ID, gearToDelete.Name, gearToDelete.Alpha, gearToDelete.GearModule, gearToDelete.Material.ID, gearToDelete.Torque, gearToDelete.Shaft.ID, gearToDelete.WantedRadius, gearToDelete.Z, gearToDelete.Phi, gearToDelete.R_base, gearToDelete.R_foot, gearToDelete.R_pitch, gearToDelete.R_top);
Util.refreshGearBoxList();
}
catch (Exception ex) { }
}
refreshList();
propertyGridGear.SelectedObject = null;
btnRemove.Enabled = false;
btnEdit.Enabled = false;
btnSelect.Enabled = false;
}
}
