protected void AddTManual_Click(object sender, EventArgs e) { Security objSecurity = new Security(); #region "variables" string vPayment = dropPayment.SelectedItem.Value; string vBackGround = dropBackGround.SelectedItem.Value; string vVerify = dropEmpVerify.SelectedItem.Value; string vComments = string.Empty; string vFinalStatus = dropFinalStatus.SelectedItem.Value; #endregion string strTCSID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(strTCSID).Length > 0) { strTCSID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); } clsCourse_Result objCR = new clsCourse_Result(); objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(strTCSID)); if (objCR != null) { objCR.MDE_AuthorisedUserId = Convert.ToInt32(HttpContext.Current.Session["UserAuthId"].ToString()); objCR.MDE_EmployerVeri = Convert.ToInt32(vVerify); objCR.MDE_BackGround = Convert.ToInt32(vBackGround); objCR.MDE_PaymentVeri = Convert.ToInt32(vPayment); objCR.MDE_F_Decision = Convert.ToInt32(vFinalStatus); objCR.MDE_F_Notes = vComments; objCR.Notes = objCR.Notes + " " + DateTime.Now.ToShortDateString(); objCR.IsActive = Convert.ToInt32(vFinalStatus); if (Course_ResultDAL.UpdateCourse_Result(objCR)) { //strTCSID = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCSID.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Saved successfully!', '', 'success', 'MDE_ApprCertApps.aspx?approvecertapp=active');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Error: Cannot Save Records!', '', 'danger', '#');", true); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Error: Cannot Save Records!', '', 'danger', '#');", true); } }
protected void showTableCertAccredit(string Title, string Inst_Name, string Cat, string TPName, string ClassResultId) { string strSPContractorID = objcryptoJS.AES_encrypt(ClassResultId.ToString(), AppConstants.secretKey, AppConstants.initVec).ToString(); bool IsSubmitted = false; clsCourse_Result objCR = new clsCourse_Result(); objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(ClassResultId)); if (objCR != null) { if ((objCR.Acct_Term > 0)) { IsSubmitted = true; } } StringBuilder strContent = new StringBuilder("<tr>"); strContent.Append("<td width='15%' nowrap><a href='AppCA.aspx?dash=active&cgi=" + System.Web.HttpUtility.UrlEncode(strSPContractorID) + "' >"); strContent.Append(Title); strContent.Append("</a></td>"); strContent.Append("<td width='10%'nowrap>"); strContent.Append(Inst_Name); strContent.Append("</td>"); strContent.Append("<td width='10%'nowrap>"); strContent.Append(Cat); strContent.Append("</td>"); strContent.Append("<td width='10%'nowrap>"); strContent.Append(TPName); strContent.Append("</td>"); //*************************************** strContent.Append("<td width='5%' nowrap>"); if (IsSubmitted) { strContent.Append("<a class='btn btn-xs btn-default' href='#'>Applied for C&A Certification</a>"); } else { strContent.Append("<a class='btn btn-xs btn-primary' href='AppCA.aspx?dash=active&cgi=" + System.Web.HttpUtility.UrlEncode(strSPContractorID) + "'>Apply for C&A</a>"); } strContent.Append("</td>"); pnlMyCourses.Controls.Add(new LiteralControl(strContent.ToString())); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string ClassResultId = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(ClassResultId).Length > 0) { ClassResultId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"]), AppConstants.secretKey, AppConstants.initVec).ToString(); } #region Getting all the Contractors list List <clsSP_Contractor> lstSPCont = new List <clsSP_Contractor>(); lstSPCont = SP_ContractorDAL.SelectDynamicSP_Contractor("IsActive = 1 and ACRDCatID = 13", "SPContractorID"); if (lstSPCont != null) { if (lstSPCont.Count > 0) { dropContractors.Items.Add(new ListItem( String.Format("{0}", "Select Contractor"), String.Format("{0}", "0"))); for (int i = 0; i < lstSPCont.Count; i++) { dropContractors.Items.Add(new ListItem( String.Format("{0}", SQLHelper.TrimAndReplaceEOF(lstSPCont[i].SPName.ToString())), String.Format("{0}", SQLHelper.TrimAndReplaceEOF(objcryptoJS.AES_encrypt(lstSPCont[i].SPContractorID.ToString(), AppConstants.secretKey, AppConstants.initVec).ToString())))); } } } #endregion clsCourse_Result objCR = new clsCourse_Result(); objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(ClassResultId)); if (objCR != null) { if ((objCR.Acct_Term > 0)) { btnAddCourse.Enabled = false; btnAddCourse.Text = "Applied for C&A Certification"; } } } catch (Exception) { } } }
protected void AddTManual_Click(object sender, EventArgs e) { Security objSecurity = new Security(); CryptoJS objcryptoJS = new CryptoJS(); string ClassResultId = string.Empty; #region "variables" //// string vSPName = objSecurity.KillChars(txtTPName.Text); // string vContractor = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(dropContractors.SelectedItem.Value), AppConstants.secretKey, AppConstants.initVec).ToString(); // //string vTPPhone = objSecurity.KillChars(txtTPPhone.Text); // //string vTPMobile = objSecurity.KillChars(txtTPMobile.Text); // //string vTPWebsite = objSecurity.KillChars(txtTPWebsite.Text); // //string vTPEmail = objSecurity.KillChars(txtTPEmail.Text); // int intNewTPID = 0; // int intNewInstructorId = 0; #endregion #region Instructor Info //string vCategory = objcryptoJS.AES_decrypt(dropCategory.SelectedItem.Value, AppConstants.secretKey, AppConstants.initVec).ToString(); //string vInstructorFName = objSecurity.KillChars(txtInstructorFName.Text); //string vInstructorLName = objSecurity.KillChars(txtInstructorLName.Text); //string vInsAccId = objSecurity.KillChars(txtInsAccId.Text); //string vInsAccExpire = objSecurity.KillChars(txtAccdExpireDate.Text); //string vInstEmail = objSecurity.KillChars(txtInstEmail.Text); #endregion #region Address 1 //string vAddress_1 = objSecurity.KillChars(txtAddress_1.Text); //string vAddress_2 = objSecurity.KillChars(txtAddress_2.Text); //string vCity = objSecurity.KillChars(txtCity.Text); //string vCounty = objSecurity.KillChars(txtCounty.Text); //string vState = objSecurity.KillChars(txtState.Text); //string vZipCode = objSecurity.KillChars(txtZipCode.Text); //string vEmail = objSecurity.KillChars(txtTPEmail.Text); //string vLocationTitle = objSecurity.KillChars(txtLocTitle.Text); #endregion try { ClassResultId = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(ClassResultId).Length > 0) { ClassResultId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"]), AppConstants.secretKey, AppConstants.initVec).ToString(); } clsCourse_Result objCR = new clsCourse_Result(); objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(ClassResultId)); if (objCR != null) { objCR.PaymentAmount = "120.00"; objCR.Acct_Term = Convert.ToInt32(dropYears.SelectedItem.Value); objCR.Notes = "User Entered Contractor Id: " + dropContractors.SelectedItem.Value; if (!Course_ResultDAL.UpdateCourse_Result(objCR)) { } } } catch (Exception) { ErrorHandler.ErrorPage(); } string strResultId = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode("10"), AppConstants.secretKey, AppConstants.initVec).ToString(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Your Application has been submitted successfully!', '', 'success', 'RoleDesc.aspx?Dash=active&cgi=" + strResultId + "');", true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strTCSID = string.Empty; string strTCid = string.Empty; try { strTCSID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(strTCSID).Length > 0) { strTCSID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); } #region Getting Class Details clsCourse_Result objCS = new clsCourse_Result(); objCS = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(strTCSID)); if (objCS != null) { #region Getting Employer info clsSP_Contractor objCont = new clsSP_Contractor(); objCont = SP_ContractorDAL.SelectSP_ContractorById(objCS.SPContractorID); if (objCont != null) { lblEmployerName.Text = objCont.SPName; lblEmployerEmail.Text = objCont.SPEmail; lblEmployerPhone.Text = objCont.SPPhone + " / " + objCont.SPMobile; } #endregion lblYearFor.Text = objCS.Acct_Term.ToString(); clsUser objUser = new clsUser(); objUser = UserDAL.SelectUserById(objCS.AuthorisedUserId); if (objUser != null) { lblCrouseName.Text = objUser.FName + " " + objUser.LName; } if (objCS.IsActive == 1) { // this records already exsistes btnAddTManual.Enabled = false; dropEmpVerify.Enabled = false; dropPayment.Enabled = false; dropFinalStatus.Enabled = false; dropBackGround.Enabled = false; txtNotes.Enabled = false; //strTCid = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCid.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a class='btn btn-success download' title='Download as PDF' href='/" + objcryptoJS.AES_encrypt("Acct_Certificate", AppConstants.secretKey, AppConstants.initVec) + ".cert' target='_blank' >Generate Accreditation Certificate</a>" + GlobalMethods.ContractorAppStatus(1, "bar", "MDE_ApprCertApps.aspx?approvecertapp=active") + "</div>")); } else { btnAddTManual.Enabled = true; dropEmpVerify.Enabled = true; dropPayment.Enabled = true; dropFinalStatus.Enabled = true; dropBackGround.Enabled = true; txtNotes.Enabled = true; //strTCid = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCid.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'>" + GlobalMethods.ContractorAppStatus(9, "bar", "MDE_ApprCertApps.aspx?approvecertapp=active") + "</div>")); } } #endregion } catch (Exception) { ErrorHandler.ErrorPage(); } } }