Example #1
0
        public bool InsertRow(RowWithCategoryInfo rwci)
        {
            bool updated = false;

            try
            {
//				MPBDataSet.PhrasebookRow newRow = PhrasebookDataTable.AddPhrasebookRow( rwci.Row._english, rwci.Row._language );
                string _english  = rwci.Row._english;
                string _language = rwci.Row._language;

                rwci.Row._id = this.phrasebookTableAdapter.Insert(rwci.Row._english, rwci.Row._language);
                this.phrasebookTableAdapter.Update(MyDataSet);
                CommitChanges();

//				newRow = PhrasebookDataTable.Select( string.Format( "_english LIKE '{0}' AND _language LIKE '{1}'", _english, _language ) )[ 0 ] as MPBDataSet.PhrasebookRow;
//				RowWithCategoryInfo newRWCI = new RowWithCategoryInfo( newRow );

//				UpdateRow( newRWCI );
                UpdateRow(rwci);

                updated = true;
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            return(updated);
        }
Example #2
0
        public void UpdateRow(RowWithCategoryInfo rwci)
        {
            DeleteRowFromCat2Phrase(rwci.Row);

            rwci.CatID2CheckboxMap[0] = true;                   // This is the "All" category which every record should have.

            // Add Cat2Phrase lines
            foreach (KeyValuePair <long, bool> kvp in rwci.CatID2CheckboxMap)
            {
                if (kvp.Value == true)
                {
                    long _catID    = kvp.Key;
                    long _phraseID = rwci.Row._id;
                    cat2PhraseTableAdapter.Insert(_catID, _phraseID);
                }
            }

            // Now update the database with any changes that occurred on rwci.Row
            this.cat2PhraseTableAdapter.Update(MyDataSet);
            CommitChanges();

            DataRow[] c2pRows    = MyDataSet.Cat2Phrase.Select("_phraseID = 0");
            DataRow[] categories = DBWrapper.Instance.Cat2PhraseDataTable.Select(string.Format("_phraseID = {0}", rwci.Row._id));
        }