示例#1
0
        public static List<Deals> GrabLatestDeals(bool newdealsonly)
        {
            // sp_getnewdeals

            MySqlConnection conn = new MySqlConnection(connStr);
            MySqlCommand cmd = conn.CreateCommand();
            MySqlDataReader dr = null;
            cmd.CommandType = System.Data.CommandType.StoredProcedure;

            List<Deals> tmpList = new List<Deals>();

            try
            {
                cmd.CommandText = "sp_getnewdeals";
                cmd.Parameters.AddWithValue("@newdealsonly",newdealsonly);
                conn.Open();
                cmd.CommandTimeout = 60; // increase timeout to 60, just in case of busy or locking
                dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    Deals tmpModel = new Deals();

                    tmpModel.dealsID = (int)dr["dealsID"];
                    tmpModel.Title = (string)dr["Title"];
                    tmpModel.URL = (string)dr["URL"];
                    tmpModel.Ishot = (bool)dr["Ishot"];

                    tmpList.Add(tmpModel);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                conn.Close();
                if (dr != null) dr.Dispose();
                cmd.Dispose();
            }

            return tmpList;
        }
示例#2
0
        // improve 1. sequence, 2. timestamp after link
        // the hot deal icon for now...
        // http://freebiesdealsandrewards.com/forum/images/icons/hot-deal.png
        //
        private string MakeUp(Deals tmpdeal,string keywords)
        {
            string andsplit = "~^~";
            string exlcudesplit = "!^!";
            string[] splitarray = { andsplit, exlcudesplit };

            // grab the deal, and format it...
            string tmptitle = tmpdeal.Title;
            string[] keys = keywords.Split(',');

            foreach(string key in keys)   // todo: && || keyword, need split again.....
            {
                if (key.Contains(andsplit) || key.Contains(exlcudesplit))
                {
                    string[] subkeys = key.Split(splitarray, StringSplitOptions.RemoveEmptyEntries);
                    foreach (string subkey in subkeys)
                    {
                        if (!key.Contains(exlcudesplit + subkey))
                        {
                            //tmptitle = tmptitle.Replace(subkey, "<span style='background-color:Yellow'><b><u>" + subkey + "</u></b></span>");
                            tmptitle = ReplaceEx(tmptitle, subkey, "<span style='background-color:Yellow'><b><u>" + subkey.ToUpper() + "</u></b></span>");
                        }
                    }
                }
                else
                    tmptitle = ReplaceEx(tmptitle, key, "<span style='background-color:Yellow'><b><u>" + key.ToUpper() + "</u></b></span>");
                    //tmptitle = tmptitle.Replace(key, "<span style='background-color:Yellow'><b><u>" + key + "</u></b></span>");
            }

            string ishot = tmpdeal.Ishot ? "<img src='http://freebiesdealsandrewards.com/forum/images/icons/hot-deal.png' alt='Hot Deal' border='0' />" : "";

            string content = "<div ><a href='" + tmpdeal.URL + "'>" + tmptitle + "</a>" + ishot + "</div><i> (" + tmpdeal.InDate.ToString() + ")</i><br/><br/>";

            Console.ForegroundColor = ConsoleColor.DarkYellow;
            Console.WriteLine(tmpdeal.Title.ToLower());
            return content;
        }
示例#3
0
        public static Deals GetOneDeal(int dealid)
        {
            MySqlConnection conn = new MySqlConnection(connStr);
            MySqlCommand cmd = conn.CreateCommand();
            cmd.CommandType = System.Data.CommandType.Text;

            MySqlDataReader dr = null;
            Deals tmpModel = new Deals();
            try
            {
                cmd.CommandText = "select * from rssdeals where dealsid =" + dealid;
                conn.Open();
                cmd.CommandTimeout = 60; // increase timeout to 60, just in case of busy or locking
                dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    tmpModel.PubDate = (string)dr["PubDate"];
                    tmpModel.dealsID = (int)dr["dealsID"];
                    tmpModel.URL = (string)dr["URL"];
                    tmpModel.Title = (string)dr["Title"];
                    tmpModel.InDate = (DateTime)dr["inTime"];
                    tmpModel.IsDrug = (bool)dr["IsDrug"];
                    tmpModel.IsFinance = (bool)dr["IsFinance"];
                    //tmpModel.IsFree = (bool)dr["IsFree"];
                    tmpModel.Ishot = (bool)dr["Ishot"];
                    tmpModel.IsTravel = (bool)dr["IsTravel"];
                    tmpModel.IsElectronic = (bool)dr["IsElectronic"];
                    tmpModel.IsAppeal = (bool)dr["IsAppeal"];
                    tmpModel.IsAppliances = (bool)dr["IsAppliances"];
                    tmpModel.IsBeauty = (bool)dr["IsBeauty"];
                    tmpModel.IsJewelry = (bool)dr["IsJewelry"];
                    tmpModel.IsOfficeSupplies = (bool)dr["IsOfficeSupplies"];
                    tmpModel.IsRestaurant = (bool)dr["IsRestaurant"];
                    tmpModel.IsOthers = (bool)dr["IsOthers"];
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                conn.Close();
                if (dr != null) dr.Dispose();
                cmd.Dispose();
            }

            return tmpModel;
        }