[Quantproject-developers] QuantProject/b2_DataAccess/Tables Quotes.cs, 1.29, 1.30

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

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

Modified Files:
	Quotes.cs 
Log Message:
- the public static method GetFirstQuoteDate replaces the previous GetStartDate method (the implementation is more efficient now)
- the public static method GetLastQuoteDate replaces the previous GetEndDate method 

Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.29
retrieving revision 1.30
diff -C2 -d -r1.29 -r1.30
*** Quotes.cs	18 Jun 2006 14:19:44 -0000	1.29
--- Quotes.cs	22 Jul 2006 20:52:44 -0000	1.30
***************
*** 61,70 ****
  		/// <param name="ticker">ticker for which the starting date has to be returned</param>
  		/// <returns></returns>
! 		public static DateTime GetStartDate( string ticker )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
! 				"select * from quotes where quTicker='" + ticker + "' " +
! 				"order by quDate");
! 			return (DateTime)(dataTable.Rows[ 0 ][ "quDate" ]);
  		}
  		/// <summary>
--- 61,70 ----
  		/// <param name="ticker">ticker for which the starting date has to be returned</param>
  		/// <returns></returns>
! 		public static DateTime GetFirstQuoteDate( string ticker )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
! 				"select min(quDate) as minDate from quotes where quTicker='" + ticker + "' " +
! 				"group by quTicker");
! 			return (DateTime)(dataTable.Rows[ 0 ][ "minDate" ]);
  		}
  		/// <summary>
***************
*** 73,77 ****
  		/// <param name="ticker">ticker for which the lasat date has to be returned</param>
  		/// <returns></returns>
! 		public static DateTime GetEndDate( string ticker )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
--- 73,77 ----
  		/// <param name="ticker">ticker for which the lasat date has to be returned</param>
  		/// <returns></returns>
! 		public static DateTime GetLastQuoteDate( string ticker )
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(