Пример #1
0
        //------------------------------------------
        /// <summary>
        /// Converts the Country object properties to SQL paramters and executes the create Country procedure
        /// and updates the Country object with the SQL data by reference.
        /// <example>[Example]bool result=CountrySqlDataPrvider.Instance.Create(country);.</example>
        /// </summary>
        /// <param name="country">The Country object.</param>
        /// <returns>The result of create query.</returns>
        public bool Create(CountryEntity country)
        {
            bool result = false;

            using (SqlConnection myConnection = GetSqlConnection())
            {
                SqlCommand myCommand = new SqlCommand("Country_Create", myConnection);
                myCommand.CommandType = CommandType.StoredProcedure;
                // Set the parameters
                myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Direction       = ParameterDirection.Output;
                myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value   = country.Name;
                myCommand.Parameters.Add("@EnName", SqlDbType.NVarChar, 50).Value = country.EnName;
                myCommand.Parameters.Add("@Short", SqlDbType.Char, 5).Value       = country.Short;
                // Execute the command
                myConnection.Open();
                if (myCommand.ExecuteNonQuery() > 0)
                {
                    result = true;
                    //Get ID value from database and set it in object
                    country.ID = (int)myCommand.Parameters["@ID"].Value;
                }
                myConnection.Close();
                return(result);
            }
        }
Пример #2
0
        //------------------------------------------
        /// <summary>
        /// Populates Country Entity From IDataReader .
        /// <example>[Example]CountryEntitycountry=PopulateCountryEntityFromIDataReader(reader);.</example>
        /// </summary>
        /// <param name="reader"></param>
        /// <returns>Country object.</returns>
        private CountryEntity PopulateCountryEntityFromIDataReader(IDataReader reader)
        {
            //Create a new Country object
            CountryEntity country = new CountryEntity();

            //Fill the object with data
            if (reader["ID"] != DBNull.Value)
            {
                country.ID = (int)reader["ID"];
            }
            if (reader["Name"] != DBNull.Value)
            {
                country.Name = (string)reader["Name"];
            }
            if (reader["EnName"] != DBNull.Value)
            {
                country.EnName = (string)reader["EnName"];
            }
            if (reader["Short"] != DBNull.Value)
            {
                country.Short = (string)reader["Short"];
            }
            if (reader["ContID"] != DBNull.Value)
            {
                country.ContID = (int)reader["ContID"];
            }
            //Return the populated object
            return(country);
        }
Пример #3
0
        //------------------------------------------
        /// <summary>
        /// Converts the Country object properties to SQL paramters and executes the update Country procedure.
        /// <example>[Example]bool result=CountrySqlDataPrvider.Instance.Update(country);.</example>
        /// </summary>
        /// <param name="country">The Country object.</param>
        /// <returns>The result of update query.</returns>
        public bool Update(CountryEntity country)
        {
            bool result = false;

            using (SqlConnection myConnection = GetSqlConnection())
            {
                SqlCommand myCommand = new SqlCommand("Country_Update", myConnection);
                myCommand.CommandType = CommandType.StoredProcedure;
                // Set the parameters
                myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Value           = country.ID;
                myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value   = country.Name;
                myCommand.Parameters.Add("@EnName", SqlDbType.NVarChar, 50).Value = country.EnName;
                myCommand.Parameters.Add("@Short", SqlDbType.Char, 5).Value       = country.Short;
                // Execute the command
                myConnection.Open();
                if (myCommand.ExecuteNonQuery() > 0)
                {
                    result = true;
                }
                myConnection.Close();
                return(result);
            }
        }
Пример #4
0
        //------------------------------------------
        /// <summary>
        /// Gets single Country object .
        /// <example>[Example]CountryEntitycountry=CountrySqlDataPrvider.Instance.GetCountryObject(id);.</example>
        /// </summary>
        /// <param name="id">The country id.</param>
        /// <returns>Country object.</returns>
        public CountryEntity GetCountryObject(int id)
        {
            CountryEntity country = null;

            using (SqlConnection myConnection = GetSqlConnection())
            {
                SqlCommand myCommand = new SqlCommand("Country_GetOneByID", myConnection);
                myCommand.CommandType = CommandType.StoredProcedure;
                // Set the parameters
                myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Value = id;
                // Execute the command
                myConnection.Open();
                using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (dr.Read())
                    {
                        country = PopulateCountryEntityFromIDataReader(dr);
                    }
                    dr.Close();
                }
                myConnection.Close();
                return(country);
            }
        }
Пример #5
0
 //------------------------------------------
 /// <summary>
 /// Updates Country object by calling Country data provider update method.
 /// <example>[Example]bool result=CountryFactory.Update(country);.</example>
 /// </summary>
 /// <param name="country">The Country object.</param>
 /// <returns>The result of update operation.</returns>
 public static bool Update(CountryEntity country)
 {
     return(CountrySqlDataPrvider.Instance.Update(country));
 }