File Upload Demo

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.IO;

public partial class cpanel_AddNewMovie : System.Web.UI.Page

{

    BAL bal = new BAL();

    Random rnd = new Random();

    int newid = 0;

    int _newid;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            getcountry();

            BindCategories();

            getlanguages();

        }

       

    }

    public void BindCategories()

    {

        DataTable dt = bal.GetAllCategories();

        ChkLstGenre.DataSource = dt;

        ChkLstGenre.DataBind();

    }

    protected void btnSave_Click(object sender, EventArgs e)

    {

        try

        {

            bal.name = txtTitle.Text;

            DataTable check = bal.checkAvailableMovie();

            foreach (DataRow r in check.Rows)

            {

                bal.name = check.Rows[0][0].ToString();

            }

            if (check.Rows.Count > 0)

            {

                lblresult.Visible = true;

                lblresult.Text = txtTitle.Text + " already exists";

            }

            else

            {

                bal.name = txtTitle.Text;

                bal.OriginalName = txtOriginaltitle.Text;

                bal.language = Convert.ToInt32(ddllanguage.SelectedValue);

                bal.country = Convert.ToInt32(ddlCountry.SelectedValue);

                string checkedgenre = string.Empty;

                foreach (ListItem li in ChkLstGenre.Items)

                {

                    if (li.Selected)

                    {

                        checkedgenre += li.Text+",";

                    }

                    bal.Category = checkedgenre.ToString();

                }

                bal.story = txtStory.Text;

                bal.year = txtYear.Text;

                bal.company = txtCompany.Text;

                bal.rating = float.Parse(txtRating.Text);

                bal.imdbrating = float.Parse(txtIMDBRating.Text);

                bal.awards = txtAwards.Text;

                bal.mydate = Convert.ToDateTime( txtDate.Text);

                bal.statusvar = ddlstatus.SelectedItem.ToString();

                bal.MovieLength =Convert.ToInt32(TxtMovieLength.Text);

                bal.WatchStatus = ddlWatchStatus.SelectedItem.ToString();

                string filename = string.Empty;

                bool exisit = true;

                while (exisit)

                {

                    filename = rnd.Next(1, 99999999).ToString();

                    if (!File.Exists(Server.MapPath("~/cpanel/MoviePosters/" + filename + ".jpg")))

                    {

                        break;

                    }

                }

                if (FileUpload1.HasFile)

                {

                    FileUpload1.SaveAs(Server.MapPath("~/cpanel/MoviePosters/" + filename + ".jpg"));

                }

                filename = filename + ".jpg";

                bal.Image = filename.ToString();

                int result = bal.insertNewMovie( ref newid);

                if (result == 1)

                {

                    _newid = newid;

                    lblresult.Visible = true;

                    lblresult.Text =  txtTitle.Text + " is saved Successfully";

                }

                else

                {

                    lblresult.Visible = true;

                    lblresult.Text = "Oops ! Something went wrong !!!";

                }

                foreach (ListItem cBox in ChkLstGenre.Items)

                {

                    if (cBox.Selected)

                    {

                        bal.genreid = Convert.ToInt32(cBox.Value.ToString());

                        bal.genrename = cBox.Text;

                        bal.id = _newid;

                        int Cresult = bal.InsertMovieGenre();

                    }

                }

            }

          

        }

        catch (Exception ex)

        {

            lblresult.Visible = true;

            lblresult.Text = ex.Message.ToString();

        }

    }

    protected void btnClear_Click(object sender, EventArgs e)

    {

    }

    private void getcountry()

    {

        DataTable ds = bal.Getcountry();

        ddlCountry.DataSource = ds;

        ddlCountry.DataBind();

        ddlCountry.Items.Insert(0, new ListItem("Select", "1000"));

    }

    private void getlanguages()

    {

        DataTable ds = bal.GetAllLanguage();

        ddllanguage.DataSource = ds;

        ddllanguage.DataBind();

        ddllanguage.Items.Insert(0, new ListItem("Select", "1000"));

    }

}

Business Layer Demo

public int movieid
{
set { _movieid = value; }
get { return _movieid; }
}

Data Access Layer

Data Access Layer

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

using System.Configuration;

using System.Data;

public class DAL

{

    static SqlConnection con;

    static SqlCommand cmd;

    public DAL()

    {

    }

    public static string connection = (ConfigurationManager.ConnectionStrings["Connect"].ConnectionString);

    public static int GetFirstValue(String commandText, SqlParameter[] parameters)

    {

        using (SqlConnection con = new SqlConnection(connection))

        {

            cmd = new SqlCommand(commandText, con);

            cmd.CommandType = CommandType.StoredProcedure;

            foreach (SqlParameter p in parameters)

            {

                if (p.Value != null)

                {

                    cmd.Parameters.Add(p);

                }

            }

            con.Open();

            int result = 0;

            SqlDataReader reader = cmd.ExecuteReader();

            if (reader.HasRows)

            {

                while (reader.Read())

                {

                    if (reader[0].ToString() != string.Empty)

                        result = Convert.ToInt32(reader[0].ToString());

                }

            }

            con.Close();

            return result;

        }

    }

    public static int executeNonquery_SP(String CommandText, SqlParameter[] parameters)

    {

        using (SqlConnection con = new SqlConnection(connection))

        {

            try

            {

                cmd = new SqlCommand(CommandText, con);

                cmd.CommandType = CommandType.StoredProcedure;

                foreach (SqlParameter p in parameters)

                {

                    if (p.Value != null)

                    {

                        cmd.Parameters.Add(p);

                    }

                }

                con.Open();

                int result = cmd.ExecuteNonQuery();

                if (result > 0)

                    return result;

                else

                    return 0;

            }

            catch (Exception ex)

            {

                throw new ArgumentException(ex.Message);

            }

            finally

            {

                con.Close();

            }

        }

    }

  

    public static DataTable Ret_datatable(String CommandText1, SqlParameter[] parameters)

    {

        con = new SqlConnection(connection);

        cmd = new SqlCommand(CommandText1, con);

        con.Open();

        cmd.CommandType = CommandType.StoredProcedure;

        foreach (SqlParameter c in parameters)

        {

            if (c.Value != null)

            {

                cmd.Parameters.Add(c);

            }

           

        }

        SqlDataAdapter da = new SqlDataAdapter(cmd);

      

        DataTable dt = new DataTable();

        da.Fill(dt);

       

        con.Close();

        return dt;

    }

    // Method that return a DataTable

    public static DataTable GetItems(String CommandText, SqlParameter[] parameters)

    {

        DataTable dt;

        using (SqlConnection con = new SqlConnection(connection))

        {

            cmd = new SqlCommand(CommandText, con);

            cmd.CommandType = CommandType.StoredProcedure;

            foreach (SqlParameter c in parameters)

            {

                if (c.Value != null)

                {

                    cmd.Parameters.Add(c);

                }

            }

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);

            dt = new DataTable();

            adapter.Fill(dt);

        }

        return dt;

    }

 

    public static string GetValue(String commandText, SqlParameter[] parameters)

    {

      

        string result = string.Empty;

        using (SqlConnection con = new SqlConnection(connection))

        {

            cmd = new SqlCommand(commandText, con);

            cmd.CommandType = CommandType.StoredProcedure;

            foreach (SqlParameter p in parameters)

            {

                if (p.Value != null)

                {

                    cmd.Parameters.Add(p);

                }

            }

            con.Open();

            SqlDataReader reader = cmd.ExecuteReader();

            if (reader.HasRows)

            {

                while (reader.Read())

                {

                    if (reader[0].ToString() != string.Empty)

                        result = reader[0].ToString();

                }

                con.Close();

            }

            return result;

        }

    }

   

    public static int executereader(String CommandText, SqlParameter[] parameters)

    {

        con = new SqlConnection(connection);

        cmd = new SqlCommand(CommandText, con);

        cmd.CommandType = CommandType.StoredProcedure;

        foreach (SqlParameter p in parameters)

        {

            if (p != null)

            {

                cmd.Parameters.Add(p);

            }

        }

        con.Open();

        SqlDataReader rdr = cmd.ExecuteReader();

        if (rdr.HasRows)

        {

            return 1;

        }

        else

        {

            return 0;

        }

        con.Close();

    }

}