[Quantproject-developers] QuantProject/b2_DataAccess/Tables VisuallyValidatedTickers.cs,1.1,1.2

[Glauco S. <gla...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22134/b2_DataAccess/Tables

Modified Files:
	VisuallyValidatedTickers.cs 
Log Message:
Updated, but it is going to be removed, because the
visuallyValidatedTickers table has been removed
from the database

Index: VisuallyValidatedTickers.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/VisuallyValidatedTickers.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** VisuallyValidatedTickers.cs	21 Mar 2004 16:09:38 -0000	1.1
--- VisuallyValidatedTickers.cs	28 Mar 2004 19:45:23 -0000	1.2
***************
*** 1,4 ****
--- 1,5 ----
  using System;
  using System.Data;
+ using QuantProject.ADT;
  using QuantProject.DataAccess;
  
***************
*** 31,37 ****
  			try
  			{
  				OleDbSingleTableAdapter oleDbSingleTableAdapter =
  					new OleDbSingleTableAdapter( "select * from visuallyValidatedTickers where vvTicker='" + ticker + "'" );
! 				string hashValue = Quotes.GetHashValue( ticker ); 
  				if ( oleDbSingleTableAdapter.DataTable.Rows.Count == 0 )
  					// this ticker was not visually validated yet
--- 32,39 ----
  			try
  			{
+ 				Quotes quotes = new Quotes( ticker );
  				OleDbSingleTableAdapter oleDbSingleTableAdapter =
  					new OleDbSingleTableAdapter( "select * from visuallyValidatedTickers where vvTicker='" + ticker + "'" );
! 				string hashValue = quotes.GetHashValue(); 
  				if ( oleDbSingleTableAdapter.DataTable.Rows.Count == 0 )
  					// this ticker was not visually validated yet
***************
*** 41,47 ****
  					( (string)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] != hashValue ) )
  					// this ticker was visually already validated, but with different values
! 					oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvRangeToRangeRatio" ] = true;
  				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = ticker;
! 					oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvStartDate" ] =
  					Quotes.GetStartDate( ticker );
  				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] =
--- 43,49 ----
  					( (string)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] != hashValue ) )
  					// this ticker was visually already validated, but with different values
! 					oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvRangeToRangeRatio" ] = false;
  				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = ticker;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvStartDate" ] =
  					Quotes.GetStartDate( ticker );
  				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] =
***************
*** 57,60 ****
--- 59,101 ----
  			}
  		}
+ 		/// <summary>
+ 		/// Writes to the database the visual validation of the Range to Range suspicious ratios
+ 		/// </summary>
+ 		/// <param name="ticker">ticker to be validated</param>
+ 		/// <param name="ticker">quoteDate to be validated</param>
+ 		public static void ValidateRangeToRange( string ticker , DateTime quoteDate)
+ 		{
+ 			try
+ 			{
+ 				Quotes quotes = new Quotes( ticker );
+ 				OleDbSingleTableAdapter oleDbSingleTableAdapter =
+ 					new OleDbSingleTableAdapter( "select * from visuallyValidatedTickers where vvTicker='"
+ 						+ ticker + "'" );
+ 				string hashValue = quotes.GetHashValue(
+ 					quotes.GetPrecedingDate( quoteDate , ConstantsProvider.PrecedingDaysForVisualValidation ) ,
+ 					quotes.GetFollowingDate( quoteDate , ConstantsProvider.PrecedingDaysForVisualValidation ) );
+ 				if ( oleDbSingleTableAdapter.DataTable.Rows.Count == 0 )
+ 					// this ticker was not visually validated yet
+ 					oleDbSingleTableAdapter.DataTable.Rows.Add( oleDbSingleTableAdapter.DataTable.NewRow() );
+ 				else if ( ( (DateTime)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] != Quotes.GetEndDate( ticker ) ) ||
+ 					( (DateTime)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] !=	Quotes.GetEndDate( ticker ) ) ||
+ 					( (string)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] != hashValue ) )
+ 					// this ticker was visually already validated, but with different values
+ 					oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvCloseToCloseRatio" ] = false;
+ 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = ticker;
+ 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvStartDate" ] =
+ 					Quotes.GetStartDate( ticker );
+ 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] =
+ 					Quotes.GetEndDate( ticker );
+ 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] = hashValue;
+ 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvRangeToRangeRatio" ] = true;
+ 				oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable );
+ 			}
+ 			catch ( Exception ex )
+ 			{
+ 				string exceptionMessage = ex.Message + "\n" + ex.StackTrace;
+ 				Console.WriteLine( exceptionMessage );
+ 			}
+ 		}
  	}
  }