protected void btnSave_Click(object sender, EventArgs e)
{
try
{
GetSession session = new GetSession();
Random rnd = new Random();
int myRandomNo = rnd.Next(100000, 999999);
Global.GlobalValueRandom = myRandomNo.ToString();
string bal = Request.Form["txtWithdrawlAmmount"];
double balance = Convert.ToDouble(bal);
string paymentType = ddlPaymentType.SelectedItem.Text;
string accountReference = session.AccountNumber;
string name = "";
string toUser = session.UserName;
CommonFunction cmDataTable = new CommonFunction();
string cmdInvestorName = "select Name from InvestorProfile where(AccountNumber='" + session.AccountNumber + "')";
DataTable dtInvestorName = cmDataTable.GetDatatable(cmdInvestorName);
if (dtInvestorName.Rows.Count > 0)
{
name = dtInvestorName.Rows[0]["Name"].ToString();
//toUser = dtInvestorName.Rows[0]["Email"].ToString();
}
BOSLEmailer3 sendEmail = new BOSLEmailer3();
//string siteUrl = ConfigurationManager.AppSettings["SiteUrl"];
string message = "Dear " + name + ",<br/><br/>" + "please input this number for your withdrawl request to complete - " + myRandomNo;
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = true;//Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = "Transaction confirmation digit on iTradex";
sendEmail.To = toUser;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
GetAccountBalance2(paymentType, balance);
//ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('Your verification code has sent, Please check your email for code.');</script>");
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "openModal3();", true);
}
catch (Exception ex)
{
Response.Redirect("../../LoginErrorPage.aspx?ex=" + Server.UrlEncode(ex.Message) + "&st=" + Server.UrlEncode(ex.StackTrace));
}
}
/// <summary>
/// Send Mail With reset Password
/// </summary>
private void SendMailWithPassword(string resetPassword, string Email, string AccountNumber)
{
RijndaelEncryption encryption = new RijndaelEncryption();
string encryptionKey = ConfigurationManager.AppSettings["EncryptionKey"];
CommonFunction cmRegistration = new CommonFunction();
string userName = "";
string newPassword = resetPassword;
string email = Email;
string accountNumber = AccountNumber;
string cmdUserName = "******" + accountNumber + "'";
DataTable dtUserName = cmRegistration.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
}
}
try
{
BOSLEmailer3 sendEmail = new BOSLEmailer3();
//string siteUrl = ConfigurationManager.AppSettings["SiteUrl"];
string emailMessage = "Dear " + userName + ",<br/><br/>" + "iTradeX has reset your password as you have requested.<br/>";
string message = emailMessage + "<br/><b>Your new password is:</b><br/>"
+ "Password: "******"<br/><br/>You can also change your password again after login.<br/><br/>";
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = true;//Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = "Forgotten Password Reset on iTradex";
sendEmail.To = email;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('iTradeX has reset your password. Please Check Your Email.');window.location='../../Default.aspx';</script>'");
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('Mail server is currently unavailable. " + ex.Message + "');window.location='../../Default.aspx';</script>'");
}
}
/// <summary>
/// Send mail for accept or reject
/// </summary>
/// <param name="AccountNumber"></param>
private void SendMail(string AccountNumber, string MethodName, string Amount, string TrnDate)
{
string userName = "";
string email = "";
string mainMsg = "";
GetSession session = new GetSession();
if (MethodName == "btnReject_Click")
{
mainMsg = "rejected. Please contact with your borker";
}
else if (MethodName == "btnAccept_Click")
{
mainMsg = "accepted. Please contact with your borker";
}
CommonFunction cmUser = new CommonFunction();
string cmdUserName = "******" + AccountNumber + "'";
DataTable dtUserName = cmUser.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
email = dr["Email"].ToString();
}
}
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string emailMessage = "Hi " + userName + ",<br/>Your fund withdrawal request on " + TrnDate + " for taka " + Amount + " has " + mainMsg + ".";
string message = emailMessage;
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = "Fund Withdrawal Request On iTradeX";
sendEmail.To = email;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
//ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
// ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('An Email Has Sent To Investor.');window.location='FundWithdrawRequestBroker.aspx';</script>'");
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "openModal();", true);
}
/// <summary>
/// send email
/// </summary>
private void SendMailWithPin(string pinNumber, string AccountNumber, string Email)
{
GetSession session = new GetSession();
try
{
string userName = "";
CommonFunction cmUser = new CommonFunction();
string cmdUserName = "******" + AccountNumber + "'";
DataTable dtUserName = cmUser.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
}
}
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string emailMessage = "Dear " + userName + ",<br/><br/>" + "Your new PIN is:<br/>";
string message = emailMessage + "<br/> " + pinNumber + ".<br/><br/><br/> If you have not requested this change, please call your stock broker immediately.";
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = Convert.ToInt32(ConfigurationManager.AppSettings["Authentication"]);//1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = true;//Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = "Your PIN is reset on iTradex";
sendEmail.To = Email;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
string script = "alert('The PIN of the selected customer is reset and the new PIN is emailed.');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
// ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('Your Pin Number Has Reseted. Please Check Your Mail For New Pin Number.');window.location='Active.aspx';</script>'");
//Response.Redirect("LoginPage.aspx");
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "openModal();", true);
}
catch (Exception ex)
{
//Response.Redirect("LoginErrorPage.aspx?ex=" + Server.UrlEncode(ex.Message) + "&st=" + Server.UrlEncode(ex.StackTrace), false);
throw ex;
}
}
private void SendPassword()
{
Random rnd = new Random();
string number = rnd.Next(10000000, 99999999).ToString();
RijndaelEncryption encryption = new RijndaelEncryption();
string memberID = txtMemberID.Text;
string userId = txtEmail.Text;
string boID = txtBOID.Text;
string brokerName = txtBrokerName.Text;
string encryptionKey = ConfigurationManager.AppSettings["EncryptionKey"];
string password = encryption.EncryptText(number, encryptionKey);
string encriptedUserId = encryption.EncryptText(userId, encryptionKey);
try
{
CommonFunction cmSaveData = new CommonFunction();
string insertQuery = "insert into ApplicationUser(UserId,AccountNumber,BONumber,UserType,Password,IsRegistered,IsActive,IsLogin) Values('" + userId + "','" + memberID + "','" + boID + "','Broker','" + password + "','True','True','False')";
cmSaveData.InsertQuery(insertQuery);
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string siteUrl = ConfigurationManager.AppSettings["SiteUrl"];
string emailMessage = ConfigurationManager.AppSettings["Message"];
string message = "Your secret password is " + number + ". " + "<a href='" + siteUrl + "Pages/Investor/LoginPage.aspx?" + "'>Please Login</a>" + "";
//string message = emailMessage + "<a href='http://localhost:2268/Pages/Investor/LoginPage.aspx?E="+encriptedUserId+"&a="+encriptedAccount+"'>Registration Acctivation</a>";
//string message = emailMessage + "<a href='"+siteUrl +"+"e="+"+encryption.EncryptText(userId, "1")+"' >Registration Acctivation</a>";
//string message = emailMessage + "<a href=http://localhost:2268/Pages/Investor/LoginPage.aspx?E="+encriptedUserId+"> Registration Acctivation</a>";
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]); //System.Configuration.ConfigurationManager.AppSettings.Get("IsHtml");
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = "Registration";
sendEmail.To = userId;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
}
catch (Exception ex)
{
Response.Redirect("LoginErrorPage.aspx?ex=" + Server.UrlEncode(ex.Message) + "&st=" + Server.UrlEncode(ex.StackTrace));
}
}
/// <summary>
/// Send mail for accept or reject
/// </summary>
/// <param name="AccountNumber"></param>
private void SendMail(string AccountNumber, string MethodName, string companyName)
{
string userName = "";
string email = "";
string mainMsg = "";
GetSession session = new GetSession();
if (MethodName == "btnReject_Click" || MethodName == "Rejected")
{
mainMsg = "rejected. Please contact with your borker";
}
else if (MethodName == "btnAccept_Click" || MethodName == "Accepted")
{
mainMsg = "accepted. Please contact with your borker";
}
CommonFunction cmUser = new CommonFunction();
string cmdUserName = "******" + AccountNumber + "'";
DataTable dtUserName = cmUser.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
email = dr["Email"].ToString();
}
}
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string emailMessage = "Hi " + userName + ",<br/>Your IPO request on iTradeX for " + companyName + " has " + mainMsg + ".";
string message = emailMessage;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
sendEmail.From = ConfigurationManager.AppSettings["From"];
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["IPOPassword"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["IPOSMTPServer"];
sendEmail.Subject = "Fund Withdrawal Request On iTradeX";
sendEmail.To = email;
sendEmail.UserName = ConfigurationManager.AppSettings["IPOUserName"];
sendEmail.SendEmail();
}
private void Registration(string email, string accNumber, string bo, string status)
{
Random rnd = new Random();
string number = rnd.Next(1000, 9999).ToString();
CommonFunction cmRegistration = new CommonFunction();
RijndaelEncryption encryption = new RijndaelEncryption();
string userId = email;
string encryptionKey = ConfigurationManager.AppSettings["EncryptionKey"];
string accountNumber = accNumber;
string boNumber = bo;
string encriptedUserId = encryption.EncryptText(userId, encryptionKey);
string encriptedAccount = encryption.EncryptText(accountNumber, encryptionKey);
string pinNumber = encryption.EncryptText(number, encryptionKey);
try
{
string userName = "";
//string insertQuery = "insert into ApplicationUser(UserID,Password,BrokerRef,BONumber,AccountNumber,"
//+"SecretQuestion,SecretAnswer,LastLoginTime,IsActive,IsLogin,IsRegistered,UserType,PinNumber)"
//+"Values('" + userId + "','" + password + "','" + ddlBroker.SelectedValue + "','" + boNumber + "','" + accountNumber + "','" + ddlSecreteQuestion.SelectedItem.Text + "','" + secreteAnswer + "','" + DateTime.Now + "','false','false','false','Investor','" + pinNumber + "')";
string cmdUserName = "******" + accountNumber + "'";
DataTable dtUserName = cmRegistration.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
}
}
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string siteUrl = ConfigurationManager.AppSettings["SiteUrl"];
string emailMessage = "Hi " + userName + ",<br/>" + "One more step to activate your account on iTradeX. Just click on the link below:<br/>";
string message = emailMessage + "<a href='" + siteUrl + "Default.aspx?" + "e=" + encriptedUserId + "&a=" + encriptedAccount + "&n=" + pinNumber + "'>Registration Acctivation</a>" + "<br/> Your secret PIN number for Fund Withdraw Request is " + number + "";
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]); //System.Configuration.ConfigurationManager.AppSettings.Get("IsHtml");
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = ConfigurationManager.AppSettings["EmailSubjectForRegistration"];
sendEmail.To = userId;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
CommonFunction cmActiveInvestor = new CommonFunction();
string query = "UPDATE ApplicationUser SET PinNumber ='" + pinNumber + "' WHERE AccountNumber='" + accountNumber + "'";
cmActiveInvestor.InsertQuery(query);
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('An email has sent to the investor.');window.location='Active.aspx';</script>'");
//Response.Redirect("LoginPage.aspx");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Send mail for accept or reject
/// </summary>
/// <param name="AccountNumber"></param>
private void SendMail(string AccountNumber, string MethodName, string accountReference, string trnDate, string instrumentName, string rate, string quantity)
{
GetSession session = new GetSession();
string userName = "";
string email = "";
string orderStatus = "";
if (MethodName == "btnReject_Click")
{
orderStatus = "Rejected";
}
else if (MethodName == "btnAccept_Click")
{
orderStatus = "Accepted";
}
CommonFunction cmUser = new CommonFunction();
string cmdUserName = "******" + AccountNumber + "'";
DataTable dtUserName = cmUser.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
email = dr["Email"].ToString();
}
}
string messageBody = ConfigurationManager.AppSettings["EmailBodyForOrder"];
messageBody = messageBody.Replace("@newLine", "<br/>");
messageBody = messageBody.Replace("@userName", userName);
messageBody = messageBody.Replace("@orderStatus", orderStatus);
messageBody = messageBody.Replace("@trnDate", trnDate);
messageBody = messageBody.Replace("@instrumentName", instrumentName);
messageBody = messageBody.Replace("@rate", rate);
messageBody = messageBody.Replace("@quantity", quantity);
BOSLEmailer3 sendEmail = new BOSLEmailer3();
// string emailMessage = "Dear "+userName+", <br/>Your order place in iTradex has been " + orderStatus + ". Order details are bellow : <br/> Order Date - " + trnDate + " <br/> Instrument Name - " + instrumentName + " <br/>Share Rate - " + rate + " <br/> Share Quantity - " + quantity + "";
string message = messageBody;
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = ConfigurationManager.AppSettings["Subject"];
sendEmail.To = email;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
//Response.Redirect("LoginPage.aspx");
}
private void Registration()
{
Random rnd = new Random();
string number = rnd.Next(1000, 9999).ToString();
CommonFunction cmRegistration = new CommonFunction();
if (Session["CAPTCHA"].ToString().Equals(txtInput.Text))
{
RijndaelEncryption encryption = new RijndaelEncryption();
//string userId = Request.Form["Email"].ToString();
string userId = txtEmail.Text;
string encryptionKey = ConfigurationManager.AppSettings["EncryptionKey"];
string password = encryption.EncryptText((Request.Form["password"].ToString()), encryptionKey);
//string accountNumber = Request.Form["AccountNumber"].ToString();
string accountNumber = txtAccountNumber.Text;
//string secreteAnswer = Request.Form["SecreteAnswer"].ToString();
string secreteAnswer = txtSecretAnswer.Text;
//string boNumber = Request.Form["BONumber"].ToString();
string boNumber = txtPrefix.Text + txtBONumber.Text;
string encriptedUserId = encryption.EncryptText(userId, encryptionKey);
string encriptedAccount = encryption.EncryptText(accountNumber, encryptionKey);
string pinNumber = encryption.EncryptText(number, encryptionKey);
string emailCheckQuery = "select UserID from ApplicationUser where(UserID='" + userId + "' AND Password='******')";
DataTable dtEmailPass = cmRegistration.GetDatatable(emailCheckQuery);
if (dtEmailPass.Rows.Count > 0)
{
//ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('This Email and Password Already Exist.Please Try Another Password.');window.location='RegAndLogin.aspx';</script>'");
pnlMessage.Visible = true;
lblShowMessage.Text = "This Email and Password already exist. Please try another password.";
}
try
{
string userName = "";
//string insertQuery = "insert into ApplicationUser(UserID,Password,BrokerRef,BONumber,AccountNumber,"
//+"SecretQuestion,SecretAnswer,LastLoginTime,IsActive,IsLogin,IsRegistered,UserType,PinNumber)"
//+"Values('" + userId + "','" + password + "','" + ddlBroker.SelectedValue + "','" + boNumber + "','" + accountNumber + "','" + ddlSecreteQuestion.SelectedItem.Text + "','" + secreteAnswer + "','" + DateTime.Now + "','false','false','false','Investor','" + pinNumber + "')";
string cmdUserName = "******" + accountNumber + "'";
DataTable dtUserName = cmRegistration.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
}
}
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string siteUrl = ConfigurationManager.AppSettings["SiteUrl"];
string emailMessage = "Hi " + userName + ",<br/>" + "One more step to verify your email address on iTradeX. Just click on the link below:<br/>";
string message = emailMessage + "<a href='" + siteUrl + "Default.aspx?" + "e=" + encriptedUserId + "&a=" + encriptedAccount + "&n=" + pinNumber + "'>Registration Acctivation</a>" + "<br/> Your secret PIN number for Fund Withdraw Request is " + number + "";
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]); //System.Configuration.ConfigurationManager.AppSettings.Get("IsHtml");
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = ConfigurationManager.AppSettings["EmailSubjectForRegistration"];
sendEmail.To = userId;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
//ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('Your Account Has successfully Registered, Please Check Your Email For Activate Your Account');window.location='RegAndLogin.aspx';</script>'");
pnlLoginMessage.Visible = true;
lblLoginMessage.Text = "Your Account Has successfully Registered, Please Check Your Email For Activate Your Account";
string insertQuery = "insert into ApplicationUser(UserID,Password,BrokerRef,BONumber,AccountNumber,"
+ "SecretQuestion,SecretAnswer,LastLoginTime,IsActive,IsRegistered,UserType,PinNumber,RegistrationTime,Status)"
+ "Values('" + userId + "','" + password + "','" + ddlBroker.SelectedValue + "','" + boNumber + "','" + accountNumber + "','" + ddlSecreteQuestion.SelectedItem.Text + "','" + secreteAnswer + "','" + DateTime.Now + "','false','false','Investor','" + pinNumber + "','" + DateTime.Now + "','Pending')";
cmRegistration.InsertQuery(insertQuery);
//Response.Redirect("LoginPage.aspx");
}
catch (Exception ex)
{
throw ex;
}
}
else
{
//ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('No Match Found From Captcha Input');window.location='RegAndLogin.aspx';</script>'");
pnlMessage.Visible = true;
lblShowMessage.Text = "No match found from captcha input. Please enter the correct one";
}
}
/// <summary>
/// Send email with Reset Link
/// </summary>
private void SendLinkReset()
{
string userName = "";
CommonFunction cmRegistration = new CommonFunction();
RijndaelEncryption encryption = new RijndaelEncryption();
string Email = Request.Form["Email"].ToString();
string encryptionKey = ConfigurationManager.AppSettings["EncryptionKey"];
string accountNumber = Request.Form["AccountNumber"];
string encriptedEmail = encryption.EncryptText(Email, encryptionKey);
string encriptedAccount = encryption.EncryptText(accountNumber, encryptionKey);
//string accountNumber = encryption.EncryptText((Request.Form["AccountNumber"].ToString()), encryptionKey);
string cmdUserName = "******" + accountNumber + "'";
DataTable dtUserName = cmRegistration.GetDatatable(cmdUserName);
if (dtUserName.Rows.Count > 0)
{
foreach (DataRow dr in dtUserName.Rows)
{
userName = dr["Name"].ToString();
}
}
try
{
BOSLEmailer3 sendEmail = new BOSLEmailer3();
string siteUrl = ConfigurationManager.AppSettings["SiteUrl"];
string emailMessage = "Hi " + userName + ",<br/>" + "We received a password reset request for your iTradeX account. To reset your password, use the links below:<br/>";
string message = emailMessage + "<br/><b>Reset your password using a web browser:</b><br/>"
+ "<a href='" + siteUrl + "Pages/Investor/ForgotPassword.aspx?" + "e=" + encriptedEmail + "&a=" + encriptedAccount + "'>Reset Password</a>"
+ "<br/><br/>If you didn't request a password reset, you can ignore this message and your password will not be changed, someone"
+ "probably typed in your username or email address by accident.<br/><br/>-The iTradeX Team";
//sendEmail.AttachmentPath=;
sendEmail.AuthenticationMode = 1;
sendEmail.Body = message;
//sendEmail.Cc=;
sendEmail.From = ConfigurationManager.AppSettings["From"];
//sendEmail.id=userId;
sendEmail.IsHtml = Convert.ToBoolean(ConfigurationManager.AppSettings["IsHtml"]);
sendEmail.IsUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["IsUseSSL"]);
sendEmail.Password = ConfigurationManager.AppSettings["Password"];
sendEmail.PortNum = Convert.ToInt32(ConfigurationManager.AppSettings["PortNum"]);
sendEmail.SendUsing = Convert.ToInt32(ConfigurationManager.AppSettings["SendUsing"]);
sendEmail.SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
sendEmail.Subject = "Forgotten password request from iTradeX";
sendEmail.To = Email;
sendEmail.UserName = ConfigurationManager.AppSettings["UserName"];
sendEmail.SendEmail();
//sconRegistration.Close();
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('Please Check Your Email. Click On The Link To Reset You Password.');window.location='../../Default.aspx';</script>'");
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script type='text/javascript'>alert('Mail server is currently unavailable. " + ex.Message + "');window.location='../../Default.aspx';</script>'");
}
}
