using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.Configuration ;
using System.Data.SqlClient ;




public partial class AddActor : System.Web.UI.Page
{
    private int ActorID;

    protected void Page_Load(object sender, EventArgs e)
    {
        string role = (string)Session["Role"];

        if (role == null)
        {
            Response.Redirect("~/Default.aspx");
        }
        else if (!role.StartsWith("Admin"))
        {
            Response.Redirect("~/Default.aspx");
        }
        MultiViewActor.ActiveViewIndex = 0;

    }


    protected void BtnContinue_Click1(object sender, EventArgs e)
    {
             MultiViewActor.ActiveViewIndex = 1;
       
    }
    protected void ButtonSave_Click(object sender, EventArgs e)
    {
        
        string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionStringMovies"].ConnectionString;
        SqlConnection con = new SqlConnection(ConnectionString);
        SqlCommand command = new SqlCommand("InsertActorFilm", con);
        command.CommandType = CommandType.StoredProcedure;
        SqlCommand commandF = new SqlCommand("InsertActorToFilms", con);
        commandF.CommandType = CommandType.StoredProcedure;

        command.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar, 30));
        command.Parameters["@Name"].Value = Txtname.Text;
        command.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 100));
        command.Parameters["@Address"].Value = txtaddress.Text;
        command.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 30));
        command.Parameters["@Email"].Value = txtemail.Text;
        command.Parameters.Add(new SqlParameter("@PhoneNumbers", SqlDbType.NVarChar, 100));
        command.Parameters["@PhoneNumbers"].Value = txtnumbers.Text;
        command.Parameters.Add(new SqlParameter("@ActorID", SqlDbType.Int, 4));
        command.Parameters["@ActorID"].Direction = ParameterDirection.Output;

        commandF.Parameters.Add(new SqlParameter("@ActorID", SqlDbType.Int, 4));
        commandF.Parameters.Add(new SqlParameter("@FilmID", SqlDbType.Int, 4));

        SqlTransaction tran = null;

        try
        {
            con.Open();
            tran = con.BeginTransaction();

            command.Transaction = tran;
            commandF.Transaction = tran;

            command.ExecuteNonQuery();
            ActorID = (int)command.Parameters["@ActorID"].Value;
            foreach (ListItem item in LstbFilms.Items)
            {
                if (item.Selected)
                {

                    commandF.Parameters["@ActorID"].Value = ActorID;
                    commandF.Parameters["@FilmID"].Value = item.Value;
                    commandF.ExecuteNonQuery();

                }
            }
            tran.Commit();
            message.Text = "The Actor " + Txtname.Text + " was added successfully:)";
            MultiViewActor.ActiveViewIndex = -1;

        }
        catch
        {
            tran.Rollback();
            message.Text = "An Error has happened please try again";
        }
        finally { con.Close(); }
        
    }

        
        
   
    protected void BtnCancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/Manage.aspx");

    }
}