예제 #1
0
        /// <summary>
        /// This function adds a word to the currently active User's dictionary.
        /// accepts the word, weight, & user id to attach word to correct user.
        /// </summary>
        /// <param name="word">Word to be added to the dictionary.</param>
        /// <param name="value">Weight of the word being added to the dictionary</param>
        /// <param name="user_id">ID of the current user to add to correct dictionary</param>
        /// <returns>Returns true if word was successfully added</returns>
        public bool addwordDictionary(string word, int value, int user_id)
        {
            bool success = false;

            using (var db = new stock_advisorDataContext(Program.ConnectionString))
            {
                DICTIONARY search = (from p in db.DICTIONARies
                                     where p.User_id == user_id && p.Word == word
                                     select p).FirstOrDefault();

                if (search == null)                 //record doesn't exist
                {
                    //create user_info object w/params
                    var newEntry = new DICTIONARY()
                    {
                        User_id = user_id,
                        Word    = word,
                        Weight  = value
                    };

                    db.DICTIONARies.InsertOnSubmit(newEntry);

                    try
                    {
                        db.SubmitChanges();                         //execute insert
                        //verify that was successfully inserted
                        var added = db.DICTIONARies.SingleOrDefault(a => a.Word == word && a.User_id == user_id);
                        if (added != null)
                        {
                            success = true;
                        }
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine("Exception caught during word creation/insert:\n");
                        Console.WriteLine(e.Message);
                    }
                }
                else                    //record exists already
                {
                    success = false;
                }
            }
            return(success);
        }
예제 #2
0
        /// <summary>
        /// This function removes a word from the currently active User's dictionary.
        /// accepts the word & user id to remove word from the correct user.
        /// </summary>
        /// <param name="wordToDelete">Word to be added to the dictionary.</param>
        /// <param name="user_id">ID of the current user to remove word from correct dictionary</param>
        /// <returns>Returns true if word was successfully removed</returns>
        public bool deleteWordDictionary(string wordToDelete, int user_id)
        {
            bool deleted = false;

            using (var db = new stock_advisorDataContext(Program.ConnectionString))
            {
                //find word to delete
                DICTIONARY delWord = (from p in db.DICTIONARies
                                      where p.User_id == user_id && p.Word == wordToDelete
                                      select p).FirstOrDefault();
                if (delWord != null)
                {
                    db.DICTIONARies.DeleteOnSubmit(delWord);
                    db.SubmitChanges();
                    deleted = true;
                }
            }
            return(deleted);
        }
예제 #3
0
        /// <summary>
        /// This function modifies a word entry in the database, changing the old word's
        /// weight value to the input weight.
        /// </summary>
        /// <param name="word">This is the word to be edited in the dictionary</param>
        /// <param name="newWeight">This is the new weight of the word being edited</param>
        /// <param name="user_id">This is the id of the user who's dictionary is being edited</param>
        /// <returns>true if weight modification was successful</returns>
        public bool modifyWeightDictionary(string word, int newWeight, int user_id)
        {
            bool modified = false;

            using (var db = new stock_advisorDataContext(Program.ConnectionString))
            {
                DICTIONARY search = (from p in db.DICTIONARies
                                     where p.User_id == user_id && p.Word == word
                                     select p).FirstOrDefault();

                if (search != null)                 //record does exist
                {
                    //create user_info object w/params
                    var newEntry = new DICTIONARY()
                    {
                        User_id = user_id,
                        Word    = word,
                        Weight  = newWeight
                    };

                    db.DICTIONARies.DeleteOnSubmit(search);                     //delete old word
                    db.DICTIONARies.InsertOnSubmit(newEntry);

                    try
                    {
                        db.SubmitChanges();                         //execute insert
                        //verify that was successfully inserted
                        var added = db.DICTIONARies.SingleOrDefault(a => a.Word == word && a.Weight == newWeight && a.User_id == user_id);
                        if (added != null)
                        {
                            modified = true;
                        }
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine("Exception caught during word update:\n");
                        Console.WriteLine(e.Message);
                    }
                }
            }
            return(modified);
        }
 private void detach_DICTIONARies(DICTIONARY entity)
 {
     this.SendPropertyChanging();
     entity.USER_INFO = null;
 }
 partial void DeleteDICTIONARY(DICTIONARY instance);
 partial void UpdateDICTIONARY(DICTIONARY instance);
 partial void InsertDICTIONARY(DICTIONARY instance);