using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Net.Mail;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Configuration;
using System.Net;
using System.Text;
using System.IO;
using System.Data.SqlClient;
 
 
    public partial class Forgot : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
 
        }
        protected void bc_fpwd_submit_button_Click(object sender, EventArgs e)
        {
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString.ToString());
                con.Open();
                SqlCommand sqlCMD = con.CreateCommand();
                sqlCMD.CommandText = "SELECT * FROM users WHERE email = @email"; // (this should really be a stored procedure, shown here for simplicity)
 
                // Fill our parameters
 
                sqlCMD.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = bc_fpwd_uid_textbox.Text;
 
                SqlDataAdapter sqlAD = new SqlDataAdapter(sqlCMD);
                DataSet dsDataSet = new DataSet();
                sqlAD.Fill(dsDataSet);
                if (dsDataSet.Tables[0].Rows.Count > 0)
                {
                    Form.Visible = false;
                    FoundPW.Visible = true;
                    Label1.Text = bc_fpwd_uid_textbox.Text;
                    bc_fuid_validator.Visible = true;
 
                    Label2.Text = this.FormView1.FindControl("passwordLabel").ToString();
                    string MyValue = Label2.Text;
 
 
                    // Do this if username not found in database
                }
                else
                {
                    Form.Visible = true;
                    FoundPW.Visible = false;
                    bc_no_uid_label.Visible = true;
                }
                con.Close();
                sqlAD.Dispose();
            }
 
        }
 
 
 
        protected void bc_fpwd_cancel_button_Click(object sender, EventArgs e)
        {
 
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                System.Configuration.Configuration config
                    = WebConfigurationManager.OpenWebConfiguration(base.Request.ApplicationPath);
                AppSettingsSection appSettings = (AppSettingsSection)config.GetSection("appSettings");
 
                //appSettings.Settings["EmailHost"].Value
                string emailHost = appSettings.Settings["EmailHost"].Value;
                string fromAddress = appSettings.Settings["FromEmailAddr"].Value;
                string toAddress = "me@vortexamerica.com";
 
 
 
                SmtpClient smtpClient = new SmtpClient(emailHost);
 
                // Default in IIS will be localhost 
                //smtpClient.Host = "localhost";
 
                //Default port will be 25
                 smtpClient.Port = 25;
 
 
                MailMessage message = new MailMessage();
                message.IsBodyHtml = false;
                message.Priority = MailPriority.High;
                message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
 
                try
                {
                    message.Subject = "Paal Camera Forgot Password";
                    message.Body += "Sender: " + bc_fpwd_uid_textbox.Text + "\n";
                    message.Body += "Password: " + FormView1.FindControl("passwordlabel").ToString()+ "\n";
 
 
 
                    smtpClient.Send(fromAddress, toAddress, message.Subject, message.Body);
 
 
                }
                catch (Exception ex)
                {
                    // Display error panel
 
 
                    // Log error
 
                }
 
            }
 
        }
 
    }