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

namespace Newdelhibarassocia.cms
{
    public partial class NoticeBoard : System.Web.UI.Page
    {
        bool fileOK = false;
        Class1 obj = new Class1();
        string pdid;
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd;
        public DataTable dt2;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (AjaxFileUpload11.IsInFileUploadPostBack)
                {
                }
                else
                {
                    Session["dtTest2"] = null;
                }

                if (Session["Admin"] != null)
                {
                    binddata();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }


            }
        }

        private void binddata()
        {
            string qrajneeti = "select * from newdelhibar_NoticeBoard order by pkid ";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                rptrBannr.DataSource = dsrajneeti;
                rptrBannr.DataBind();
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            //For PDF
            if (txttitleForPDF.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Team Name.')</script>");
            }

            else
            {

                //if(rdbPDF.Checked)
                //{
                if ((FileUpload1.HasFile) && (FileUpload1.PostedFile != null) && (FileUpload1.PostedFile.ContentLength > 0))
                {
                    string fn = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
                    string temp = Guid.NewGuid() + fn;
                    string SName = (@"~/images/Nboard/") + temp;
                    string FName = (@"images/Nboard/") + temp;

                    string SaveLocation = Server.MapPath(SName);
                    try
                    {
                        FileUpload1.PostedFile.SaveAs(SaveLocation);

                        ViewState["FName"] = FName;
                        //Response.Write("The file has been uploaded.");
                    }
                    catch (Exception ex)
                    {
                        // Response.Write("Error: " + ex.Message);
                        //Note: Exception.Message returns a detailed message that describes the current exception. 
                        //For security reasons, we do not recommend that you return Exception.Message to end users in 
                        //production environments. It would be better to put a generic error message. 
                    }
                }
                else
                {
                    Response.Write("<script>alert('first select PDF file')</script>");
                }
                //}


                if (Session["dtTest2"] == null)
                {
                    //Insert
                    cmd = new SqlCommand("insert into newdelhibar_NoticeBoard(title,[Type],pdfPath) values(@title,@Type,@pdfPath) ", connect);

                    cmd.Parameters.AddWithValue("@title", txttitleForPDF.Text);

                    //if(rdbPDF.Checked)
                    //{
                    cmd.Parameters.AddWithValue("@Type", "PDF");
                    cmd.Parameters.AddWithValue("@pdfPath", ViewState["FName"].ToString());

                    //}
                    //else if(rdbImages.Checked)
                    //{
                    //    cmd.Parameters.AddWithValue("@Type", "Images");
                    //    cmd.Parameters.AddWithValue("@pdfPath", "");

                    //}
                    //else
                    //{
                    //    Response.Write("<script>alert('Pelese select type of notice')</script>");
                    //    return;
                    //}



                    try
                    {
                        connect.Open();
                        cmd.ExecuteNonQuery();
                        connect.Close();
                        fileOK = true;
                    }
                    catch
                    {
                        fileOK = false;
                    }

                    RegisterStartupScript("12", "<script>alert('New Notice Added.')</script>");
                    txttitleForPDF.Text = ""; Session["dtTest2"] = null;
                    binddata();
                    //}
                }
                else
                {
                    //Updates
                    // HiddenField HiddenField1 = (HiddenField)rptrBannr.FindControl("HiddenField1");

                    string HiddenField1Type = ViewState["HiddenField1Type"].ToString();
                    string HiddenField2PDFPath = ViewState["HiddenField1Type"].ToString();




                    connect.Open();
                    cmd = new SqlCommand("update newdelhibar_NoticeBoardImg set title=@title,[Type]=@Type where title=" + txttitleForPDF.Text + "", connect);
                    cmd.Parameters.Add("@title", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@title"].Value = txttitleForPDF.Text;

                    //if (rdbPDF.Checked)
                    //{
                    //    cmd.Parameters.AddWithValue("@Type", HiddenField1Type);
                    //    cmd.Parameters.AddWithValue("@pdfPath", HiddenField2PDFPath);

                    //}
                    //else if (rdbImages.Checked)
                    //{
                    //    cmd.Parameters.AddWithValue("@Type", HiddenField1Type);
                    //    cmd.Parameters.AddWithValue("@pdfPath", "");

                    //}
                    //else
                    //{
                    //    Response.Write("<script>alert('Pelese select type of notice')</script>");
                    //    return;
                    //}


                    try
                    {
                        connect.Open();
                        cmd.ExecuteNonQuery();
                        connect.Close();
                        fileOK = true;
                    }
                    catch
                    {
                        fileOK = false;
                    }
                    if (fileOK)
                    {
                        SqlCommand cmddelte = new SqlCommand("delete from [dbo].[newdelhibar_NoticeBoardImg] where number='" + txttitleForPDF.Text + "'", connect);

                        if (ConnectionState.Closed == connect.State)
                        {
                            connect.Open();
                        }
                        cmddelte.ExecuteNonQuery();
                        if (ConnectionState.Open == connect.State)
                        {
                            connect.Close();
                        }
                        if (Session["dtTest2"] != null)
                        {
                            dt2 = (DataTable)Session["dtTest2"];
                            int countrow = dt2.Rows.Count;
                            if (dt2 != null && dt2.Rows.Count > 0)
                            {
                                for (int rowi = 0; rowi < countrow; rowi++)
                                {
                                    SqlCommand cmdpici = new SqlCommand("insert into newdelhibar_NoticeBoardImg(number,attch) values(@number,@attch) ", connect);
                                    cmdpici.Parameters.Add("@attch", System.Data.SqlDbType.VarChar);
                                    cmdpici.Parameters["@attch"].Value = dt2.Rows[rowi][2].ToString();
                                    cmdpici.Parameters.Add("@number", System.Data.SqlDbType.VarChar);
                                    cmdpici.Parameters["@number"].Value = txttitleForPDF.Text;

                                    if (ConnectionState.Closed == connect.State)
                                    {
                                        connect.Open();
                                    }
                                    cmdpici.ExecuteNonQuery();
                                    if (ConnectionState.Open == connect.State)
                                    {
                                        connect.Close();
                                    }

                                }
                            }
                        }
                        RegisterStartupScript("12", "<script>alert('New Image Added.')</script>");
                        txttitleForPDF.Text = ""; Session["dtTest2"] = null;
                        binddata();
                    }

                    btnSave.Text = "Create Notice";
                    HiddenField1IDForUpdate.Value = string.Empty;

                }

            }


        }

        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Edit")
            {
                Label lblid = (Label)e.Item.FindControl("lblid");
                Label Label2 = (Label)e.Item.FindControl("Label2");

                HiddenField1IDForUpdate.Value = lblid.Text;
                HiddenField HiddenField1Type = (HiddenField)e.Item.FindControl("HiddenField1Type");
                if (HiddenField1Type.Value == "PDF")
                {


                    txttitleForPDF.Text = Label2.Text;
                    btnSave.Text = "Update Notice";

                    txttitleForImages.Text = string.Empty;
                    BtnCreteNoticForImages.Text = "Create Notice";
                }
                else
                {
                    txttitleForImages.Text = Label2.Text;
                    BtnCreteNoticForImages.Text = "Update Notice";

                    txttitleForPDF.Text = string.Empty;
                    btnSave.Text = "Create Notice";

                }

                HiddenField HiddenField2PDFPath = (HiddenField)e.Item.FindControl("HiddenField2PDFPath");
                ViewState["HiddenField1Type"] = HiddenField1Type.Value;
                ViewState["HiddenField2PDFPath"] = HiddenField2PDFPath.Value;



                //if (HiddenField1Type.Value=="PDF")
                //{
                //    rdbPDF.Checked=true;
                //    rdbPDF_CheckedChanged(null, null);
                //}
                //else
                //{
                //    rdbImages.Checked = true;
                //    rdbImages_CheckedChanged(null,null);
                //}

                if (Session["dtTest2"] == null)
                {
                    DataTable dt2 = new DataTable();
                    SqlDataAdapter da = new SqlDataAdapter("Select id,number,attch from newdelhibar_NoticeBoardImg where number= '" + lblid.Text + "'", connect);
                    // Fill the DataSet with data.
                    DataSet ds = new DataSet();
                    da.Fill(ds, "products");
                    dt2 = ds.Tables["products"];
                    Rptrpic.Visible = true;
                    Rptrpic.DataSource = dt2;
                    Rptrpic.DataBind();
                    Session["dtTest2"] = dt2;


                }
                else
                {
                    Rptrpic.Visible = true;
                    Rptrpic.DataSource = Session["dtTest2"];
                    Rptrpic.DataBind();
                }



            }
            if (e.CommandName == "delete")
            {
                Label Label2 = (Label)e.Item.FindControl("Label2");

                string cmd = "delete from newdelhibar_NoticeBoard where title='" + Label2.Text + "'";
                obj.DeleteRecord(cmd);
                string cmd1 = "delete from newdelhibar_NoticeBoardImg where number='" + Label2.Text + "'";
                obj.DeleteRecord(cmd1);
                binddata();
            }
        }
        protected void AjaxFileUpload11_Upload(object sender, AjaxFileUploadEventArgs e)
        {
            // connect.Open();
            string filepath = (Server.MapPath("~/images/Nboard/") + Guid.NewGuid() + System.IO.Path.GetFileName(e.FileName));
            AjaxFileUpload11.SaveAs(filepath);
            string fl = filepath.Substring(filepath.LastIndexOf("\\"));
            string[] split = fl.Split('\\');
            string newpath = split[1];
            string imagepath = "~/images/Nboard/" + newpath;
            if (imagepath != null)
            {
                DataTable dt2 = new DataTable();
                if (Session["dtTest2"] == null)
                {
                    dt2.Columns.Add("id", typeof(Int32));
                    dt2.Columns.Add("number", typeof(string));
                    dt2.Columns.Add("attch", typeof(string));
                }

                if (Session["dtTest2"] != null)
                {
                    dt2 = (DataTable)Session["dtTest2"];
                }

                DataRow dtrow = dt2.NewRow();
                if (Session["intvalue"] == null)
                {
                    dtrow["id"] = 1;
                }
                else
                {
                    dtrow["id"] = Convert.ToInt32(Session["intvalue"]) + 1;
                }

                dtrow["attch"] = imagepath;
                dt2.Rows.Add(dtrow);
                Session["intvalue"] = dtrow["id"];
                Session["dtTest2"] = dt2;
                Rptrpic.Visible = true;
                Rptrpic.DataSource = dt2;
                Rptrpic.DataBind();
            }

        }


        protected void Rptrpic_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Delete")
            {
                if (Session["dtTest2"] != null)
                {
                    Label lblid1 = e.Item.FindControl("Label1") as Label;
                    dt2 = (DataTable)Session["dtTest2"];

                    dt2.Rows.RemoveAt(Convert.ToInt32(lblid1.Text) - 1);
                    Rptrpic.DataSource = dt2;
                    Rptrpic.DataBind();

                }
            }
        }
        protected void rdbPDF_CheckedChanged(object sender, EventArgs e)
        {
            //if(rdbPDF.Checked)
            //{
            //    pnlPDF.Visible = true;
            //    pnlImage.Visible = false;
            //    FileUpload1 = null;
            //}
        }
        protected void rdbImages_CheckedChanged(object sender, EventArgs e)
        {
            //if (rdbImages.Checked)
            //{
            //    pnlImage.Visible = true;
            //    pnlPDF.Visible = false;
            //    FileUpload1 = null;

            //}
        }
        protected void BtnCreteNoticForImages_Click(object sender, EventArgs e)
        {
            //For Images
            if (txttitleForImages.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Notice Title.')</script>");
            }

            else
            {

                if (HiddenField1IDForUpdate.Value == null || HiddenField1IDForUpdate.Value == "")
                {
                    //Insert
                    cmd = new SqlCommand("insert into newdelhibar_NoticeBoard(title,[Type]) values(@title,@Type) ", connect);

                    cmd.Parameters.AddWithValue("@title", txttitleForImages.Text);

                    cmd.Parameters.AddWithValue("@Type", "Images");
                    // cmd.Parameters.AddWithValue("@pdfPath", "");

                    try
                    {
                        connect.Open();
                        cmd.ExecuteNonQuery();
                        connect.Close();
                        fileOK = true;
                    }
                    catch
                    {
                        fileOK = false;
                    }
                    if (fileOK)
                    {
                        int MaxID = 0;
                        if (Session["dtTest2"] != null)
                        {

                            string qrajneetiMaxID = "select max(pkid) from newdelhibar_NoticeBoard";
                            DataSet dsrajneetiMaxID = obj.ReturnDataSet(qrajneetiMaxID);
                            if (dsrajneetiMaxID != null && dsrajneetiMaxID.Tables[0].Rows.Count > 0)
                            {
                                MaxID = Convert.ToInt32(dsrajneetiMaxID.Tables[0].Rows[0][0]);
                            }


                            dt2 = (DataTable)Session["dtTest2"];
                            int countrow = dt2.Rows.Count;
                            if (dt2 != null && dt2.Rows.Count > 0)
                            {
                                for (int rowi = 0; rowi < countrow; rowi++)
                                {
                                    SqlCommand cmdpici = new SqlCommand("insert into newdelhibar_NoticeBoardImg(number,attch) values(@number,@attch) ", connect);
                                    cmdpici.Parameters.Add("@attch", System.Data.SqlDbType.VarChar);
                                    cmdpici.Parameters["@attch"].Value = dt2.Rows[rowi][2].ToString();
                                    cmdpici.Parameters.Add("@number", System.Data.SqlDbType.VarChar);
                                    cmdpici.Parameters["@number"].Value = MaxID;

                                    if (ConnectionState.Closed == connect.State)
                                    {
                                        connect.Open();
                                    }
                                    cmdpici.ExecuteNonQuery();
                                    if (ConnectionState.Open == connect.State)
                                    {
                                        connect.Close();
                                    }

                                }
                            }
                        }
                        RegisterStartupScript("12", "<script>alert('New Notice Added.')</script>");
                        txttitleForImages.Text = ""; Session["dtTest2"] = null;
                        Rptrpic.Visible = false;
                        Rptrpic.DataSource = null;
                        Rptrpic.DataBind();

                        binddata();
                    }
                }
                else
                {
                    //Updates
                    // HiddenField HiddenField1 = (HiddenField)rptrBannr.FindControl("HiddenField1");

                    string HiddenField1Type = ViewState["HiddenField1Type"].ToString();
                    string HiddenField2PDFPath = ViewState["HiddenField1Type"].ToString();




                    // connect.Open();
                    cmd = new SqlCommand("update newdelhibar_NoticeBoard set title=@title,[Type]=@Type where pkid=" + HiddenField1IDForUpdate.Value + "", connect);
                    cmd.Parameters.Add("@title", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@title"].Value = txttitleForImages.Text;
                    cmd.Parameters.Add("@Type", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Type"].Value = "Images";
                    try
                    {
                        connect.Open();
                        cmd.ExecuteNonQuery();
                        connect.Close();
                        fileOK = true;
                    }
                    catch
                    {
                        fileOK = false;
                    }
                    if (fileOK)
                    {
                        SqlCommand cmddelte = new SqlCommand("delete from [dbo].[newdelhibar_NoticeBoardImg] where number='" + HiddenField1IDForUpdate.Value + "'", connect);

                        if (ConnectionState.Closed == connect.State)
                        {
                            connect.Open();
                        }
                        cmddelte.ExecuteNonQuery();
                        if (ConnectionState.Open == connect.State)
                        {
                            connect.Close();
                        }
                        if (Session["dtTest2"] != null)
                        {
                            dt2 = (DataTable)Session["dtTest2"];
                            int countrow = dt2.Rows.Count;
                            if (dt2 != null && dt2.Rows.Count > 0)
                            {
                                for (int rowi = 0; rowi < countrow; rowi++)
                                {
                                    SqlCommand cmdpici = new SqlCommand("insert into newdelhibar_NoticeBoardImg(number,attch) values(@number,@attch) ", connect);
                                    cmdpici.Parameters.Add("@attch", System.Data.SqlDbType.VarChar);
                                    cmdpici.Parameters["@attch"].Value = dt2.Rows[rowi][2].ToString();
                                    cmdpici.Parameters.Add("@number", System.Data.SqlDbType.VarChar);
                                    cmdpici.Parameters["@number"].Value = HiddenField1IDForUpdate.Value;

                                    if (ConnectionState.Closed == connect.State)
                                    {
                                        connect.Open();
                                    }
                                    cmdpici.ExecuteNonQuery();
                                    if (ConnectionState.Open == connect.State)
                                    {
                                        connect.Close();
                                    }

                                }
                            }
                        }
                        RegisterStartupScript("12", "<script>alert('New Image Added.')</script>");
                        txttitleForImages.Text = ""; Session["dtTest2"] = null;
                        binddata();


                    }

                    BtnCreteNoticForImages.Text = "Create Notice";
                    HiddenField1IDForUpdate.Value = string.Empty;
                }

            }

        }
    }
}