protected void grdCompletedJobSummary_SelectedIndexChanged(object sender, EventArgs e)
{
if (grdCompletedJobSummary.SelectedRow.Cells[3].Text.Trim() != "")
{
string PolicyNo = grdCompletedJobSummary.SelectedRow.Cells[3].Text;
string SystemName = grdCompletedJobSummary.SelectedRow.Cells[4].Text;
try
{
string proposalUploadId = "";
proposalUploadId = grdCompletedJobSummary.SelectedRow.Cells[1].Text.Trim();
string COMPLETED_AND_PRINTED = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_AND_PRINTED"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
// proposalUploadController.UpdateProposalUploadStatus(Convert.ToInt32(proposalUploadId), UserCode, COMPLETED_AND_PRINTED, "Docs Printed");
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('" + "../Common/TCSDocumentsViewer.aspx?PolicyNo=" + PolicyNo + "&SystemName=" + SystemName + "');", true);
}
catch (Exception ex)
{
}
}
}
private void LoadMissedProposal()
{
grdMissedUploadedProposal.DataSource = null;
grdMissedUploadedProposal.DataBind();
string TAKEN_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_VALIDATORS"].ToString();
string UserCode = "";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserCode = reqCookies["UserCode"].ToString();
UserBranch = reqCookies["UserBranch"].ToString();
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdMissedUploadedProposal.DataSource = proposalUploadController.GetQuotationNosOfStatusOfUsersOfSpecificType(TAKEN_BY_VALIDATORS, "C", UserCode);
if (grdMissedUploadedProposal.DataSource != null)
{
grdMissedUploadedProposal.DataBind();
updPnlMissedProposals.Update();
}
}
private void LoadMissedProposal()
{
grdMissedUploadedProposal.DataSource = null;
grdMissedUploadedProposal.DataBind();
// <add key="TAKEN_BY_CREDIT_CONTROLLER" value="TAKEN_BY_CREDIT_CONTROLLER" />
//<add key="REJECTED_BY_CREDIT_CONTROLLER" value="REJECTED_BY_CREDIT_CONTROLLER" />
//<add key="APPROVED_BY_CREDIT_CONTROLLER" value="APPROVED_BY_CREDIT_CONTROLLER" />
string TAKEN_BY_CREDIT_CONTROLLER = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_CREDIT_CONTROLLER"].ToString();
string UserCode = "";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserCode = reqCookies["UserCode"].ToString();
UserBranch = reqCookies["UserBranch"].ToString();
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdMissedUploadedProposal.DataSource = proposalUploadController.GetQuotationNosOfStatusOfUsersOfSpecificType(TAKEN_BY_CREDIT_CONTROLLER, "C", UserCode);
if (grdMissedUploadedProposal.DataSource != null)
{
grdMissedUploadedProposal.DataBind();
updPnlMissedProposals.Update();
}
}
private void LoadUploadedProposal()
{
grdUploadedProposal.DataSource = null;
grdUploadedProposal.DataBind();
string COMPLETED_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_BY_PROCESSING"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdUploadedProposal.DataSource = proposalUploadController.GetQuotationNosOfStatusOfSpecificType(COMPLETED_BY_PROCESSING, "C");
if (grdUploadedProposal.DataSource != null)
{
grdUploadedProposal.DataBind();
}
// pnlSearchGrid.Visible = true;
//if (grdUploadedProposal.Rows.Count < 1)
//{
// btnTakeJob.Enabled = false;
//}
//else
//{
// btnTakeJob.Enabled = true;
//}
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
Session["JobType"] = "Cancel";
Session["SessionedJobNo"] = "";
Session["QuotationNo"] = "";
ManageFormComponents("NEW");
Session["Mode"] = "NEW";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserBranch = reqCookies["UserBranch"].ToString();
txtEnteredBranchCode.Text = UserBranch;
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
txtJobNo.Text = proposalUploadController.GetNewJobNoForCancellation(UserBranch);
txtJobNo.ForeColor = Color.White;
Session["SessionedJobNo"] = txtJobNo.Text;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ipAddress = "";
ipAddress = GetUserIP();
if (ipAddress != "")
{
ProposalUploadController proposalUploadController = new ProposalUploadController();
if (!proposalUploadController.ValidateIpAddressForDashboard(ipAddress))
{
Response.Redirect("~/Logo.aspx");
}
}
}
LoadNotTakenScrutinizing();
LoadNotTakenProcessing();
LoadNotTakenValidating();
LoadTakenScrutinizing();
LoadTakenProcessing();
LoadTakenValidating();
// Page.ClientScript.RegisterStartupScript(GetType(), "Message", "alert('" + GetUserIP() + "');", true);
}
protected void btnLoadPreviousDocuments_Click(object sender, EventArgs e)
{
if (txtPolicyNo.Text != "")
{
var previousJobList = new List <ProposalUpload>();
ProposalUploadController proposalUploadController2 = new ProposalUploadController();
previousJobList = proposalUploadController2.loadOtherJobsByPolicyNo(txtPolicyNo.Text, txtJobNo.Text, "C");
List <ListItem> uploadedFiles = new List <ListItem>();
foreach (ProposalUpload previousJob in previousJobList)
{
List <ListItem> files = new List <ListItem>();
files = loadPreviousDocumentsToGrid(previousJob.JobNumber, previousJob.JobType, previousJob.JobStatus);
if (files != null)
{
uploadedFiles.AddRange(files);
}
}
grdPreviousDocuments.DataSource = uploadedFiles;
grdPreviousDocuments.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ProposalUploadId = "";
string JobType = "";
string Status = "";
if (Request.QueryString["ProposalUploadId"] != null)
{
ProposalUploadId = Request.QueryString["ProposalUploadId"].ToString();
JobType = Request.QueryString["JobType"].ToString();
Status = Request.QueryString["Status"].ToString();
loadJobFollowup(ProposalUploadId);
ProposalUploadController proposalUploadController = new ProposalUploadController();
string jobNo = "";
jobNo = proposalUploadController.GetJobNoFromProposalUploadId(ProposalUploadId);
loadUploadedDocumentsToGrid(jobNo, JobType, Status);
}
}
}
private void LoadUploadedProposal()
{
grdUploadedProposal.DataSource = null;
grdUploadedProposal.DataBind();
string RENEWAL_ADDEDStatusName = System.Configuration.ConfigurationManager.AppSettings["RENEWAL_ADDED"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdUploadedProposal.DataSource = proposalUploadController.GetJobsForRenewal(RENEWAL_ADDEDStatusName, txtUserBranch.Text);
if (grdUploadedProposal.DataSource != null)
{
grdUploadedProposal.DataBind();
updPnlProposals.Update();
}
pnlSearchGrid.Visible = true;
//if (grdUploadedProposal.Rows.Count < 1)
//{
// btnTakeJob.Enabled = false;
//}
//else
//{
// btnTakeJob.Enabled = true;
//}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtUserCode.Text.Trim() == "" && txtUserName.Text.Trim() == "")
{
lblMsg.Text = "Enter User name and User code";
Timer1.Enabled = true;
return;
}
try
{
string UserCode = "";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserCode = reqCookies["UserCode"].ToString();
UserBranch = reqCookies["UserBranch"].ToString();
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
int status = 1;
if (rdbtnInActive.Checked)
{
status = 0;
}
else
{
status = 1;
}
proposalUploadController.SaveCentralizeUser(txtUserCode.Text, txtUserName.Text, status);
if (fuPhoto.HasFile)
{
fuPhoto.SaveAs(quickinfo_v2.Properties.Settings.Default.UserPhotoSavePath + txtUserCode.Text + fuPhoto.FileName.Substring(fuPhoto.FileName.LastIndexOf("."), 4).ToUpper());
}
ClearComponents();
lblMsg.Text = "Successfully Saved";
Timer1.Enabled = true;
ManageFormComponents("INITIAL");
}
catch (Exception ex)
{
lblMsg.Text = "Error While Saving";
Timer1.Enabled = true;
}
}
private bool isAllowedToReprocess(string jobNo)
{
bool isAllowedToReprocess = false;
ProposalUploadController proposalUploadController = new ProposalUploadController();
string RENEWAL_ADDED = System.Configuration.ConfigurationManager.AppSettings["RENEWAL_ADDED"].ToString();
string TAKEN_BY_BRANCH_RENEWAL_DOC_UPLD = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_BRANCH_RENEWAL_DOC_UPLD"].ToString();
string RENEWAL_DOCS_ADDED = System.Configuration.ConfigurationManager.AppSettings["RENEWAL_DOCS_ADDED"].ToString();
string CANCELLATION_ADDED = System.Configuration.ConfigurationManager.AppSettings["CANCELLATION_ADDED"].ToString();
string TAKEN_BY_BRANCH_CANCELLATION_DOC_UPLD = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_BRANCH_CANCELLATION_DOC_UPLD"].ToString();
string CANCELLATION_DOCS_ADDED = System.Configuration.ConfigurationManager.AppSettings["CANCELLATION_DOCS_ADDED"].ToString();
string ENDORSEMENT_ADDED = System.Configuration.ConfigurationManager.AppSettings["ENDORSEMENT_ADDED"].ToString();
string INITIAL = System.Configuration.ConfigurationManager.AppSettings["INITIAL"].ToString();
string TAKEN_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_SCRUTINIZING"].ToString();
string APPROVED_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["APPROVED_BY_SCRUTINIZING"].ToString();
string TAKEN_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_PROCESSING"].ToString();
string COMPLETED_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_BY_PROCESSING"].ToString();
string TAKEN_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_VALIDATORS"].ToString();
string REJECTED_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["REJECTED_BY_SCRUTINIZING"].ToString();
string APPROVED_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["APPROVED_BY_VALIDATORS"].ToString();
string currentStatus = "";
currentStatus = proposalUploadController.getStatusOfJobFromJobNo(jobNo);
if (currentStatus == null || currentStatus == "")
{
if (ddlJobType.SelectedValue.ToString() == "N")
{
if (proposalUploadController.validateQuotationNoFromDB(txtSearchQuotationNo.Text))
{
return(true);
}
}
}
if (currentStatus == RENEWAL_ADDED || currentStatus == CANCELLATION_ADDED || currentStatus == RENEWAL_ADDED || currentStatus == ENDORSEMENT_ADDED || currentStatus == REJECTED_BY_SCRUTINIZING)
{
isAllowedToReprocess = true;
}
return(isAllowedToReprocess);
}
//protected void btnGivePriority_Click(object sender, EventArgs e)
//{
// if (txtJobNo.Text.Trim() == "")
// {
// lblMsg.Text = "Please select Job/Quotation No";
// Timer1.Enabled = true;
// return;
// }
// if (txtRemarks.Text.Trim() == "")
// {
// lblMsg.Text = "Please enter remark for prioritization";
// Timer1.Enabled = true;
// return;
// }
// try
// {
// string UserCode = "";
// string UserBranch = "";
// HttpCookie reqCookies = Request.Cookies["userInfo"];
// if (reqCookies != null)
// {
// UserCode = reqCookies["UserCode"].ToString();
// UserBranch = reqCookies["UserBranch"].ToString();
// }
// ProposalUploadController proposalUploadController = new ProposalUploadController();
// proposalUploadController.PrioritizeJob(txtProposalUploadId.Text, txtRemarks.Text, UserCode);
// ClearComponents();
// // SearchData();
// lblMsg.Text = "Successfully Prioritized";
// Timer1.Enabled = true;
// ManageFormComponents("INITIAL");
// //Response.Redirect("UserRegistration.aspx");
// }
// catch (Exception ex)
// {
// lblMsg.Text = "Error While Saving";
// Timer1.Enabled = true;
// }
//}
protected void btnRevertToScrutinizing_Click(object sender, EventArgs e)
{
if (txtJobNo.Text.Trim() == "")
{
lblMsg.Text = "Please select Job/Quotation No";
Timer1.Enabled = true;
return;
}
if (txtRemarks.Text.Trim() == "")
{
lblMsg.Text = "Please enter remark for revert";
Timer1.Enabled = true;
return;
}
if (!validateAction("REVERT", txtProposalUploadId.Text))
{
lblMsg.Text = "This job not allowed to Revert";
Timer1.Enabled = true;
return;
}
try
{
string UserCode = "";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserCode = reqCookies["UserCode"].ToString();
UserBranch = reqCookies["UserBranch"].ToString();
}
string INITIAL = System.Configuration.ConfigurationManager.AppSettings["INITIAL"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
proposalUploadController.RevertJobToScrutinizing(txtProposalUploadId.Text, INITIAL, txtRemarks.Text, UserCode);
ClearComponents();
// SearchData();
lblMsg.Text = "Successfully Reverted";
Timer1.Enabled = true;
ManageFormComponents("INITIAL");
//Response.Redirect("UserRegistration.aspx");
}
catch (Exception ex)
{
lblMsg.Text = "Error While Saving";
Timer1.Enabled = true;
}
}
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);
}
protected void btnBlacklistPolicy_Click(object sender, EventArgs e)
{
if (txtVehicleNo.Text.Trim() == "" && txtPolicyNo.Text.Trim() == "")
{
lblMsg.Text = "Please enter Vehicle No or Policy No.";
Timer1.Enabled = true;
return;
}
if (txtRemarks.Text.Trim() == "")
{
lblMsg.Text = "Please enter remark for Blacklisting";
Timer1.Enabled = true;
return;
}
try
{
string UserCode = "";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserCode = reqCookies["UserCode"].ToString();
UserBranch = reqCookies["UserBranch"].ToString();
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
proposalUploadController.BlacklistPolicy(txtVehicleNo.Text, txtPolicyNo.Text, txtRemarks.Text, UserCode);
ClearComponents();
// SearchData();
lblMsg.Text = "Successfully Blacklisted";
Timer1.Enabled = true;
ManageFormComponents("INITIAL");
//Response.Redirect("UserRegistration.aspx");
}
catch (Exception ex)
{
lblMsg.Text = "Error While Saving";
Timer1.Enabled = true;
}
}
protected void btnGivePriority_Click(object sender, EventArgs e)
{
if (txtJobNo.Text.Trim() == "")
{
lblMsg.Text = "Please select Job/Quotation No";
Timer1.Enabled = true;
return;
}
if (txtRemarks.Text.Trim() == "")
{
lblMsg.Text = "Please enter remark for prioritization";
Timer1.Enabled = true;
return;
}
try
{
string UserCode = "";
string UserBranch = "";
HttpCookie reqCookies = Request.Cookies["userInfo"];
if (reqCookies != null)
{
UserCode = reqCookies["UserCode"].ToString();
UserBranch = reqCookies["UserBranch"].ToString();
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
proposalUploadController.PrioritizeJob(txtProposalUploadId.Text, txtRemarks.Text, UserCode);
ClearComponents();
// SearchData();
lblMsg.Text = "Successfully Prioritized";
Timer1.Enabled = true;
ManageFormComponents("INITIAL");
//Response.Redirect("UserRegistration.aspx");
}
catch (Exception ex)
{
lblMsg.Text = "Error While Saving";
Timer1.Enabled = true;
}
}
private void search()
{
if (txtDateFrom.Text.Trim() == "" || txtDateTo.Text.Trim() == "" || txtTimeFrom.Value == "" || txtTimeTo.Value == "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "Message", "alert('All the parameters must fill');", true);
return;
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
ltrlSummary.Text = proposalUploadController.GetTimeRangeJobReport(txtDateFrom.Text, txtDateTo.Text, txtTimeFrom.Value, txtTimeTo.Value);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ipAddress = "";
ipAddress = GetUserIP();
if (ipAddress != "")
{
ProposalUploadController proposalUploadController = new ProposalUploadController();
if (!proposalUploadController.ValidateIpAddressForDashboard(ipAddress))
{
Response.Redirect("~/Logo.aspx");
}
}
}
}
private bool validateAction(string actionName, string proposalUploadId)
{
bool isValidationPassed = true;
ProposalUploadController proposalUploadController = new ProposalUploadController();
string RENEWAL_ADDED = System.Configuration.ConfigurationManager.AppSettings["RENEWAL_ADDED"].ToString();
string TAKEN_BY_BRANCH_RENEWAL_DOC_UPLD = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_BRANCH_RENEWAL_DOC_UPLD"].ToString();
string RENEWAL_DOCS_ADDED = System.Configuration.ConfigurationManager.AppSettings["RENEWAL_DOCS_ADDED"].ToString();
string CANCELLATION_ADDED = System.Configuration.ConfigurationManager.AppSettings["CANCELLATION_ADDED"].ToString();
string TAKEN_BY_BRANCH_CANCELLATION_DOC_UPLD = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_BRANCH_CANCELLATION_DOC_UPLD"].ToString();
string CANCELLATION_DOCS_ADDED = System.Configuration.ConfigurationManager.AppSettings["CANCELLATION_DOCS_ADDED"].ToString();
string ENDORSEMENT_ADDED = System.Configuration.ConfigurationManager.AppSettings["ENDORSEMENT_ADDED"].ToString();
string INITIAL = System.Configuration.ConfigurationManager.AppSettings["INITIAL"].ToString();
string TAKEN_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_SCRUTINIZING"].ToString();
string APPROVED_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["APPROVED_BY_SCRUTINIZING"].ToString();
string TAKEN_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_PROCESSING"].ToString();
string COMPLETED_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_BY_PROCESSING"].ToString();
string TAKEN_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_VALIDATORS"].ToString();
string REJECTED_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["REJECTED_BY_SCRUTINIZING"].ToString();
string APPROVED_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["APPROVED_BY_VALIDATORS"].ToString();
if (actionName == "REVERT")
{
string currentStatus = "";
currentStatus = proposalUploadController.getStatusOfJob(proposalUploadId);
if (currentStatus == APPROVED_BY_VALIDATORS || currentStatus == INITIAL || currentStatus == RENEWAL_ADDED || currentStatus == TAKEN_BY_BRANCH_RENEWAL_DOC_UPLD || currentStatus == RENEWAL_DOCS_ADDED || currentStatus == CANCELLATION_ADDED ||
currentStatus == TAKEN_BY_BRANCH_CANCELLATION_DOC_UPLD || currentStatus == CANCELLATION_DOCS_ADDED || currentStatus == ENDORSEMENT_ADDED || currentStatus == TAKEN_BY_SCRUTINIZING || currentStatus == REJECTED_BY_SCRUTINIZING)
{
isValidationPassed = false;
}
}
return(isValidationPassed);
}
private void LoadUploadedProposal()
{
grdUploadedProposal.DataSource = null;
grdUploadedProposal.DataBind();
string INITIALStatusName = System.Configuration.ConfigurationManager.AppSettings["INITIAL"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdUploadedProposal.DataSource = proposalUploadController.GetQuotationNosOfStatusOfSpecificType(INITIALStatusName, "C");
if (grdUploadedProposal.DataSource != null)
{
grdUploadedProposal.DataBind();
updPnlProposals.Update();
}
}
private void loadJobFollowup(string Status)
{
grdResults.DataSource = null;
grdResults.DataBind();
ProposalUploadController proposalUploadController = new ProposalUploadController();
DataTable completedJobs = new DataTable();
completedJobs = proposalUploadController.GetJobsOfStatus(Status);
grdResults.DataSource = completedJobs;
if (grdResults.DataSource != null)
{
grdResults.DataBind();
}
}
private void sendApprovalNotificationMailOfHNBToHDO()
{
ProposalUploadController proposalUploadController = new ProposalUploadController();
CommonMail mail = new CommonMail();
mail.From_address = "*****@*****.**";
mail.To_address = proposalUploadController.getEmailOfBranchStaff("TDA");//HDO FOR HNB
mail.Cc_address = "*****@*****.**";
mail.Subject = "Uploaded HNB Proposal Processed and Ready to Print";
String BodyText;
BodyText = "<html>" +
"<head>" +
"<title>Uploaded Proposal Processed and Ready to Print</title>" +
" <body> " +
"<table>" +
"<tr>" +
"<td>" +
"Uploaded Proposal of Quotation No. " + txtQuotationNo.Text + " Processed and Ready to Print." +
"</td>" +
"</tr>" +
"<tr>" +
"<td>" +
"TCS Policy No. - " + txtTCSPolicyNo.Text +
"</td>" +
"</tr>" +
"</table>" +
" </body> " +
" </html>";
try
{
mail.Body = BodyText;
mail.sendMail();
}
catch (Exception ee)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Error while sending notification e-mail.');", true);
}
}
private void LoadNotTakenProcessing()
{
grdNotTakenProcessing.DataSource = null;
grdNotTakenProcessing.DataBind();
string APPROVED_BY_SCRUTINIZING = System.Configuration.ConfigurationManager.AppSettings["APPROVED_BY_SCRUTINIZING"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdNotTakenProcessing.DataSource = proposalUploadController.GetQuotationNosOfStatusWithoutCancellations(APPROVED_BY_SCRUTINIZING);
if (grdNotTakenProcessing.DataSource != null)
{
grdNotTakenProcessing.DataBind();
updPnlNotTakenProcessing.Update();
}
}
private void LoadNotTakenValidating()
{
grdNotTakenValidating.DataSource = null;
grdNotTakenValidating.DataBind();
string COMPLETED_BY_PROCESSING = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_BY_PROCESSING"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdNotTakenValidating.DataSource = proposalUploadController.GetQuotationNosOfStatusWithoutCancellations(COMPLETED_BY_PROCESSING);
if (grdNotTakenValidating.DataSource != null)
{
grdNotTakenValidating.DataBind();
updPnlNotTakenValidating.Update();
}
}
private void LoadTakenValidating()
{
grdTakenValidating.DataSource = null;
grdTakenValidating.DataBind();
string TAKEN_BY_VALIDATORS = System.Configuration.ConfigurationManager.AppSettings["TAKEN_BY_VALIDATORS"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdTakenValidating.DataSource = proposalUploadController.GetQuotationNosOfStatusWithUser(TAKEN_BY_VALIDATORS);
if (grdTakenValidating.DataSource != null)
{
grdTakenValidating.DataBind();
updPnlTakenValidating.Update();
}
}
private void LoadNotTakenScrutinizing()
{
grdNotTakenScrutinizing.DataSource = null;
grdNotTakenScrutinizing.DataBind();
string INITIALStatusName = System.Configuration.ConfigurationManager.AppSettings["INITIAL"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
grdNotTakenScrutinizing.DataSource = proposalUploadController.GetQuotationNosOfStatusWithoutCancellations(INITIALStatusName);
if (grdNotTakenScrutinizing.DataSource != null)
{
grdNotTakenScrutinizing.DataBind();
updPnlNotTakenScrutinizing.Update();
}
}
private void loadProposalUploadDetailsForEdit(string ProposalUploadId)
{
ClearComponents();
ProposalUpload proposalUpload = new ProposalUpload();
ProposalUploadController proposalUploadController = new ProposalUploadController();
proposalUpload = proposalUploadController.GetUploadedProposal(Convert.ToInt32(ProposalUploadId));
txtProposalUploadId.Text = proposalUpload.ProposalUploadId.ToString();
txtPolicyNo.Text = proposalUpload.QuotationNo;
ManageFormComponents("EDIT");
}
protected void btnDone_Click(object sender, EventArgs e)
{
if (txtJobNo.Text == "")
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Please take a job first');", true);
return;
}
if (!checkIsDocumentsUploaded(txtJobNo.Text))
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Please scan the documents before press Done');", true);
return;
}
ProposalUploadController proposalUploadController = new ProposalUploadController();
string RENEWAL_DOCS_ADDED = System.Configuration.ConfigurationManager.AppSettings["RENEWAL_DOCS_ADDED"].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, RENEWAL_DOCS_ADDED, txtRemarks.Text);
ClearComponents();
LoadUploadedProposal();
btnTakeJob.Enabled = true;
}
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;
}
protected void lnkBtnPrint_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
int rowID = gvRow.RowIndex;
string proposalUploadId = "";
proposalUploadId = gvRow.Cells[1].Text.Trim();
string COMPLETED_AND_PRINTED = System.Configuration.ConfigurationManager.AppSettings["COMPLETED_AND_PRINTED"].ToString();
ProposalUploadController proposalUploadController = new ProposalUploadController();
proposalUploadController.UpdateProposalUploadStatus(Convert.ToInt32(proposalUploadId), UserCode, COMPLETED_AND_PRINTED, "Docs Printed");
loadCompletedJobSummary(UserBranch);
}
protected void btnOpenQuotationCalculation_Click(object sender, EventArgs e)
{
if (txtQuotationNo.Text != "")
{
int quotationJobID = 0;
int quotationRevisionNo = 0;
ProposalUploadController proposalUploadController = new ProposalUploadController();
int[] quoteVals = proposalUploadController.getJobNoAndRevisionNoOfQuotation(txtQuotationNo.Text);
quotationJobID = quoteVals[0];
quotationRevisionNo = quoteVals[1];
string url = "http://192.168.10.212:82/quickinfo-allinone/MotorNewBusiness/Reports/MotorQuotationCalculation.aspx?JobID=" + quotationJobID + "&RevisionNo=" + quotationRevisionNo;
string s = "window.open('" + url + "', 'popup_window', 'width=600,height=500,left=100,top=100,resizable=yes');";
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
}
}
