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