>>>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;
                                    }
                                }