using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Net.Mail;
public partial class forgetpassword : System.Web.UI.Page
{
    OleDbConnection conn;
    connection objConn = new connection();
    string From;
    string username;
    protected void Page_Load(object sender, EventArgs e)
    {
        conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Domains\nid.edu\db\database.mdb;Persist Security Info=True");        
       // conn=objconn.getconn();
    }    
    protected void btnForgotPassword_Click(object sender, EventArgs e)
    {
        OleDbCommand cmd1=new OleDbCommand("select * from MemberMaster where UserID='"+ txtUserId.Text +"'",conn);
        OleDbDataAdapter dap=new OleDbDataAdapter(cmd1);
        DataTable dt=new DataTable();
        int count= dap.Fill(dt);
        if (count != 0)
        {
           // string userid;
            Random rnd = new Random();
            double rndNo = rnd.Next(0, 100000);
            From = "webmaster@nid.edu";
          
            MailMessage mail = new MailMessage(From, txtUserId.Text);
            mail.Subject = "Alumni Login Password Reset";
            username = "UserName: " + txtUserId.Text + " \n Password: " + rndNo;
            mail.Body = username;
            SmtpClient sm = new SmtpClient();
            sm.Host = "smtp.gmail.com";
            sm.Port = Convert.ToInt16("25");
            sm.Credentials = new System.Net.NetworkCredential("webmaster@nid.edu", "web123");
            sm.EnableSsl = true;
            try
            {
                sm.Send(mail);
              
                OleDbCommand cmd3 = new OleDbCommand("update MemberMaster set [Password]='" + rndNo.ToString() + "' where UserId='" + txtUserId.Text.ToString() + "'", conn);
                conn.Open();
                cmd3.ExecuteNonQuery(); 
                conn.Close();
            }
            catch (Exception ex)
            {
                lblError.Visible = true;
                lblError.Text = ex.Message;
            }
        }
        else
        {
            lblError.Visible = true;
            lblError.Text = "Userid Not Found";
        }
    }
  
}