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