public void sendMailApproval(DataTable dtReceiver, string htmlstringtable, string loi_status, string executorname, int requestid, string ApproverRole) { try { StringBuilder sbResult = new StringBuilder(); string emailsubject = string.Empty; string fullname = dtReceiver.Rows[0]["Name"].ToString(); string email = dtReceiver.Rows[0]["Email"].ToString(); string paramapproveinemail = string.Concat("true;", requestid.ToString(), ";", ApproverRole, ";", dtReceiver.Rows[0]["USR_ID"].ToString()); string paramrejectinemail = string.Concat("false;", requestid.ToString(), ";", ApproverRole, ";", dtReceiver.Rows[0]["USR_ID"].ToString()); paramapproveinemail = EnDecController.EncryptLinkUrlApproval(paramapproveinemail); paramrejectinemail = EnDecController.EncryptLinkUrlApproval(paramrejectinemail); DataTable dtEmail = loi_get_email_data(loi_status, requestid); DataTable dtDocumentAvailibility = loi_supportingdoc_getall(requestid); string HtmlTableSupportingDocAvailibility = CreateHtmlTableSupportingDocAvailibility(dtDocumentAvailibility); if (dtEmail.Rows.Count > 0) { emailsubject = dtEmail.Select("config_key like '%subject%'")[0].ItemArray[1].ToString(); string emailbody = dtEmail.Select("config_key like '%body%'")[0].ItemArray[1].ToString(); emailbody = emailbody.Replace("[name]", fullname).Replace("[sourcename]", executorname); emailbody = emailbody.Replace("[tabledetail]", htmlstringtable); emailbody = emailbody.Replace("[param approve]", paramapproveinemail); emailbody = emailbody.Replace("[param reject]", paramrejectinemail); emailbody = emailbody.Replace("[document_avilibility]", HtmlTableSupportingDocAvailibility); sbResult.Append(emailbody); MailController.SendMail(email, emailsubject, sbResult.ToString(), GeneralConfig.MailConfigType()); } } catch (Exception ex) { EBOQ_Lib_New.DAL.DAL_AppLog.ErrLogInsert("LOIController:SendEmail", ex.Message, "NON-SP"); } }
public bool ebastusers_loi_iud(string USRType, string Name, int USRRole, string USRLogin, string Email, string PhoneNo, string SignTitle, string CTName, string USR_ID, bool isDelete) { string usrPassword = getrandomtext(); usrPassword = EnDecController.newhaspassword(usrPassword); //EnDecController.EncryptLinkUrlApproval(usrPassword); return(da.ebastusers_loi_iud(USRType, Name, USRRole, USRLogin, Email, PhoneNo, SignTitle, CTName, usrPassword, USR_ID, isDelete)); }
protected void Page_Load(object sender, EventArgs e) { try { //ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('LOI has been Approved Successfully');window.open('../autoclose.html')", true); string param = Request.QueryString["param"]; param = EnDecController.DecryptLinkUrlApproval(param); string[] paramarr = param.Split(';'); bool isApprove = bool.Parse(paramarr[0]); int RequestId = int.Parse(paramarr[1]); string ApproverRole = paramarr[2]; hdapproverrole.Value = ApproverRole; hdnReqID.Value = RequestId.ToString(); HttpContext.Current.Session[Resources.Resources.ses_userid] = int.Parse(paramarr[3]); if (loiControllerr.checking_linkapproval_validity(RequestId)) { if (isApprove) { if (loiControllerr.LOI_Update_Approval_Status(RequestId, true, ApproverRole, "")) { try { string nextApproval = loiControllerr.get_nextApproverRole_byApproverRole(ApproverRole); SendEmail(RequestId, nextApproval); } catch (Exception ex) { } finally { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('LOI has been Approved Successfully'); window.close();", true); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Failed to Approved LOI'); window.close();", true); } } else { pnlRejection.Visible = true; } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('The URL is no longer valid'); window.close();", true); } } catch (Exception ex) { } }
public bool reset_password_all_ct(int USR_ID, string USRPassword, string CTName) { USRPassword = EnDecController.newhaspassword(USRPassword); return(da.reset_password_all_ct(USR_ID, USRPassword, CTName)); }
public bool ebastusers_changepassword(string usr_login, string oldPassword, string newPassword) { oldPassword = EnDecController.newhaspassword(oldPassword); //EnDecController.EncryptLinkUrlApproval(oldPassword); newPassword = EnDecController.newhaspassword(newPassword); //EnDecController.EncryptLinkUrlApproval(newPassword); return(da.ebastusers_changepassword(usr_login, oldPassword, newPassword)); }