>>>>Declaring the type for the generic in the function call also works:

closeDrawers.InList< short >(2, 4)

>>>
>>>Do you know if there is something similar to VFP Case statement in C# where we can analyze different conditions?
>>>
>>>Say,
>>>
>>>I just wrote this part:
>>>
>>>

>>> if (startTime > defaultDate && endTime > defaultDate)
>>>                                    {
>>>                                        whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>>>                                        sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>>>                                        sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>>>                                    }

>>>
>>>I need 2 more cases for only startTime defined or only endTime defined. If I will use if I again need to check both variables.
>>
>>What do you want to do if startTime or endTime are not defined ?
>>
>>>
>>>Wondering if there is something in C# that makes this decision choice easier. I believe there is nothing in C# that is like VFP case where we can test various expressions - quick Google search also confirms it.
>
>That's my code - I just hoped there is something I can do to make it easier:
>
>

> if (closeDrawers.InList<short>(2, 4))
>                                {
>                                    DateTime defaultDate = Functions.DTSqlMinDate;
>                                    sqlStatement.AppendLine("salespoint = @Salespoint");
>                                    sqlCommand.Parameters.Add("@Salespoint", SqlDbType.Char, 6).Value = closeSalespoint.PadRight(6);
>                                    if (startTime > defaultDate && endTime > defaultDate)
>                                    {
>                                        sqlStatement.AppendLine(" AND date_time between @StartTime and @EndTime");
>                                        sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>                                        sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>                                    }
>                                    if (startTime > defaultDate && endTime == defaultDate)
>                                    {
>                                        sqlStatement.AppendLine(" AND date_time>= @StartTime");
>                                        sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>                                    }
>                                    if (startTime == defaultDate && endTime > defaultDate)
>                                    {
>                                        sqlStatement.AppendLine(" AND date_time <= @EndTime");
>                                        sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>                                    }
>                                }

(1) Use of 'else if' would be better

(2) You do not cover all the possibilities. There are nine


(3) If you want to use a switch, which you can
I have put most of the sql related in comments. It's the idea - you'll need to think
Cases you did not cover throw exceptions

			if (closeDrawers.InList<short>(2, 4))
			{
				DateTime defaultDate = new DateTime();
				//   sqlStatement.AppendLine("salespoint = @Salespoint");
				// sqlCommand.Parameters.Add("@Salespoint", SqlDbType.Char, 6).Value = closeSalespoint.PadRight(6);

				
	
				switch ( Math.Sign(startTime.CompareTo(defaultDate)) )
				{

					case 1: // startTime > defaultDate 
						
						switch ( Math.Sign(endTime.CompareTo(defaultDate) ))
						{
							case 1: // endTime > defaultDate
								//sqlStatement.AppendLine(" AND date_time between @StartTime and @EndTime");
								//sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
								//sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
								break;

							case 0: //endTime == defaultDate
								//sqlStatement.AppendLine(" AND date_time>= @StartTime");
								//sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
								break;

							default: // -1 endTime < defaultDate
								throw new ArgumentOutOfRangeException("endTime < defaultDate");

						}
						break;
					case 0: // startTime == defaultDate
						switch (Math.Sign(endTime.CompareTo(defaultDate)))
						{
							case 1: // endTime > defaultDate
								//sqlStatement.AppendLine(" AND date_time <= @EndTime");
								//sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
								break;

							case 0: //endTime == defaultDate
								throw new ArgumentOutOfRangeException("endTime == defaultDate");
							default: // endTime < defaultDate
								throw new ArgumentOutOfRangeException("endTime < defaultDate");
						}

						break;

					default: // starttime < defaultDate
						throw new ArgumentOutOfRangeException("starttime < defaultDate");
				}
			}