[Quantproject-developers] QuantProject/b2_DataAccess/Tables Quotes.cs,1.2,1.3

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

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

Modified Files:
	Quotes.cs 
Log Message:
Added and modified some methods in Quotes and SqlExecutor



Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** Quotes.cs	28 Mar 2004 19:55:54 -0000	1.2
--- Quotes.cs	17 Apr 2004 14:01:17 -0000	1.3
***************
*** 13,16 ****
--- 13,17 ----
  	{
  		private DataTable quotes;
+      
  
  		/// <summary>
***************
*** 35,39 ****
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
! 				"select * from quotes where quTicker='" + ticker + "'" );
  			return (DateTime)(dataTable.Rows[ 0 ][ "quDate" ]);
  		}
--- 36,41 ----
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
! 				"select * from quotes where quTicker='" + ticker + "' " +
! 				"order by quDate");
  			return (DateTime)(dataTable.Rows[ 0 ][ "quDate" ]);
  		}
***************
*** 46,52 ****
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
! 				"select * from quotes where quTicker='" + ticker + "'" );
! 			return (DateTime)(dataTable.Rows[ 0 ][ "quDate" ]);
  		}
  		#region GetHashValue
  		private string getHashValue_getQuoteString_getRowString_getSingleValueString( Object value )
--- 48,133 ----
  		{
  			DataTable dataTable = SqlExecutor.GetDataTable(
! 				"select * from quotes where quTicker='" + ticker + "' " +
! 				"order by quDate DESC");
! 			return (DateTime)(dataTable.Rows[0][ "quDate" ]);
  		}
+     /// <summary>
+     /// Returns the number of quotes for the given ticker
+     /// </summary>
+     /// <param name="ticker">ticker for which the number of quotes has to be returned</param>
+     /// <returns></returns>
+     public static int GetNumberOfQuotes( string ticker )
+     {
+       DataTable dataTable = SqlExecutor.GetDataTable(
+         "select * from quotes where quTicker='" + ticker + "'" );
+       return dataTable.Rows.Count;
+     }
+ 
+     /// <summary>
+     /// It provides deletion of the quote from the table "quotes" for
+     /// the given ticker for a specified date
+     /// </summary>
+     public static void Delete( string ticker, DateTime dateOfTheQuoteToBeDeleted )
+     {
+       try
+       {
+       SqlExecutor.ExecuteNonQuery("DELETE * FROM quotes " +
+                                   "WHERE quTicker ='" +
+                                   ticker + "' AND quDate =" +
+                                   SQLBuilder.GetDateConstant(dateOfTheQuoteToBeDeleted));
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+       }
+     }
+ 
+     /// <summary>
+     /// It provides addition of the given quote's values into table "quotes" 
+     /// </summary>
+     public static void Add( string ticker, DateTime date, double open, 
+                             double high, double low, double close,
+                             double volume, double adjustedClose)
+     {
+       try
+       {
+       SqlExecutor.ExecuteNonQuery("INSERT INTO quotes(quTicker, quDate, quOpen, " +
+                                   "quHigh, quLow, quClose, quVolume, quAdjustedClose) " +
+                                   "VALUES('" + ticker + "', " + SQLBuilder.GetDateConstant(date) + ", " +
+                                   open + ", " + high + ", " + low + ", " + close + ", " +
+                                   volume + ", " + adjustedClose + ")");
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+       }
+     }             
+ 
+     public static bool IsAdjustedCloseChanged(string ticker, DateTime dateToCheck,
+                                               float currentAdjustedValueFromSource)
+     {
+       bool isAdjustedCloseChanged = false;
+       try
+       {
+         float adjustedCloseInDatabase;
+         double absoluteRelativeDifference;
+           DataTable tableOfSingleRow = 
+                     SqlExecutor.GetDataTable("SELECT * FROM quotes WHERE quTicker='" +
+                                               ticker + "' AND quDate=" + 
+                                               SQLBuilder.GetDateConstant(dateToCheck));
+           adjustedCloseInDatabase = (float)(tableOfSingleRow.Rows[0]["quAdjustedClose"]);
+           absoluteRelativeDifference = 
+                             Math.Abs((currentAdjustedValueFromSource - adjustedCloseInDatabase)/currentAdjustedValueFromSource);
+           if(absoluteRelativeDifference>ConstantsProvider.MaxRelativeDifferenceForAdjustedValues)
+               isAdjustedCloseChanged = true;
+         return isAdjustedCloseChanged;
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+         return isAdjustedCloseChanged;
+       }
+     }             
+ 
  		#region GetHashValue
  		private string getHashValue_getQuoteString_getRowString_getSingleValueString( Object value )