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