public static List <cEquipment> RetrieveEquipment(retrieveEquipmentData type)
{
List <ParamStruct> paramiters = new List <ParamStruct>();
paramiters.Add(new ParamStruct("@retriveType", type, DbType.Int32, 4, ParameterDirection.Input));
DbDataReader reader = DAL.DAL.ReadData("retrieveEqipmentData", paramiters);
return(Repackager(reader, type));
}
private static List <cEquipment> Repackager(DbDataReader reader, retrieveEquipmentData type)
{
List <cEquipment> EquipList = new List <cEquipment>();
while (reader.Read())
{
cEquipment equip = cEquipment.Create();
equip.trustedSource = true;
switch (type)
{
case retrieveEquipmentData.getEquipmentIdSerial:
{
equip.EquipId = Convert.ToInt32(reader["equipmentId"]);
equip.Serial = reader["serial"].ToString();
break;
}
case retrieveEquipmentData.getEquipmentById:
case retrieveEquipmentData.getEquipmentByCategory:
case retrieveEquipmentData.getEquipmentDetail:
case retrieveEquipmentData.getEquipmentExcludNotAvail:
{
equip.EquipId = Convert.ToInt32(reader["equipmentId"]);
equip.Serial = reader["serial"].ToString();
equip.RentPrice = Convert.ToDecimal(reader["rentPrice"]);
equip.ListPrice = Convert.ToDecimal(reader["listPrice"]);
equip.Status = (StatusTypes)reader["availStatus"];
if (reader["dateOut"] != DBNull.Value)
{
equip.DateOut = Convert.ToDateTime(reader["dateOut"]);
}
if (reader["dateIn"] != DBNull.Value)
{
equip.DateIn = Convert.ToDateTime(reader["dateIn"]);
}
equip.Category = (EquipmentTypes)reader["category"];
break;
}
}
equip.trustedSource = false;
EquipList.Add(equip);
}
return(EquipList);
}
public static List <cEquipment> Retreive(retrieveEquipmentData type)
{
return(cEquipmentSQL.RetrieveEquipment(type));
}
public List <cEquipment> GetEquipmentList(retrieveEquipmentData type)
{
List <cEquipment> Equips = new List <cEquipment>();
return(Equips);
}
