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

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

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

Added Files:
	VisuallyValidatedTickers.cs 
Log Message:
Class to access the VisuallyValidatedTickers table

--- NEW FILE: VisuallyValidatedTickers.cs ---
using System;
using System.Data;
using QuantProject.DataAccess;

namespace QuantProject.DataAccess.Tables
{
	/// <summary>
	/// Class to access the VisuallyValidatedTickers table
	/// </summary>
	public class VisuallyValidatedTickers
	{
		private string ticker;

		public string Ticker
		{
			get { return this.ticker; }
			set { this.ticker = value; }
		}
		public VisuallyValidatedTickers()
		{
			//
			// TODO: Add constructor logic here
			//
		}
		/// <summary>
		/// writes to the database the visual validation of the Close to Close suspicious ratios
		/// </summary>
		/// <param name="ticker">ticker to be validated</param>
		public static void ValidateCloseToClose( string ticker )
		{
			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
					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 ][ "vvRangeToRangeRatio" ] = true;
				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 ][ "vvCloseToCloseRatio" ] = true;
				oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable );
			}
			catch ( Exception ex )
			{
				string exceptionMessage = ex.Message + "\n" + ex.StackTrace;
				Console.WriteLine( exceptionMessage );
			}
		}
	}
}