[Quantproject-developers] QuantProject/b2_DataAccess/Tables Bars.cs, 1.7, 1.8

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv3450/b2_DataAccess/Tables

Modified Files:
	Bars.cs 
Log Message:
Fixed bugs in GetOpen and GetClose methods

Index: Bars.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Bars.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** Bars.cs	14 Jan 2009 23:36:27 -0000	1.7
--- Bars.cs	5 Feb 2009 22:11:54 -0000	1.8
***************
*** 130,134 ****
  		/// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param>
  		/// <returns></returns>
! 		public static float GetClose( string ticker, DateTime dateTime, int intervalFrameInSeconds )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
--- 130,134 ----
  		/// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param>
  		/// <returns></returns>
! 		public static double GetClose( string ticker, DateTime dateTime, int intervalFrameInSeconds )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
***************
*** 136,141 ****
  				"where " + Bars.TickerFieldName + "='" + ticker + "' and " +
  				Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " +
! 				"and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateConstant(dateTime) );
! 			return (float)dataTable.Rows[0][0];
  		}
  		/// <summary>
--- 136,141 ----
  				"where " + Bars.TickerFieldName + "='" + ticker + "' and " +
  				Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " +
! 				"and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateTimeConstant(dateTime) );
! 			return (double)dataTable.Rows[0][0];
  		}
  		/// <summary>
***************
*** 146,150 ****
  		/// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param>
  		/// <returns></returns>
! 		public static float GetOpen( string ticker, DateTime dateTime, int intervalFrameInSeconds )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
--- 146,150 ----
  		/// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param>
  		/// <returns></returns>
! 		public static double GetOpen( string ticker, DateTime dateTime, int intervalFrameInSeconds )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
***************
*** 152,157 ****
  				"where " + Bars.TickerFieldName + "='" + ticker + "' and " +
  				Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " +
! 				"and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateConstant(dateTime) );
! 			return (float)dataTable.Rows[0][0];
  		}
  		
--- 152,157 ----
  				"where " + Bars.TickerFieldName + "='" + ticker + "' and " +
  				Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " +
! 				"and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateTimeConstant(dateTime) );
! 			return (double)dataTable.Rows[0][0];
  		}