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;

namespace Newdelhibarassocia.cms
{
    public partial class VideoGallery : 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)
                {
                    Session["lblid"] = null;
                    binddata();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }
            }
        }
        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Edit")
            {
                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("Label1");
                txtAlbumRank.Text = lblAlbumRank.Text;
                txtAlbumName.Text = lblAlbumName.Text;
                txtvdo.Text = lbllst1.Text;
                Session["lblid"] = lblid.Text;

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

                binddata();
            }
        }

        private void binddata()
        {
            string qrajneeti = "select * from [newdelhibar_VideoAlbumList] order by AlbumRank Asc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                rptrBannr.DataSource = dsrajneeti;
                rptrBannr.DataBind();
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            if (txtAlbumName.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Video Name.')</script>");
            }
            else if (txtAlbumRank.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Video Rank.')</script>");
            }
            else
            {
                if (Session["lblid"] == null)
                {

                    connect.Open();
                    cmd = new SqlCommand("insert into [newdelhibar_VideoAlbumList](AlbumName,CoverPhotoPath,AlbumRank) values(@AlbumName,@CoverPhotoPath,@AlbumRank) ", connect);
                    cmd.Parameters.Add("@CoverPhotoPath", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@CoverPhotoPath"].Value = txtvdo.Text;
                    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('New Video Album Added.')</script>");
                    txtAlbumName.Text = ""; txtAlbumRank.Text = ""; txtvdo.Text = "";
                    binddata();
                }
                else
                {
                    connect.Open();
                    cmd = new SqlCommand("update newdelhibar_VideoAlbumList set AlbumName=@AlbumName,CoverPhotoPath=@CoverPhotoPath,AlbumRank=@AlbumRank where Id=" + Session["lblid"] + "", connect);
                    cmd.Parameters.Add("@CoverPhotoPath", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@CoverPhotoPath"].Value = txtvdo.Text;
                    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('Video is Updated.')</script>");
                    txtAlbumName.Text = ""; txtAlbumRank.Text = "";
                    Session["lblid"] = null; txtvdo.Text = "";
                    binddata();
                }
            }
        }
    }
}