private void SearchData()
{
string SQL = "";
grdSearchResults.DataSource = null;
grdSearchResults.DataBind();
if ((txtSearchQuotationNo.Text == "") && (txtSearchVehicleNo.Text == ""))
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Search text cannot be blank');", true);
return;
}
if (txtSearchQuotationNo.Text != "")
{
SQL = "(LOWER(QUOTATION_NO) LIKE '%" + txtSearchQuotationNo.Text.ToLower() + "%') AND";
}
if (txtSearchVehicleNo.Text != "")
{
SQL = "(LOWER(VEHICLE_NO) LIKE '%" + txtSearchVehicleNo.Text.ToLower() + "%') AND";
}
SQL = SQL.Substring(0, SQL.Length - 3);
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdSearchResults.DataSource = proposalUploadController.GetUploadedProposals(SQL);
if (grdSearchResults.DataSource != null)
{
grdSearchResults.DataBind();
}
pnlSearchGrid.Visible = true;
}