public static List<EquipmentType> GetEquipmentTypes() { List<EquipmentType> equipmentTypes = new List<EquipmentType>(); DBGateway aGateway = new DBGateway(); string queryType = "select * from equipmnttype"; DataSet ctDataSet = aGateway.Select(queryType); foreach (DataRow dataRow in ctDataSet.Tables[0].Rows) { TelephoneComplainType aType = new TelephoneComplainType(); EquipmentType aEquipmentType = new EquipmentType(); aEquipmentType.TypeID = (int)dataRow["Id"]; aEquipmentType.Name = dataRow["TypeName"].ToString(); equipmentTypes.Add(aEquipmentType); } return equipmentTypes; }
public static List<EquipmentType> GEtEquipmentTypes() { DBGateway aGateway = new DBGateway(); //List<EquipmentType> aList=new List<EquipmentType>(); string query1 = "select * from equipmnttype"; List<EquipmentType> aList = new List<EquipmentType>(); DataSet aDataSet = aGateway.Select(query1); foreach (DataRow dataRow in aDataSet.Tables[0].Rows) { EquipmentType aTypeList = new EquipmentType(); aTypeList.TypeID = (int)dataRow["Id"]; aTypeList.Name = dataRow["TypeName"].ToString(); aList.Add(aTypeList); } return aList; }