How do I add multiple text box variables into one sql select query using cshtml razor?

Question

Currently in the code below I have two search buttons and can only query on what is in each box. I want to fill out both boxes and hit one submit button and it queries both variables. Something like

 {if(!Request.QueryString["searchDateIn"].IsEmpty() ) 
  selectCommand = "SELECT * FROM Data_TimeCards_T WHERE Employeeid = @0 
   and datein = @1";
    searchTerm = Request.QueryString["searchEmployee"];}

My code now looks like this

var db = Database.Open("datbasename") ;
var selectCommand = "SELECT * FROM Data_timecards_T";
var searchTerm = "";

if(!Request.QueryString["searchEmployee"].IsEmpty() ) {
    selectCommand = "SELECT * FROM Data_TimeCards_T WHERE Employeeid = @0";
    searchTerm = Request.QueryString["searchEmployee"];
}

if(!Request.QueryString["searchDateIn"].IsEmpty() ) {
    selectCommand = "SELECT * FROM Data_timeCards_t WHERE Datein = @0";
    searchTerm = Request.QueryString["searchDateIn"] ;
}

var selectedData = db.Query(selectCommand, searchTerm);
var grid = new WebGrid(source: selectedData, defaultSort: "EmployeeID", rowsPerPage:3);

And the body looks like this

<form method="get">
        <div>
        <label for="searchEmployee">Employee to look for:</label>
        <input type="text" name="searchEmployee" value="@Request.QueryString["searchEmployee"]" />
        <input type="Submit" value="Search Employee" /><br/>
        (Leave blank to list all movies.)<br/>
        </div>

        <div>
          <label for="searchDateIn">DateIn contains the following:</label>
          <input type="text" name="searchDateIn" value="@Request.QueryString["searchDateIn"]" />
          <input type="Submit" value="Search Date In" /><br/>
        </div>
      </form>

    <div>
      @grid.GetHtml(
        tableStyle: "grid",
        headerStyle: "head",
        alternatingRowStyle: "alt",
        columns: grid.Columns(
          grid.Column("DateIn"),
          grid.Column("EmployeeID"),
          grid.Column("TotalTime")
        )
      )
    </div>

Answer 1

I was able to resolve the issue by changing the code to what you see below

var db = Database.Open("database name") ;
var selectCommand = "SELECT * FROM Data_timecards_T";
  var searchEmployee = "";
  var searchDate = "";}

 if(!Request.QueryString["searchEmployee"].IsEmpty() ) {
        selectCommand = "SELECT * FROM Data_TimeCards_T WHERE Employeeid = @0 and Datein = @1";
        searchEmployee = Request.QueryString["searchEmployee"];
          searchDate = Request.QueryString["searchDate"];
    }
    var selectedData = db.Query(selectCommand, searchEmployee,searchDate);
    var grid = new WebGrid(source: selectedData, defaultSort: "EmployeeID", rowsPerPage:3);}

The form portion now looks like this:

   {<form method="get">
        <div>
        <label for="searchEmployee">Employee to look for:</label>
        <input type="text" name="searchEmployee"   value="@Request.QueryString["searchEmployee"]" />
         <label for="searchDate">DateIn contains the following:</label>
          <input type="text" name="searchDate" value="@Request.QueryString["searchDate"]" />
          <input type="Submit" value="SearchData" /><br/>
        </div>
      </form>}