Example #1
0
        public EbayStore GetEbayStore(string storeType)
        {
            EbayStore    s            = new EbayStore();
            DataSet      ds           = new DataSet();
            DataTable    dt           = new DataTable();
            ArrayList    storeDetails = new ArrayList();
            string       cmdStr       = "SELECT * FROM ebay_details WHERE type='" + storeType + "'";
            MySqlCommand command      = new MySqlCommand(cmdStr, connection);

            ds = GetMultipleQuery(command);
            try
            {
                dt = ds.Tables[0];
            }
            catch { }
            DataRow dr = dt.Rows[0];

            for (int i = 0; i < dt.Columns.Count; i++)
            {
                storeDetails.Add(dr[i]);
            }

            s.Type          = storeDetails[0].ToString();
            s.Listings      = Convert.ToInt32(storeDetails[1]);
            s.MonthlyPrice  = Convert.ToDouble(storeDetails[2]);
            s.InsertionFee  = Convert.ToInt32(storeDetails[3]);
            s.FinalValueFee = Convert.ToDouble(storeDetails[4]);
            s.InsertionFee  = Convert.ToDouble(storeDetails[5]);

            return(s);
        }
Example #2
0
        //retrive eBay store type and fees
        public EbayStore GetStoreDetails(string storeType)
        {
            EbayStore store  = new EbayStore();
            string    cmdStr = "SELECT * FROM ebay WHERE type=@storeType";

            using (OleDbCommand command = new OleDbCommand(cmdStr))
            {
                command.Parameters.AddWithValue("@storeType", storeType);
                base.ExecuteStoreQuery(command);
            }
            return(store);
        }
Example #3
0
        //submiting a qery with an argument and returning an EbayStore
        protected EbayStore ExecuteStoreQuery(OleDbCommand command)
        {
            EbayStore store = new EbayStore();

            lock (_conn)
            {
                Connect();
                command.Connection = _conn;
                try
                {
                    // calling a query that returns the store details
                    store = (EbayStore)command.ExecuteScalar();
                }
                finally
                {
                    Disconnect();
                }
                return(store);
            }
        }