[Quantproject-developers] QuantDownloader/Downloader/TickerSelectors TickerGroupsListViewMenu.cs,1.3,1.4 TickerGroupsViewer.cs,1.4,1.5

[Marco M. <mi...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32422/Downloader/TickerSelectors

Modified Files:
	TickerGroupsListViewMenu.cs TickerGroupsViewer.cs 
Log Message:
Added methods for deletion of groups of tickers and single tickers inside a group 


Index: TickerGroupsViewer.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerGroupsViewer.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** TickerGroupsViewer.cs	27 Jun 2004 19:21:42 -0000	1.4
--- TickerGroupsViewer.cs	4 Aug 2004 23:07:01 -0000	1.5
***************
*** 38,42 ****
  	/// TickerGroupsViewer.
  	/// </summary>
! 	public class TickerGroupsViewer : System.Windows.Forms.Form, ITickerSelector, ITickerReceiver 
  	{
  		private OleDbConnection oleDbConnection = ConnectionProvider.OleDbConnection;
--- 38,43 ----
  	/// TickerGroupsViewer.
  	/// </summary>
! 	public class TickerGroupsViewer : System.Windows.Forms.Form,
!                                     ITickerSelector, ITickerReceiver, ITickerRemover 
  	{
  		private OleDbConnection oleDbConnection = ConnectionProvider.OleDbConnection;
***************
*** 163,171 ****
  										              string tickerDescription)
  		{
!       DataRow newRow = tableToFill.NewRow();
!       newRow["tiTicker"] = tickerID;
!       newRow["tiCompanyName"] = tickerDescription;
!       tableToFill.Rows.Add(newRow);
  		}
      // implementation of ITickerSelector interface
      public void SelectAllTickers()
--- 164,219 ----
  										              string tickerDescription)
  		{
!       try
!       {
!         DataRow newRow = tableToFill.NewRow();
!         newRow["tiTicker"] = tickerID;
!         newRow["tiCompanyName"] = tickerDescription;
!         tableToFill.Rows.Add(newRow);
!       }
!       catch(Exception ex)
!       {
!         string notUsed = ex.ToString();
!       }
  		}
+     
+     private void addTickerToTable(DataTable tableToFill, string tickerID)
+       
+     {
+       try
+       {
+         DataRow newRow = tableToFill.NewRow();
+         newRow["tiTicker"] = tickerID;
+         newRow["tiCompanyName"] = "-";
+         tableToFill.Rows.Add(newRow);
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+       }
+     }
+     
+     private void addTickersFromTableToTable(DataTable tableFrom, DataTable tableToFill)
+       
+     {
+       DataColumn[] columnPrimaryKeys = new DataColumn[1];
+       columnPrimaryKeys[0] = tableToFill.Columns[0];
+       tableToFill.PrimaryKey = columnPrimaryKeys;
+       
+       foreach(DataRow row in tableFrom.Rows)
+       {
+         try
+         {
+           DataRow newRow = tableToFill.NewRow();
+           newRow["tiTicker"] = (string)row[0];
+           newRow["tiCompanyName"] = "-";
+           tableToFill.Rows.Add(newRow);
+         }
+         catch(Exception ex)
+         {
+           string notUsed = ex.ToString();
+         }
+       }
+     }
+ 
      // implementation of ITickerSelector interface
      public void SelectAllTickers()
***************
*** 195,200 ****
  				// so it stands for a group of tickers
  				{
! 					///TODO: add method to retrieve 
!           MessageBox.Show("NOT IMPLEMENTED YET");  
  				}
  			}
--- 243,250 ----
  				// so it stands for a group of tickers
  				{
! 					TreeNode node = (TreeNode)item.Tag;
!           DataTable tickersInsideGroup = 
!             QuantProject.DataAccess.Tables.Tickers_tickerGroups.GetTickers((string)node.Tag);
!           this.addTickersFromTableToTable(tickersInsideGroup, tableOfSelectedTickers);  
  				}
  			}
***************
*** 202,205 ****
--- 252,291 ----
  		}
  
+     // implementation of ITickerRemover interface
+     public void RemoveTickers()
+     {
+       if(MessageBox.Show("Do you really want to delete the selected items?", 
+         "Confirm deletion", 
+         MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation)
+         == DialogResult.No)
+               return;
+       //update database
+       foreach(ListViewItem item in this.SelectedListViewItems)
+       {
+         if(item.Tag is System.String )
+         // the item contains in Tag property the ticker ID
+             Tickers_tickerGroups.Delete((string)item.Tag,
+                                        (string)this.treeViewGroups.SelectedNode.Tag);
+         else
+         // the item references to a node in the treeView :
+         // so it stands for a group of tickers
+           { 
+             TreeNode node = (TreeNode)item.Tag;
+             TickerGroups.DeleteGroup((string)node.Tag);
+             node.Remove();
+           }
+       }
+       
+       //update list view
+       for(int i = this.listViewGroupsAndTickers.SelectedItems.Count - 1;i>=0;
+                                         i=this.listViewGroupsAndTickers.SelectedItems.Count-1)
+       {
+         this.listViewGroupsAndTickers.SelectedItems[i].Remove();
+       }
+       //refresh
+       this.treeViewGroups.Refresh();
+       this.listViewGroupsAndTickers.Refresh();
+     }    
+ 
  		#region Windows Form Designer generated code
  		/// <summary>

Index: TickerGroupsListViewMenu.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerGroupsListViewMenu.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** TickerGroupsListViewMenu.cs	11 May 2004 22:06:41 -0000	1.3
--- TickerGroupsListViewMenu.cs	4 Aug 2004 23:07:01 -0000	1.4
***************
*** 54,58 ****
      private void removeSelectedItems(object sender, System.EventArgs e)
      {
!       //;
      }
      
--- 54,59 ----
      private void removeSelectedItems(object sender, System.EventArgs e)
      {
!       ITickerRemover iTickerRemover = (ITickerRemover)this.parentForm;
!       iTickerRemover.RemoveTickers();
      }