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

namespace Newdelhibarassocia.cms
{
    public partial class NDBAForm : 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 (Session["Admin"] != null)
                {
                    binddata();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }


            }
        }

        private void binddata()
        {
            string qrajneeti = "select * from newdelhibar_NDBAForm order by id ";
            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)
        {
            if (txttitleForPDF.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter NDBA Form Title.')</script>");
            }

            else
            {
                if (HiddenField1.Value == "")
                {
                    if (FileUpload1.HasFile)
                    {
                        if (FileUpload1.PostedFile.ContentLength < 5242880)
                        {
                            string nname = DateTime.Now.Ticks.ToString();
                            string ext = Path.GetExtension(FileUpload1.FileName).ToLower();

                            string Path1 = "~/images/Upload/" + nname + ext;
                            string[] allowedExtensions = { ".doc", ".pdf", ".xps", ".docx", ".docxx" };
                            for (int i = 0; i < allowedExtensions.Length; i++)
                            {
                                if (ext == allowedExtensions[i])
                                {
                                    fileOK = true;
                                }
                            }
                            if (fileOK)
                            {
                                cmd = new SqlCommand("insert into newdelhibar_NDBAForm(title,[Type1],pdfPath) values(@title,@Type,@pdfPath) ", connect);

                                cmd.Parameters.AddWithValue("@title", txttitleForPDF.Text);
                                cmd.Parameters.AddWithValue("@Type", "PDF");
                                cmd.Parameters.AddWithValue("@pdfPath", Path1);

                                try
                                {
                                    connect.Open();
                                    cmd.ExecuteNonQuery();
                                    connect.Close();
                                    FileUpload1.SaveAs(Server.MapPath(Path1));
                                    RegisterStartupScript("12", "<script>alert('NDBA Form Insert Successfully')</script>");
                                    binddata();
                                    txttitleForPDF.Text = "";
                                }
                                catch
                                {
                                    RegisterStartupScript("12", "<script>alert(' Try After Some Time..')</script>");
                                }
                            }
                            else
                            {
                                RegisterStartupScript("12", "<script>alert(' Select in correct Format')</script>");
                            }
                        }

                    }
                    else
                    {
                        Response.Write("<script>alert('first select PDF file')</script>");
                    }
                }
                else
                {
                    bindedit();
                }
            }


        }

        private void bindedit()
        {
            if (FileUpload1.HasFile)
            {
                if (FileUpload1.PostedFile.ContentLength < 5242880)
                {
                    string nname = DateTime.Now.Ticks.ToString();
                    string ext = Path.GetExtension(FileUpload1.FileName).ToLower();

                    string Path1 = "~/images/Upload/" + nname + ext;
                    string[] allowedExtensions = { ".doc", ".pdf", ".xps", ".docx", ".docxx" };
                    for (int i = 0; i < allowedExtensions.Length; i++)
                    {
                        if (ext == allowedExtensions[i])
                        {
                            fileOK = true;
                        }
                    }
                    if (fileOK)
                    {
                        cmd = new SqlCommand("update newdelhibar_NDBAForm set title=@title,pdfPath=@pdfPath where id=" + HiddenField1.Value + " ", connect);
                        cmd.Parameters.AddWithValue("@title", txttitleForPDF.Text);
                        cmd.Parameters.AddWithValue("@Type", "PDF");
                        cmd.Parameters.AddWithValue("@pdfPath", Path1);

                        try
                        {
                            connect.Open();
                            cmd.ExecuteNonQuery();
                            connect.Close();
                            FileUpload1.SaveAs(Server.MapPath(Path1));
                            RegisterStartupScript("12", "<script>alert('NDBA Form Update Successfully')</script>");
                            binddata(); Image1.Visible = false; txttitleForPDF.Text = "";
                        }
                        catch
                        {
                            RegisterStartupScript("12", "<script>alert(' Try After Some Time..')</script>");
                        }
                    }
                    else
                    {
                        RegisterStartupScript("12", "<script>alert(' Select in correct Format')</script>");
                    }

                }

            }
            else
            {
                cmd = new SqlCommand("update newdelhibar_NDBAForm set title=@title where id=" + HiddenField1.Value + " ", connect);
                cmd.Parameters.AddWithValue("@title", txttitleForPDF.Text);

                try
                {
                    connect.Open();
                    cmd.ExecuteNonQuery();
                    connect.Close();
                    RegisterStartupScript("12", "<script>alert('NDBA Form Update Successfully')</script>");
                    binddata(); Image1.Visible = false; txttitleForPDF.Text = "";
                }
                catch
                {
                    RegisterStartupScript("12", "<script>alert(' Try After Some Time..')</script>");
                }

            }
        }
        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");
                HiddenField1.Value = lblid.Text; Image1.Visible = true;
                txttitleForPDF.Text = Label2.Text;


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

                string cmd = "delete from newdelhibar_NDBAForm where title='" + Label2.Text + "'";
                obj.DeleteRecord(cmd);
                binddata();
            }
        }


        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;

            //}
        }

    }
}