示例#1
0
        public List <JoinedTransfer> GetTransfers()

        {
            List <JoinedTransfer> transferDetails = new List <JoinedTransfer>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    SqlCommand cmd = new SqlCommand(sqlGetTransferDetailsJoined, conn);

                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        JoinedTransfer temp = JoinedTransferFromReader(reader);
                        transferDetails.Add(temp);
                    }
                }
            }
            catch (SqlException ex)
            {
                return(transferDetails);
            }

            return(transferDetails);
        }
示例#2
0
        public void GetTransferById(int inputTransferId)
        {
            List <JoinedTransfer> allTransfers = transferAPI.GetTransfers();
            JoinedTransfer        requested    = new JoinedTransfer();

            foreach (JoinedTransfer transfers in allTransfers)
            {
                if (transfers.TransferId == inputTransferId && (transfers.FromId == authService.userId || transfers.ToId == authService.userId))
                {
                    requested = transfers;
                }
                else
                {
                }
            }

            if (requested.TransferId == 0)
            {
                Console.WriteLine("Sorry, that's not a valid transfer ID.");
            }
            else
            {
                Console.WriteLine(requested);
            }
        }