Exemple #1
0
        /// <summary>
        /// Creates a new instance of the Sac_Money class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sac_Money MakeSac_Money(SqlDataReader dataReader)
        {
            Sac_Money sac_Money = new Sac_Money();

            sac_Money.MoneyID     = SqlClientUtility.GetInt32(dataReader, "MoneyID", 0);
            sac_Money.Name        = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
            sac_Money.TypeID      = SqlClientUtility.GetByte(dataReader, "TypeID", 0x00);
            sac_Money.DollarValue = SqlClientUtility.GetDecimal(dataReader, "DollarValue", Decimal.Zero);
            sac_Money.CountryCode = SqlClientUtility.GetString(dataReader, "CountryCode", String.Empty);

            return(sac_Money);
        }
Exemple #2
0
        /// <summary>
        /// Saves a record to the Sac_Money table.
        /// </summary>
        public virtual void Insert(Sac_Money sac_Money)
        {
            ValidationUtility.ValidateArgument("sac_Money", sac_Money);

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@Name", sac_Money.Name),
                new SqlParameter("@TypeID", sac_Money.TypeID),
                new SqlParameter("@DollarValue", sac_Money.DollarValue),
                new SqlParameter("@CountryCode", sac_Money.CountryCode)
            };

            sac_Money.MoneyID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Sac_Money_Insert", parameters);
        }
Exemple #3
0
        /// <summary>
        /// Selects all records from the Sac_Money table.
        /// </summary>
        public virtual List <Sac_Money> SelectAll()
        {
            using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sac_Money_SelectAll"))
            {
                List <Sac_Money> sac_MoneyList = new List <Sac_Money>();
                while (dataReader.Read())
                {
                    Sac_Money sac_Money = MakeSac_Money(dataReader);
                    sac_MoneyList.Add(sac_Money);
                }

                return(sac_MoneyList);
            }
        }
Exemple #4
0
        /// <summary>
        /// Selects all records from the Sac_Money table by a foreign key.
        /// </summary>
        public virtual List <Sac_Money> _SelectAllByTypeID(string countryCode, int typeID)
        {
            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@CountryCode", countryCode),
                new SqlParameter("@TypeID", typeID)
            };

            using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sac_Money_SelectAllByTypeID", parameters))
            {
                List <Sac_Money> sac_MoneyList = new List <Sac_Money>();
                while (dataReader.Read())
                {
                    Sac_Money sac_Money = MakeSac_Money(dataReader);
                    sac_MoneyList.Add(sac_Money);
                }

                return(sac_MoneyList);
            }
        }