while (reader.Read())
     {
    BranchCode = reader.GetInt32(reader.GetOrdinal("branchcode")),
    BranchName = reader.GetStringOrNull(reader.GetOrdinal("branchname")),
    AuctionLane = reader.GetStringOrNull(reader.GetOrdinal("auctionlane")),
    Slot = reader.GetStringOrNull(reader.GetOrdinal("slot")).TrimStart('0'),
    ItemId = reader.GetDecimal(reader.GetOrdinal("itemid")),
    AuctionId = reader.GetDecimal(reader.GetOrdinal("auctionid")),
    StockNo = reader.GetStringOrNull(reader.GetOrdinal("stockno")),
     }