using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Security;

namespace GuildWars.Class_Forum
{
    public partial class Message : System.Web.UI.Page
    {
        int SujetsId = -1;
        protected void Page_Load(object sender, EventArgs e)
        {
            bool Valider = false;
            if (Request.QueryString["SujetsId"] != null)
            {
                Valider = int.TryParse(Request.QueryString["SujetsId"], out SujetsId);
            }
            if (!Page.IsPostBack)
            {

                if (Valider == true)
                {
                    Remplir_Message();
                }

                if (HttpContext.Current.User.Identity.IsAuthenticated == true)
                {
                    Reply.Visible = true;
                }
            }
        }

        public void Remplir_Message()
        {
            DataSet AdminDataSet = new DataSet();
            SqlDataAdapter AdminAdapteur = new SqlDataAdapter("Select * From Message where Fk_SujetsId ='" + SujetsId.ToString() + "'", ConfigurationManager.ConnectionStrings["Gw2_Guild"].ConnectionString);
            AdminAdapteur.Fill(AdminDataSet);
            lv_Sujet.DataSource = AdminDataSet.Tables[0];
            lv_Sujet.DataBind();

            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Gw2_Guild"].ConnectionString);
            connection.Open();
            SqlCommand myCommand;
            SqlDataReader myDataReader;

            myCommand = new SqlCommand("SELECT SujetsName FROM Sujets Where SujetsId ='" + SujetsId.ToString() + "'", connection);
            myDataReader = myCommand.ExecuteReader();

            String SujetsName = "";
            while (myDataReader.Read())
            {
                SujetsName = (String)myDataReader["SujetsName"];

            }

            myDataReader.Close();
            connection.Close();

            Lbl_Titre.Text = SujetsName;

        }

        protected void Cmd_Reply_Click(object sender, EventArgs e)
        {

            MembershipUser u;
            u = Membership.GetUser(User.Identity.Name);

            SqlConnection Myconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Gw2_Guild"].ConnectionString);
            Myconnection.Open();
            DataSet MyDataSet = new DataSet();

            string NewPost = string.Format("INSERT INTO Message (UserId,Auteur,ThumbsUp,ThumbsDown,MessageDate,Mess,Fk_SujetsId) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", u.ProviderUserKey, u.UserName, 1, 1, "2011 - 03 - 03", Txt_Reply.Value, SujetsId.ToString());
            SqlCommand addcomand2 = new SqlCommand(NewPost, Myconnection);
            addcomand2.ExecuteNonQuery();
            Myconnection.Close();
            Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);


        }

        protected void lv_Sujet_ItemDeleting(object sender, ListViewDeleteEventArgs e)
        {

            try
            {

                int id = e.ItemIndex;
                String MessageId = ((Label)(lv_Sujet.Items[id].FindControl("MessageId"))).Text;
                SqlConnection Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Gw2_Guild"].ConnectionString);
                Cn.Open();
                string query = string.Format("Delete From Message where MessageId={0}", MessageId);
                SqlCommand Com = new SqlCommand(query, Cn);
                Com.ExecuteNonQuery();
                Cn.Close();
                lv_Sujet.EditIndex = -1;
                Remplir_Message();
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }

        protected void lv_Sujet_ItemEditing(object sender, ListViewEditEventArgs e)
        {
            lv_Sujet.EditIndex = e.NewEditIndex;
            Remplir_Message();
        }

        protected void lv_Sujet_ItemUpdating(object sender, ListViewUpdateEventArgs e)
        {
            try
            {
                int id = e.ItemIndex;
                string MessageID = ((Label)(lv_Sujet.Items[id].FindControl("Lbl_MessageId"))).Text;
                string query = string.Format(@"Update Message Set Mess = '{0}' Where MessageID = '{1}'",
                    GetRowField(id, "Txt_Message"),
                    MessageID);

                SqlConnection Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Gw2_Guild"].ConnectionString);
                Cn.Open();
                SqlCommand Com = new SqlCommand(query, Cn);
                Com.ExecuteNonQuery();
                Cn.Close();
                lv_Sujet.EditIndex = -1;
                Remplir_Message();
            }
            catch
            {

            }
        }

        public string GetRowField(int id, string field)
        {
            return ((TextBox)(lv_Sujet.Items[id].FindControl(field))).Text;
        }

        protected void lv_Sujet_ItemCanceling(object sender, ListViewCancelEventArgs e)
        {
            lv_Sujet.EditIndex = -1;
            Remplir_Message();
        }

        protected void lv_Sujet_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}