public static List<int> listOfShaftIds(int materialID, Database1DataSet1TableAdapters.Shaft1TableAdapter sta) { List<int> shaftIds = new List<int>(); Database1DataSet1.Shaft1DataTable shaftTable = new Database1DataSet1.Shaft1DataTable(); shaftTable = sta.GetDataByMaterialID(materialID); foreach (Database1DataSet1.Shaft1Row row in shaftTable) { int id = row.ID; shaftIds.Add(id); } return shaftIds; }
public static List<int> listOfGearIds(int materialID, List<int> shaftIds, Database1DataSet1TableAdapters.GearsTableAdapter gta) { List<int> gearIds = new List<int>(); Database1DataSet1.GearsDataTable gearTable = new Database1DataSet1.GearsDataTable(); // beacause of the Material gearTable = gta.GetDataByMaterialID(materialID); foreach (Database1DataSet1.GearsRow row in gearTable) { int id = row.ID; gearIds.Add(id); } // because of the shaft foreach (int shaft in shaftIds) { gearTable = gta.GetDataByShaftID(shaft); foreach (Database1DataSet1.GearsRow row in gearTable) { int id = row.ID; gearIds.Add(id); } } return gearIds; }
public static List<int> listOfGearIds(int shaftIds, Database1DataSet1TableAdapters.GearsTableAdapter gta) { List<int> gearIds = new List<int>(); Database1DataSet1.GearsDataTable gearTable = new Database1DataSet1.GearsDataTable(); gearTable = gta.GetDataByShaftID(shaftIds); foreach (Database1DataSet1.GearsRow row in gearTable) { int id = row.ID; gearIds.Add(id); } return gearIds; }