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.Net.Mail;
using System.Data.SqlClient;

public partial class WriteRejectReasonAndMail : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        lblManagerNow.Text = Context.User.Identity.Name;
        lblContributor.Text = Request.QueryString["Contributor"];
        lblComponentID.Text = Request.QueryString["ComponentID"];
        lblVersion.Text = Request.QueryString["Version"];
        lblFramework.Text = Request.QueryString["Framework"];
        lblComponentName.Text = queryComponentNameByComponentID(lblComponentID.Text);

    }

    #region HeEmail
    private void sendEMail(string strMailBody, string strMailToAddress) 
    {

        //PɱHe޲z̻PϥΪ  
        String strTo = "<jiing.deng@cathaybk.com.tw>;" + queryContributorEmailByComponentID(lblComponentID.Text);            ;
        //ӷO@Τ޲ztΩM޲z
        String strFrom="<CCOM@cathaybk.com.tw>";
        String strMailSubject = "[@Τ]@Τ޲ztΪڵHI";

        if(String.IsNullOrEmpty(strMailBody))
        {
         strMailBody = "oOѦ@Τ޲ztγq<b>T</b><br>"
             + "ܩpAڬO޲z̡G<b>" + lblManagerNow.Text  + "</b>  ڵz󦨬@ΤAzTpUG<br>"
             + "ID<b>G" + lblComponentID.Text + "</b><br>"
             + "W<b>G" + lblComponentName.Text + "</b><br>"
             + "󪩥G<b>" + lblVersion.Text + "</b><br>"
             + "ج[G<b>" + lblFramework.Text + "</b><br>"
             + "^m̡G<b>" + lblContributor.Text + "</b><br>";
        }
        System.Net.Mail.SmtpClient client = new SmtpClient();
        client.Host = "PIEX2K05.cathaybk.intra.uwccb";
        client.Port = 25;
        client.UseDefaultCredentials = false;
        client.Credentials = new System.Net.NetworkCredential("uid", "pwd");  //uid, pwd please replace as yours
        client.DeliveryMethod = SmtpDeliveryMethod.Network; 

        System.Net.Mail.MailMessage message = new MailMessage(strFrom, strTo, strMailSubject,strMailBody);
        message.BodyEncoding = System.Text.Encoding.UTF8;
        message.IsBodyHtml = true;

        try
        {
            client.Send(message);
            Response.Write("<font color=\"blue\">Email successfully sent.</font>");
        }
        catch (Exception ex)
        {
            Response.Write("Send Email Failed." + ex.ToString()); ;
        }
    }
    #endregion

    #region HcomponentID d߰^mID  
    private string queryContributorEmailByComponentID(string strComponentID)
    {
        string strEmail = "";
        SqlConnection conn = null;
        SqlCommand cmd = null;
        SqlDataReader reader = null;
        try
        {
            ConnectionStringSettings connSettings = ConfigurationManager.ConnectionStrings["CCSConnectionString"];
            string CCSConnectionString = connSettings.ConnectionString;

            conn = new SqlConnection(CCSConnectionString);
            cmd = new SqlCommand("SELECT EMAIL FROM COMPONENT WHERE COMPONENT_ID ='" + strComponentID + "'", conn);

            conn.Open();
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                strEmail = reader["EMAIL"].ToString().Trim();
            }
        }
        catch (Exception ex)
        {
            showMsg(ex.Message);
        }
        finally
        {
            reader.Close();
            conn.Close();
        }

        return strEmail;
    }
    #endregion

    #region HcomponentID d W
    private string queryComponentNameByComponentID(string strComponentID)
    {
        string strComponentName = "";
        SqlConnection conn = null;
        SqlCommand cmd = null;
        SqlDataReader reader = null;
        try
        {
            ConnectionStringSettings connSettings = ConfigurationManager.ConnectionStrings["CCSConnectionString"];
            string CCSConnectionString = connSettings.ConnectionString;

            conn = new SqlConnection(CCSConnectionString);
            cmd = new SqlCommand("SELECT NAME FROM COMPONENT WHERE COMPONENT_ID ='" + strComponentID + "'", conn);

            conn.Open();
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                strComponentName = reader["NAME"].ToString().Trim();
            }
        }
        catch (Exception ex)
        {
            showMsg(ex.Message);
        }
        finally
        {
            reader.Close();
            conn.Close();
        }

        return strComponentName;
    }
    #endregion


    #region sREJECT_LISTAðOU򥻸T
    private void UpdateRejectListAndRecordInfo() 
    { 

    }
    #endregion


    protected void btnMail_Click(object sender, EventArgs e)
    {
        //dߥثe޲z̪email


        string strMailBody = "oOѦ@Τ޲ztγq<b>T</b><br>"
              + "ܩpAڬO޲z̡G<b>" + lblManagerNow.Text + "</b>  ڵz󦨬@ΤAzTpUG<br>"
              + "ID<b>G" + lblComponentID.Text + "</b><br>"
              + "W<b>G" + lblComponentName.Text + "</b><br>"
              + "󪩥G<b>" + lblVersion.Text + "</b><br>"
              + "ج[G<b>" + lblFramework.Text + "</b><br>"
              + "^m̡G<b>" + lblContributor.Text + "</b><br>";
        sendEMail(strMailBody + "zѦpUG<br>" +tbxReasonOfReject.Text ,@"jiing.deng@cathaybk.com.tw");



    }


    protected void showMsg(string AlertMessage)
    {
        Literal txtMsg = new Literal();
        txtMsg.Text = "<script>alert('" + AlertMessage + "')</script>" + "<br/>";
        Page.Controls.Add(txtMsg);
    }

}