[Quantproject-developers] QuantDownloader/Downloader/OpenTickDownloader/DatabaseManagement DataBaseWriter.cs, 1.1, 1.2

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader/OpenTickDownloader/DatabaseManagement
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5121/Downloader/OpenTickDownloader/DatabaseManagement

Modified Files:
	DataBaseWriter.cs 
Log Message:
GetDateConstant() is now a public, static method

Index: DataBaseWriter.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/OpenTickDownloader/DatabaseManagement/DataBaseWriter.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** DataBaseWriter.cs	9 Jul 2008 22:14:30 -0000	1.1
--- DataBaseWriter.cs	20 Jul 2008 20:32:24 -0000	1.2
***************
*** 84,100 ****
  		
  		#region getSqlCommand_getValues
- 		private string getDateConstant( DateTime dateTime )
- 		{
- 			string dateConstant =
- 				"#" +
- 				dateTime.Month + "/" +
- 				dateTime.Day + "/" +
- 				dateTime.Year + " " +
- 				dateTime.Hour + ":" +
- 				dateTime.Minute + ":" +
- 				dateTime.Second +
- 				"#";
- 			return dateConstant;
- 		}
  		private string formatDoubleForSql( double value )
  		{
--- 84,87 ----
***************
*** 110,114 ****
  				"'" + bar.Ticker + "' , " +
  				"'" + bar.Exchange + "' , " +
! 				this.getDateConstant( utcDateTimeForOpen ) + " , " +
  				bar.Interval + " , " +
  				formatDoubleForSql( bar.Open ) + " , " +
--- 97,101 ----
  				"'" + bar.Ticker + "' , " +
  				"'" + bar.Exchange + "' , " +
! 				DataBaseWriter.GetDateConstant( utcDateTimeForOpen ) + " , " +
  				bar.Interval + " , " +
  				formatDoubleForSql( bar.Open ) + " , " +
***************
*** 180,183 ****
--- 167,189 ----
  			this.writeToDataBaseThread.Start();
  		}
+ 		
+ 		/// <summary>
+ 		/// Builds a date to be used in a Sql query
+ 		/// </summary>
+ 		/// <param name="dateTime"></param>
+ 		/// <returns></returns>
+ 		public static string GetDateConstant( DateTime dateTime )
+ 		{
+ 			string dateConstant =
+ 				"#" +
+ 				dateTime.Month + "/" +
+ 				dateTime.Day + "/" +
+ 				dateTime.Year + " " +
+ 				dateTime.Hour + ":" +
+ 				dateTime.Minute + ":" +
+ 				dateTime.Second +
+ 				"#";
+ 			return dateConstant;
+ 		}
  	}
  }