[Quantproject-developers] QuantProject/b2_DataAccess/Tables Quotes.cs,1.9,1.10

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

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

Modified Files:
	Quotes.cs 
Log Message:
Added method to update adjusted close

Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** Quotes.cs	13 Jun 2004 11:10:03 -0000	1.9
--- Quotes.cs	17 Jun 2004 19:54:42 -0000	1.10
***************
*** 482,485 ****
--- 482,497 ----
        SqlExecutor.ExecuteNonQuery (sql);
      }
+     
+     /// <summary>
+     /// Provides updating the database with a new adjusted close for
+     /// the given ticker at a specified date
+     /// </summary>
+     public static void UpdateAdjustedClose( string ticker, DateTime date, double adjustedClose )
+     {
+       string sql = "UPDATE quotes SET quotes.quAdjustedClose=" +
+         adjustedClose + " WHERE quotes.quTicker='" + ticker + "' AND " +
+         "quotes.quDate=" + SQLBuilder.GetDateConstant(date);
+       SqlExecutor.ExecuteNonQuery (sql);
+     }
  
      /* Now useless