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 approve : System.Web.UI.Page
{
    connection objconn = new connection();
    OleDbConnection conn;
    string From;
    string username;
    Int32 count;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Userid"] == "" || Session["Userid"] == null)
        {
            Response.Redirect("index.aspx");
        }
        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();
        if (!IsPostBack)
        {
            gridbind();
        }
    }
    protected void gridbind()
    {
        Int16 Flag;
        Flag = 0;
        OleDbCommand cmd = new OleDbCommand("select YR_SPLSN,NameOnCertificate,Discipline,EMAIL from MemberMaster where flagapprove=" + Flag + "", conn);
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        count= dap.Fill(dt);
        if (count == 0)
        {
            btnApprove.Visible = false;
            btnback.Visible = false;
        }
        else
        {
            btnApprove.Visible = true;
            btnback.Visible = true;
            gridApprove.DataSource = dt;
            gridApprove.DataBind();
        }
    }
    protected void btnApprove_Click(object sender, EventArgs e)
    {
        int i;
        i = 0;
       
        foreach (GridViewRow row in gridApprove.Rows)
        {
            CheckBox cb = (CheckBox)row.FindControl("chkID");
            if (cb != null && cb.Checked)
            {
                Label1.Visible = false;
                string userid;
                Random rnd = new Random();
                double rndNo = rnd.Next(0, 100000);
                From = "piyush_p@nid.edu";
                String sendermailID = gridApprove.Rows[i].Cells[4].Text;
                userid = sendermailID;
                MailMessage mail = new MailMessage(From, sendermailID);
                mail.Subject = "Login Name And Password For Alumni";
                username = "UserName: " + sendermailID + " \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", "lkj986@asd");
                sm.EnableSsl = true;
                try
                {
                    string Flag;
                    Flag = "yes";
                    sm.Send(mail);
                    conn.Open();
                    OleDbCommand cmd1 = new OleDbCommand("update MemberMaster set Flag_UserID='" + Flag + "',UserId='" + userid + "',[Password]='" + rndNo + "',flagapprove='"+ 1 +"' where EMAIL='" + sendermailID + "'", conn);
                    cmd1.ExecuteNonQuery();
                    conn.Close();
                    Label1.Visible = true;
                    Label1.Text = "Mail Sent Successfully";
                }
                catch (Exception ex)
                {
                    Label1.Visible = true;
                    Label1.Text = ex.Message;
                }

            }
            i++;
        }
        gridbind();
    }
    protected void btnback_Click(object sender, EventArgs e)
    {
        Response.Redirect("index.aspx");
    }
    protected void gridApprove_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gridApprove.PageIndex = e.NewPageIndex;
        string Flag;
        Flag = "no";
        OleDbCommand cmd = new OleDbCommand("select YR_SPLSN,NameOnCertificate,Discipline,EMAIL from MemberMaster where Flag_UserId='" + Flag + "'", conn);
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        dap.Fill(dt);
        gridApprove.DataSource = dt;
        gridApprove.DataBind();


    }
}