using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Net.Mail;


public partial class student_tambah_penyelia : System.Web.UI.Page
{
    private void send_mail(String toEmail)
    {
        try
        {//("see.chloe09@gmail.com", "123456ab!");

            MailMessage mail = new MailMessage();
            SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
            SmtpClient sm = new SmtpClient("smtp-proxy.tm.net.my");
            mail.From = new MailAddress("your_email_address@gmail.com", "FTSM Admin");
            mail.To.Add(toEmail);
            mail.Subject = "Pertukaran status";
            mail.Body = "This is for testing SMTP mail from GMAIL";

            SmtpServer.Port = 587;
            SmtpServer.Credentials = new System.Net.NetworkCredential("see.chloe09@gmail.com", "123456ab!");
            SmtpServer.EnableSsl = true;

            SmtpServer.Send(mail);
            //sm.Send(mail);
            //MessageBox.Show("mail Send");
        }
        catch (Exception ex)
        {
            //MessageBox.Show(ex.ToString());
        }

    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["NoMatrik"] == null)
        {// need to login first
            Response.Redirect("mainframe.html");
            return;
        }
        String NoMatrik = Session["NoMatrik"].ToString();

        string connectionString = "datasource=localhost;username=root;password=root;database=tsftsm";
        MySqlConnection mySqlConnection = new MySqlConnection(connectionString);
        try

        {


            mySqlConnection.Open();
            String strQuery = "SELECT * FROM `pelajar`, `penyelia` WHERE `pelajar`.`Nama Penyelia Utama` = `penyelia`.`id` AND `NoMatrik` = '" + NoMatrik + "'";
            MySqlCommand mySqlCommand = new MySqlCommand(strQuery, mySqlConnection);
            MySqlDataReader results = mySqlCommand.ExecuteReader();

            if (results.HasRows && results.Read())
            {
                namapelajar.Text = (String)results["Nama"];
                nomatrik.Text = (String)results["NoMatrik"];
                notelefon.Text = (String)results["No.Telefon(R)"];
                emel.Text = (String)results["Email"];
                alamatsemasa.Text = (String)results["Alamat Semasa"];
                kumpulanpenyelidikan.Text = (String)results["Kumpulan Penyelidikan"];
                programpengajian.Text = (String)results["Nama Program"];
                jenispengajian.Text = (String)results["Jenis Pengajian"];
                bentukpendaftaran.Text = (String)results["Bentuk Pendaftaran"];
                jabatan.Text = (String)results["Jabatan"];
                penyelia.Text = (String)results["namaPenyelia"];
                tarikhpendaftaran.Text = ((DateTime)results["Tarikh Pendaftaran"]).ToString();
            }

        }
        finally
        {
            mySqlConnection.Close();
        }


        penyelialist.Items.Clear();
        try
        {
            mySqlConnection.Open();
            String strQuery = "SELECT id, namaPenyelia FROM `tsftsm`.`penyelia`";
            MySqlCommand mySqlCommand = new MySqlCommand(strQuery, mySqlConnection);
            MySqlDataReader results = mySqlCommand.ExecuteReader();
            ListItem litem;
            while (results.HasRows && results.Read())
            {
                UInt32 nId = (UInt32)results["id"];
                litem = new ListItem((String)results["namaPenyelia"], nId.ToString());
                penyelialist.Items.Add(litem);
            }

        }
        finally
        {
            mySqlConnection.Close();
        }



    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        String idPelajar = Session["NoMatrik"].ToString();
        String penyeliaBaru = Request.Form.Get("penyelialist").ToString();
        String alasan = TextBox1.Text;

        String emelPenyelia = emelpenyelia.Value.ToString();
        String strQuery = "insert into `permohonanpenambahanpenyelia` (`noMatrik`, `alasan`, `penyeliaUtama`, `penyeliaBaru`, `tarikhHantar`) " +
            "values ('" + idPelajar + "', '" + alasan + "' ,(select `Nama Penyelia Utama` from pelajar where `NoMatrik` = '" + idPelajar + "'), " + penyeliaBaru + ", now())";

        string connectionString = "datasource=localhost;username=root;password=root;database=tsftsm";
        MySqlConnection mySqlConnection = new MySqlConnection(connectionString);
        try
        {
            mySqlConnection.Open();
            MySqlCommand mySqlCommand = new MySqlCommand(strQuery, mySqlConnection);
            mySqlCommand.ExecuteNonQuery();

        }
        finally
        {
            mySqlConnection.Close();
        }

        send_mail(emelPenyelia);
        Response.Redirect("mohontukarberjaya.aspx");
    }
}