private void SearchData() { string SQL = ""; grdSearchResults.DataSource = null; grdSearchResults.DataBind(); if ((txtSearchPolicyNo.Text == "") && (txtSearchProposalNo.Text == "")) { Page.ClientScript.RegisterStartupScript(GetType(), "Message", "alert('Search text cannot be blank');", true); return; } if (txtSearchPolicyNo.Text != "") { SQL = "(LOWER(pol_no) LIKE '%" + txtSearchPolicyNo.Text.ToLower() + "%') AND"; } if (txtSearchProposalNo.Text != "") { SQL = "(LOWER(PRO_NO) LIKE '%" + txtSearchProposalNo.Text.ToLower() + "%') AND"; } if (txtSearchVehicleNo.Text != "") { SQL = "(LOWER(pol_reg_no) LIKE '%" + txtSearchVehicleNo.Text.ToLower() + "%') AND"; } SQL = SQL.Substring(0, SQL.Length - 3); TCSPolicyController tCSPolicyController = new TCSPolicyController(); if (rbtnNonTakaful.Checked) { grdSearchResults.DataSource = tCSPolicyController.searchTCSPoliciesForCancellation(SQL, "TCS"); } else if (rbtnTakaful.Checked) { grdSearchResults.DataSource = tCSPolicyController.searchTCSPoliciesForCancellation(SQL, "TAKAFUL"); } if (grdSearchResults.DataSource != null) { grdSearchResults.DataBind(); } pnlSearchGrid.Visible = true; }
private bool ValidatePolicyNumber(string policyNumber) { bool returnVal = false; TCSPolicyController tCSPolicyController = new TCSPolicyController(); if (tCSPolicyController.checkIsPolicyNoAvailable(policyNumber, "TCS")) { returnVal = true; } return(returnVal); }
protected void grdSearchResults_SelectedIndexChanged(object sender, EventArgs e) { TCSPolicyController tCSPolicyController = new TCSPolicyController(); txtSelectedPolicyeNo.Text = grdSearchResults.SelectedRow.Cells[2].Text.Trim(); DataTable dtDebit = tCSPolicyController.getDebitNosOfPolicy(grdSearchResults.SelectedRow.Cells[2].Text.Trim()); if (dtDebit.Rows.Count > 0) { chklDebitNumbers.DataSource = dtDebit; chklDebitNumbers.DataTextField = "dncn_no"; chklDebitNumbers.DataValueField = "dncn_no"; chklDebitNumbers.DataBind(); chklDebitNumbers.Visible = true; } }
protected void btnApprove_Click(object sender, EventArgs e) { if (txtProposalUploadId.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Take a job first');", true); return; } TCSPolicyController tCSPolicyController = new TCSPolicyController(); if (txtJobType.Text == "N") { if (txtTCSPolicyNo.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Please enter TCS Policy Number');", true); return; } if (!tCSPolicyController.checkIsPolicyNoAvailable(txtTCSPolicyNo.Text.Trim(), "TCS")) { if (!tCSPolicyController.checkIsPolicyNoAvailable(txtTCSPolicyNo.Text.Trim(), "TAKAFUL")) { lblMessage.Text = "Invalid Policy Number"; ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Invalid Policy Number');", true); return; } } } ProposalUploadController proposalUploadController = new ProposalUploadController(); string APPROVED_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["APPROVED_BY_VALIDATORS"].ToString(); string UserCode = ""; string UserBranch = ""; HttpCookie reqCookies = Request.Cookies["userInfo"]; if (reqCookies != null) { UserCode = reqCookies["UserCode"].ToString(); UserBranch = reqCookies["UserBranch"].ToString(); } proposalUploadController.UpdateProposalUploadStatus(Convert.ToInt32(txtProposalUploadId.Text), UserCode, APPROVED_BY_VALIDATORS, txtRemarks.Text); if (txtSystemName.Text == "TCS") { proposalUploadController.UpdateTargetBranchCode("TCS", Convert.ToInt32(txtProposalUploadId.Text), txtTCSPolicyID.Text); } else if (txtSystemName.Text == "TAKAFUL") { proposalUploadController.UpdateTargetBranchCode("TAKAFUL", Convert.ToInt32(txtProposalUploadId.Text), txtTCSPolicyID.Text); } if (txtJobType.Text == "N") { proposalUploadController.UpdateTCSPolicyNo(Convert.ToInt32(txtProposalUploadId.Text), txtTCSPolicyNo.Text.Trim()); sendApprovalNotificationMailForNewBusiness(); } else if (txtJobType.Text == "E") { sendApprovalNotificationMailForEndorsement(); } else if (txtJobType.Text == "R") { sendApprovalNotificationMailForRenewal(); } else if (txtJobType.Text == "C") { sendApprovalNotificationMailForCancellation(); } if (tCSPolicyController.checkIsHNBPolicy(txtTCSPolicyID.Text, "TCS")) { sendApprovalNotificationMailOfHNBToHDO(); } else if (tCSPolicyController.checkIsHNBPolicy(txtTCSPolicyID.Text, "TAKAFUL")) { sendApprovalNotificationMailOfHNBToHDO(); } // passDocumentToDMS(); //Temporarily commented ClearComponents(); LoadUploadedProposal(); LoadMissedProposal(); //btnTakeJob.Enabled = true; }
protected void btnDone_Click(object sender, EventArgs e) { if (txtProposalUploadId.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Take a job first');", true); return; } TCSPolicyController tCSPolicyController = new TCSPolicyController(); if (txtJobType.Text == "N") { if (txtTCSProposalNo.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Please enter TCS Proposal Number');", true); return; } if (!tCSPolicyController.checkIsProposalNoAvailable(txtTCSProposalNo.Text.Trim(), "TCS")) { if (!tCSPolicyController.checkIsProposalNoAvailable(txtTCSProposalNo.Text.Trim(), "TAKAFUL")) { lblMessage.Text = "Invalid Proposal Number"; ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Invalid Proposal Number');", true); return; } } } ProposalUploadController proposalUploadController = new ProposalUploadController(); string COMPLETED_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_BY_PROCESSING"].ToString(); string UserCode = ""; string UserBranch = ""; HttpCookie reqCookies = Request.Cookies["userInfo"]; if (reqCookies != null) { UserCode = reqCookies["UserCode"].ToString(); UserBranch = reqCookies["UserBranch"].ToString(); } proposalUploadController.UpdateProposalUploadStatus(Convert.ToInt32(txtProposalUploadId.Text), UserCode, COMPLETED_BY_PROCESSING, txtRemarks.Text); if (txtJobType.Text == "N") { proposalUploadController.UpdateTCSProposalNoAndPolicyId(Convert.ToInt32(txtProposalUploadId.Text), txtTCSProposalNo.Text.Trim()); } //stop the counter Timer1.Enabled = false; ClearComponents(); LoadUploadedProposal(ddlPrefJobType.SelectedValue.ToString()); LoadMissedProposal(); // btnTakeJob.Enabled = true; }