protected void SubmitBtn_Click(object sender, EventArgs e) { AccessDB dbObj = new AccessDB(); dbObj.Open(); dbObj.Query = string.Format("Select emailaddress,CAST( AES_DECRYPT( passwd, 'kalli' ) AS CHAR( 100 ) ) from tbluserlogin where emailaddress ='{1}'", Constants.AESKey, UserNameTbx.Text); dbObj.ExecuteQuery(); if (dbObj.Dataset.Tables[0].Rows.Count > 0) { Mail mailObj = new Mail(); mailObj.To = UserNameTbx.Text; mailObj.Subject = "Reply: Forgot Password Request"; mailObj.MailBody = string.Format("Dear Ma'am/Sir, \r\n Username:{0} \r\n Password:{1} \r\n Regards, \r\n Admin team.", UserNameTbx.Text, dbObj.Dataset.Tables[0].Rows[0][1]); mailObj.SendMailMessage(); VerificationLbl.Text = "Your password has been sent to your email."; VerificationLbl.Visible = true; } else { VerificationLbl.Text = "The UserName provided is not valid.Kindly verify and retry / contact the Admin Team."; VerificationLbl.Visible = true; } dbObj.Close(); }
protected void SubmitBtn_Click(object sender, ImageClickEventArgs e) { Mail mailObj = new Mail(); mailObj.MailBody = CommentTB.Text; //Will by default have the from address as '*****@*****.**' mailObj.From = Session["UserLogin"].ToString(); mailObj.Subject = string.Format("{0}:{1}", Session["UserLogin"].ToString(), ReasonDDL.SelectedValue); mailObj.To = ConfigurationManager.AppSettings["AdminEmail"]; mailObj.SendMailMessage(); #region mailToAllAdmins //Send to all Admins .. // AccessDB dbObj = new AccessDB(); // dbObj.Open(); /*dbObj.Dataset.Reset(); dbObj.Query = string.Format(@"Select emailaddress from tbluserlogin where isadmin=true"); dbObj.ExecuteQuery(); for (int i = 0; i < dbObj.Dataset.Tables[0].Rows.Count; i++) { mailObj.To = dbObj.Dataset.Tables[0].Rows[i][0].ToString(); mailObj.SendMailMessage(); }*/ #endregion ConfMsgLbl.Visible = true; }