Exemplo n.º 1
0
        public static PaymentTran GetItemByRefNbr(String RefNbr)
        {
            PaymentTran item      = new PaymentTran();
            var         sqlParams = new SqlParameter[1];

            sqlParams[0] = new SqlParameter("@RefNbr", RefNbr);
            using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetByRefNbr", sqlParams))
            {
                while (reader.Read())
                {
                    item = GetItemFromReader(reader);
                }
            }
            return(item);
        }
Exemplo n.º 2
0
        private static PaymentTran GetItemFromReader(IDataReader dataReader)
        {
            PaymentTran objItem = new PaymentTran();

            objItem.RefNbr = SqlHelper.GetString(dataReader, "RefNbr");

            objItem.PayAmount = SqlHelper.GetDecimal(dataReader, "PayAmount");


            objItem.CuryId = SqlHelper.GetString(dataReader, "CuryId");

            objItem.PayDate = SqlHelper.GetDateTime(dataReader, "PayDate");


            objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");

            return(objItem);
        }