private DataTable getSearchResult()
{
ProposalUploadController proposalUploadController = new ProposalUploadController();
DataTable completedJobs = new DataTable();
/////
string SQL = "";
if (ddlBranch.SelectedValue.ToString() != "0")
{
SQL = SQL + "(mpu.TARGET_BRANCH_CODE = '" + ddlBranch.SelectedValue.ToString() + "' OR mpu.quotation_no like '%" + ddlBranch.SelectedValue.ToString() + "%' OR mpu.job_number like '%" + ddlBranch.SelectedValue.ToString() + "%') AND";
}
if (ddlStatus.SelectedValue.ToString() != "0")
{
SQL = SQL + "(mpu.status = '" + ddlStatus.SelectedValue.ToString() + "') AND";
}
if (txtDateFrom.Text != "")
{
SQL = SQL + "( TO_DATE( mpuf.sys_date ,'dd/mm/RRRR') >= TO_DATE('" + txtDateFrom.Text.ToLower() + "','dd/mm/RRRR') ) AND";
}
if (txtDateTo.Text != "")
{
SQL = SQL + "( TO_DATE(mpuf.sys_date ,'dd/mm/RRRR') <=TO_DATE('" + txtDateTo.Text.ToLower() + "','dd/mm/RRRR') ) AND";
}
if (txtPolicyNo.Text != "")
{
SQL = SQL + "(LOWER(mpu.tcs_policy_no) LIKE '%" + txtPolicyNo.Text.ToLower() + "%') AND";
}
if (txtJobNo.Text != "")
{
SQL = SQL + "(LOWER(mpu.QUOTATION_NO ) LIKE '%" + txtJobNo.Text.ToLower() + "%' OR LOWER(mpu.JOB_NUMBER ) LIKE '%" + txtJobNo.Text.ToLower() + "%' ) AND";
}
SQL = SQL.Substring(0, SQL.Length - 3);
////
completedJobs = proposalUploadController.GetJobs(SQL);
return(completedJobs);
}
