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 AddImage : System.Web.UI.Page
    {
        bool fileOK = false;
        Class1 obj = new Class1();
        string pdid;
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["Admin"] != null)
                {
                    BindDDLAlbum();
                    binddata();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }


            }
        }
        private void BindDDLAlbum()
        {
            string qrajneeti = "select pkid,AlbumName from newdelhibar_PhotoAlbumList order by cast(AlbumRank as int) Asc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                ddlPhotoAlbum.DataSource = dsrajneeti.Tables[0];
                ddlPhotoAlbum.DataTextField = "AlbumName";
                ddlPhotoAlbum.DataValueField = "pkid";
                ddlPhotoAlbum.DataBind();

                ddlPhotoAlbum.Items.Insert(0, "----- Select Album -----");
            }
        }
        private void binddata()
        {
            string qrajneeti = "select t1.pkid,t1.Name,t1.ImagePath,t1.ImageRank,t1.About,t2.pkid as AlbumId,t2.AlbumName from newdelhibar_imageGalleryList t1 inner join newdelhibar_PhotoAlbumList t2 on t1.Album=t2.pkid order by cast(t1.ImageRank as int) ";
            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 (Txtname.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Team Name.')</script>");
            }
            else if (ddlPhotoAlbum.SelectedItem.Text == "----- Select Album -----")
            {
                RegisterStartupScript("12", "<script>alert('Select Photo Album.')</script>");
            }
            else if (ddlst1.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Team Rank.')</script>");
            }
            else
            {
                if (Session["lblid"] == null)
                {

                    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 = { ".gif", ".png", ".jpeg", ".jpg" };
                            for (int i = 0; i < allowedExtensions.Length; i++)
                            {
                                if (ext == allowedExtensions[i])
                                {
                                    fileOK = true;
                                }
                            }
                            if (fileOK)
                            {
                                Path1 = "~/images/Upload/" + nname + ext;


                                connect.Open();

                                cmd = new SqlCommand("insert into newdelhibar_imageGalleryList(Name,ImagePath,ImageRank,About,Album) values(@Name,@ImagePath,@ImageRank,@About,@Album) ", connect);
                                cmd.Parameters.Add("@ImagePath", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@ImagePath"].Value = Path1;
                                cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@Name"].Value = Txtname.Text;
                                cmd.Parameters.Add("@ImageRank", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@ImageRank"].Value = ddlst1.Text;
                                cmd.Parameters.Add("@About", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@About"].Value = "None";//txtDescription.Text;
                                cmd.Parameters.Add("@Album", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@Album"].Value = ddlPhotoAlbum.SelectedItem.Value;
                                cmd.ExecuteNonQuery();

                                connect.Close();
                                FileUpload1.SaveAs(Server.MapPath("~/images/Upload/" + nname + ext));
                                RegisterStartupScript("12", "<script>alert('New Image Added.')</script>");
                                Path1 = ""; Txtname.Text = ""; //txtDescription.Text = "";
                                img.Visible = false; ddlst1.Enabled = true; ddlst1.Text = "";
                                binddata();
                            }
                            else
                            {
                                RegisterStartupScript("12", "<script>alert(' Select in correct Format')</script>");
                            }
                        }
                        else
                        {
                            RegisterStartupScript("12", "<script>alert(' Select minimum size of file')</script>");
                        }
                    }
                    else
                    {
                        RegisterStartupScript("12", "<script>alert(' Select File !')</script>");
                    }
                }
                else
                {
                    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 = { ".gif", ".png", ".jpeg", ".jpg" };
                            for (int i = 0; i < allowedExtensions.Length; i++)
                            {
                                if (ext == allowedExtensions[i])
                                {
                                    fileOK = true;
                                }
                            }
                            if (fileOK)
                            {
                                Path1 = "~/images/Upload/" + nname + ext;

                                connect.Open();
                                cmd = new SqlCommand("update newdelhibar_imageGalleryList set Name=@Name,ImagePath=@ImagePath,ImageRank=@ImageRank,About=@About,Album=@Album where pkId=" + Session["lblid"] + "", connect);
                                cmd.Parameters.Add("@ImagePath", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@ImagePath"].Value = Path1;
                                cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@Name"].Value = Txtname.Text;
                                cmd.Parameters.Add("@ImageRank", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@ImageRank"].Value = ddlst1.Text;
                                cmd.Parameters.Add("@About", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@About"].Value = "None";// txtDescription.Text;
                                cmd.Parameters.Add("@Album", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@Album"].Value = ddlPhotoAlbum.SelectedItem.Value;

                                cmd.ExecuteNonQuery();
                                connect.Close();
                                FileUpload1.SaveAs(Server.MapPath("~/images/Upload/" + nname + ext));
                                RegisterStartupScript("12", "<script>alert('Image is Updated.')</script>");
                                Path1 = ""; Txtname.Text = "";
                                img.Visible = false; ddlst1.Enabled = true; Session["lblid"] = null; ddlst1.Text = "";
                                binddata();
                            }
                            else
                            {
                                RegisterStartupScript("12", "<script>alert('Please Select in correct Format')</script>");


                            }
                        }
                        else
                        {
                            RegisterStartupScript("12", "<script>alert('Please Select minimum size of file')</script>");

                        }

                    }
                    else
                    {

                        connect.Open();
                        cmd = new SqlCommand("update newdelhibar_imageGalleryList set Name=@Name,ImagePath=@ImagePath,ImageRank=@ImageRank,About=@About,Album=@Album where pkId=" + Session["lblid"] + "", connect);

                        cmd.Parameters.Add("@ImagePath", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@ImagePath"].Value = img.ImageUrl.ToString();
                        cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@Name"].Value = Txtname.Text;
                        cmd.Parameters.Add("@ImageRank", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@ImageRank"].Value = ddlst1.Text;
                        cmd.Parameters.Add("@About", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@About"].Value = "None";// txtDescription.Text;
                        cmd.Parameters.Add("@Album", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@Album"].Value = ddlPhotoAlbum.SelectedItem.Value;

                        cmd.ExecuteNonQuery();
                        connect.Close();
                        RegisterStartupScript("12", "<script>alert('Image is Updated.')</script>");
                        Txtname.Text = "";
                        img.Visible = false; ddlst1.Enabled = true; Session["lblid"] = null; ddlst1.Text = ""; ddlst1.Text = "";
                        binddata();
                    }
                }
            }
        }
        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Edit")
            {
                img.Visible = true;
                Label lblid = (Label)e.Item.FindControl("lblid");
                Label Lblttl = (Label)e.Item.FindControl("lblname");
                Label Label1 = (Label)e.Item.FindControl("Label1");
                Label lbllst1 = (Label)e.Item.FindControl("lbllst1");
                Label lblAlbumName = (Label)e.Item.FindControl("lblAlbumName");
                Label lblAlbumID = (Label)e.Item.FindControl("lblAlbumID");

                Image lblimg = (Image)e.Item.FindControl("img");
                ddlst1.Text = lbllst1.Text;
                img.ImageUrl = lblimg.ImageUrl.ToString();
                Txtname.Text = Lblttl.Text;
                ddlPhotoAlbum.Text = lblAlbumID.Text;
                // txtDescription.Text = Label1.Text;
                img = lblimg;
                Session["lblid"] = lblid.Text;

            }
            if (e.CommandName == "delete")
            {
                string id = ((Label)e.Item.FindControl("lblid")).Text;
                string cmd = "delete from newdelhibar_imageGalleryList where pkid='" + id + "'";
                obj.DeleteRecord(cmd);

                binddata();
            }
        }

    }
}