[pgsqlclient-checkins] pgsqlclient_10/PostgreSql.Data.PgSqlClient/source PgParameter.cs,1.9,1.10

[<car...@us...>]

Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv25914

Modified Files:
	PgParameter.cs 
Log Message:
Updated file

Index: PgParameter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgParameter.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** PgParameter.cs	14 Dec 2003 15:06:50 -0000	1.9
--- PgParameter.cs	3 Jan 2004 15:42:16 -0000	1.10
***************
*** 21,24 ****
--- 21,26 ----
  using System.ComponentModel;
  
+ using PostgreSql.Data.PgTypes;
+ 
  namespace PostgreSql.Data.PgSqlClient
  {
***************
*** 220,224 ****
  		#endregion
  
! 		#region ICLONEABLE_METHOD
  
  		object ICloneable.Clone()
--- 222,226 ----
  		#endregion
  
! 		#region ICloneable Method
  
  		object ICloneable.Clone()
***************
*** 238,241 ****
--- 240,379 ----
  		#endregion
  
+ 		#region Methods
+ 
+ 		public override string ToString()
+ 		{
+ 			return this.parameterName;
+ 		}
+ 	
+ 		#endregion
+ 
+ 		#region Internal Methods
+ 
+ 		internal string ConvertToPgString()
+ 		{
+ 			bool	addQuotes	= true;
+ 			string	returnValue = String.Empty;
+ 
+ 			switch (this.pgDbType)
+ 			{
+ 				case PgDbType.Array:
+ 					break;
+ 
+ 				case PgDbType.Binary:
+ 					break;
+ 
+ 				case PgDbType.Boolean:
+ 					returnValue = Convert.ToBoolean(this.value).ToString().ToLower();
+ 					break;
+ 
+ 				case PgDbType.Box:
+ 					returnValue = ((PgBox)this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Byte:
+ 					returnValue = Convert.ToByte(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Char:
+ 				case PgDbType.VarChar:
+ 				case PgDbType.Text:
+ 					returnValue = Convert.ToString(this.value);
+ 					break;
+ 
+ 				case PgDbType.Circle:
+ 					returnValue = ((PgCircle)this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Currency:					
+ 					returnValue = "$" + Convert.ToSingle(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Date:
+ 					returnValue = Convert.ToDateTime(this.value).ToString("MM/dd/yyyy");
+ 					break;
+ 
+ 				case PgDbType.Decimal:
+ 				case PgDbType.Numeric:
+ 					returnValue = Convert.ToDecimal(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Double:
+ 					returnValue = Convert.ToDouble(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Float:
+ 					returnValue = Convert.ToSingle(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Int2:
+ 					returnValue = Convert.ToInt16(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Int4:
+ 					returnValue = Convert.ToInt32(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Int8:
+ 					returnValue = Convert.ToInt64(this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Interval:
+ 					break;
+ 
+ 				case PgDbType.Line:
+ 					returnValue = ((PgLine)this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.LSeg:
+ 					returnValue = ((PgLSeg)this.value).ToString();
+ 					break;
+ 				
+ 				case PgDbType.Path:
+ 					returnValue = ((PgPath)this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Point:
+ 					returnValue = ((PgPoint)this.value).ToString();
+ 					break;
+ 
+ 				case PgDbType.Polygon:
+ 					returnValue = ((PgPolygon)this.value).ToString();
+ 					break;
+ 				
+ 				case PgDbType.Time:
+ 					returnValue = Convert.ToDateTime(this.value).ToString("HH:mm:ss");
+ 					break;
+ 
+ 				case PgDbType.Timestamp:
+ 					returnValue = Convert.ToDateTime(this.value).ToString("MM/dd/yyy HH:mm:ss");
+ 					break;
+ 
+ 				case PgDbType.TimestampWithTZ:
+ 					returnValue = Convert.ToDateTime(this.value).ToString("MM/dd/yyy HH:mm:ss zz");
+ 					break;
+ 
+ 				case PgDbType.TimeWithTZ:
+ 					returnValue = Convert.ToDateTime(this.value).ToString("HH:mm:ss zz");
+ 					break;
+ 
+ 				case PgDbType.Vector:
+ 					break;
+ 
+ 				default:
+ 					returnValue = this.value.ToString();
+ 					break;
+ 			}
+ 
+ 			if (addQuotes)
+ 			{
+ 				returnValue = "'" + returnValue + "'";
+ 			}
+ 
+ 			return returnValue;
+ 		}
+ 
+ 		#endregion
+ 
  		#region Private Methods
  
***************
*** 421,429 ****
  		}
  
- 		public override string ToString()
- 		{
- 			return this.parameterName;
- 		}
- 	
  		#endregion
  	}
--- 559,562 ----