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 AddGallary : 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)
                {
                    binddata();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            if (txtAlbumName.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Ablum Name.')</script>");
            }
            else if (txtAlbumRank.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Album 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/CoverPhoto/" + 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/CoverPhoto/" + nname + ext;


                                connect.Open();

                                cmd = new SqlCommand("insert into newdelhibar_PhotoAlbumList(AlbumName,CoverPhotoPath,AlbumRank) values(@AlbumName,@CoverPhotoPath,@AlbumRank) ", connect);
                                cmd.Parameters.Add("@CoverPhotoPath", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@CoverPhotoPath"].Value = Path1;
                                cmd.Parameters.Add("@AlbumName", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@AlbumName"].Value = txtAlbumName.Text;
                                cmd.Parameters.Add("@AlbumRank", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@AlbumRank"].Value = txtAlbumRank.Text;

                                cmd.ExecuteNonQuery();

                                connect.Close();
                                FileUpload1.SaveAs(Server.MapPath("~/images/CoverPhoto/" + nname + ext));
                                RegisterStartupScript("12", "<script>alert('New Album Added.')</script>");
                                Path1 = ""; txtAlbumName.Text = ""; txtAlbumRank.Text = "";
                                img.Visible = false; //txtAlbumRank.Enabled = true;
                                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/CoverPhoto/" + 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/CoverPhoto/" + nname + ext;

                                connect.Open();
                                cmd = new SqlCommand("update newdelhibar_PhotoAlbumList set AlbumName=@AlbumName,CoverPhotoPath=@CoverPhotoPath,AlbumRank=@AlbumRank where pkId=" + Session["lblid"] + "", connect);
                                cmd.Parameters.Add("@CoverPhotoPath", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@CoverPhotoPath"].Value = Path1;
                                cmd.Parameters.Add("@AlbumName", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@AlbumName"].Value = txtAlbumName.Text;
                                cmd.Parameters.Add("@AlbumRank", System.Data.SqlDbType.VarChar);
                                cmd.Parameters["@AlbumRank"].Value = txtAlbumRank.Text;

                                cmd.ExecuteNonQuery();
                                connect.Close();
                                FileUpload1.SaveAs(Server.MapPath("~/images/CoverPhoto/" + nname + ext));
                                RegisterStartupScript("12", "<script>alert('Album is Updated.')</script>");
                                Path1 = ""; txtAlbumName.Text = ""; txtAlbumRank.Text = "";
                                img.Visible = false; Session["lblid"] = null;
                                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_PhotoAlbumList set AlbumName=@AlbumName,CoverPhotoPath=@CoverPhotoPath,AlbumRank=@AlbumRank where pkId=" + Session["lblid"] + "", connect);
                        //cmd.Parameters.Add("@pic", System.Data.SqlDbType.VarChar);
                        //cmd.Parameters["@pic"].Value = img.ImageUrl.ToString();
                        //cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                        //cmd.Parameters["@Name"].Value = Txtname.Text;
                        //cmd.Parameters.Add("@rankng", System.Data.SqlDbType.VarChar);
                        //cmd.Parameters["@rankng"].Value = ddlst1.Text;
                        //cmd.Parameters.Add("@About", System.Data.SqlDbType.VarChar);
                        //cmd.Parameters["@About"].Value = TextBox1.Text;

                        cmd.Parameters.Add("@CoverPhotoPath", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@CoverPhotoPath"].Value = img.ImageUrl.ToString();
                        cmd.Parameters.Add("@AlbumName", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@AlbumName"].Value = txtAlbumName.Text;
                        cmd.Parameters.Add("@AlbumRank", System.Data.SqlDbType.VarChar);
                        cmd.Parameters["@AlbumRank"].Value = txtAlbumRank.Text;

                        cmd.ExecuteNonQuery();
                        connect.Close();
                        RegisterStartupScript("12", "<script>alert('Album is Updated.')</script>");
                        txtAlbumName.Text = ""; txtAlbumRank.Text = "";
                        img.Visible = false; Session["lblid"] = null;


                        binddata();
                    }
                }
            }
        }
        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Edit")
            {
                img.Visible = true;
                Label lblid = (Label)e.Item.FindControl("lblid");
                Label lblAlbumName = (Label)e.Item.FindControl("lblAlbumName");
                Label lblAlbumRank = (Label)e.Item.FindControl("lblAlbumRank");
                // Label lbllst1 = (Label)e.Item.FindControl("lbllst1");
                Image lblimg = (Image)e.Item.FindControl("img");

                txtAlbumRank.Text = lblAlbumRank.Text;
                img.ImageUrl = lblimg.ImageUrl.ToString();
                txtAlbumName.Text = lblAlbumName.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_PhotoAlbumList where pkid='" + id + "'";
                obj.DeleteRecord(cmd);

                binddata();
            }
        }
        private void binddata()
        {
            string qrajneeti = "select * from newdelhibar_PhotoAlbumList order by AlbumRank Asc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                rptrBannr.DataSource = dsrajneeti;
                rptrBannr.DataBind();
            }
        }
    }
}