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 AddVideo : System.Web.UI.Page
    {
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd;
        Class1 obj = new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["Admin"] != null)
                {
                    Session["lblid"] = null;
                    binddata();
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }
            }
        }

        private void binddata()
        {
            string qrajneeti = "select * from newdelhibar_Vedio order by video_rnk Asc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                rptrBannr.DataSource = dsrajneeti;
                rptrBannr.DataBind();
            }
            string qrajneeti1 = "select id,AlbumName from [newdelhibar_VideoAlbumList] order by cast(AlbumRank as int) Asc";
            DataSet dsrajneeti1 = obj.ReturnDataSet(qrajneeti1);
            if (dsrajneeti1 != null && dsrajneeti1.Tables[0].Rows.Count > 0)
            {
                ddlPhotoAlbum.DataSource = dsrajneeti1.Tables[0];
                ddlPhotoAlbum.DataTextField = "AlbumName";
                ddlPhotoAlbum.DataValueField = "id";
                ddlPhotoAlbum.DataBind();

                ddlPhotoAlbum.Items.Insert(0, "----- Select Album -----");
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {

            if (txtAlbumRank.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Video Rank.')</script>");
            }
            else if (txtAlbumName.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Video Name.')</script>");
            }
            else if (TextBox1.Text == "")
            {
                RegisterStartupScript("12", "<script>alert('Enter Video Path.')</script>");
            }
            else
            {
                if (Session["lblid"] == null)
                {
                    connect.Open();
                    cmd = new SqlCommand("insert into newdelhibar_Vedio(video_rnk,video_title,vdo,vdo_album) values(@video_rnk,@video_title,@vdo,@vdo_album) ", connect);
                    cmd.Parameters.Add("@vdo", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@vdo"].Value = TextBox1.Text;
                    cmd.Parameters.Add("@video_title", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@video_title"].Value = txtAlbumName.Text;
                    cmd.Parameters.Add("@video_rnk", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@video_rnk"].Value = txtAlbumRank.Text;
                    cmd.Parameters.Add("@vdo_album", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@vdo_album"].Value = ddlPhotoAlbum.SelectedItem.Value;
                    cmd.ExecuteNonQuery();
                    connect.Close();
                    RegisterStartupScript("12", "<script>alert('New Video Path Added.')</script>");
                    TextBox1.Text = ""; txtAlbumName.Text = ""; txtAlbumRank.Text = "";
                    binddata();
                }
                else
                {
                    connect.Open();
                    cmd = new SqlCommand("update newdelhibar_Vedio set video_rnk=@video_rnk,video_title=@video_title,vdo=@vdo,vdo_album=@vdo_album where id=" + Session["lblid"] + "", connect);
                    cmd.Parameters.Add("@vdo", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@vdo"].Value = TextBox1.Text;
                    cmd.Parameters.Add("@video_title", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@video_title"].Value = txtAlbumName.Text;
                    cmd.Parameters.Add("@video_rnk", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@video_rnk"].Value = txtAlbumRank.Text;
                    cmd.Parameters.Add("@vdo_album", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@vdo_album"].Value = ddlPhotoAlbum.SelectedItem.Value;
                    cmd.ExecuteNonQuery();
                    connect.Close();
                    RegisterStartupScript("12", "<script>alert('New Video Path Updated.')</script>");
                    TextBox1.Text = ""; txtAlbumName.Text = ""; txtAlbumRank.Text = ""; Session["lblid"] = null;
                    binddata();
                }
            }
        }
        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");
                Label lblvdo = (Label)e.Item.FindControl("lblvdo");

                txtAlbumRank.Text = lblAlbumRank.Text;
                ddlPhotoAlbum.SelectedValue = lbllst1.Text;
                txtAlbumName.Text = lblAlbumName.Text;
                TextBox1.Text = lblvdo.Text;

                Session["lblid"] = lblid.Text;

            }
            if (e.CommandName == "delete")
            {
                string id = ((Label)e.Item.FindControl("lblid")).Text;
                string cmd = "delete from newdelhibar_Vedio where id='" + id + "'";
                obj.DeleteRecord(cmd);
                RegisterStartupScript("12", "<script>alert('Video Deleted.')</script>");
                binddata();
            }
        }
    }
}