Sunday, 30 June 2013


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Net;

/// <summary>
/// Summary description for BAL
/// </summary>
public class BAL
{
    public BAL()
    {
    }
    private int _MovieLength;
    private string _Brand;
    private int _flag;
    private int _id;
    private string _DiscType;
    private string _name;
    private string _contenttype;
    private int _contentid;
    private DateTime _mydate;
    private int _discno;
    private string _multisession;
    private int _singlemultiplemovie;
    private string _usedspace;
    private string _freespace;
    private int _price;
    private string _shop;
    private int _Size;
    private string _Comments;
    private string _OriginalName;
    private string _JobType;
    private string _BirthPlace;
    private string _Birthday;
    private string _place;
    private int _country;
    private int _state;
    private string _Biography;
    private string _ProfilePicture;
    private string _Image;
    private string _Category;
    private int _language;
    private string _story;
    private string _year;
    private string _company;
    private string _awards;
    private float _rating;
    private float _imdbrating;
    private string _statusvar;
    private string _Type;
    private string _charactername;
    private int _nameid;
    private string _WatchStatus;
    private int _genreid;
    private string _genrename;
    private int _profileid;
    private int _movieid;
    private string _Pouch;

    public int movieid
    {
        set { _movieid = value; }
        get { return _movieid; }
    }
    public int profileid
    {
        set { _profileid = value; }
        get { return _profileid; }
    }
    public int genreid
    {
        set { _genreid = value; }
        get { return _genreid; }
    }
    public string genrename
    {
        set { _genrename = value; }
        get { return _genrename; }
    }
    public string Pouch
    {
        set { _Pouch = value; }
        get { return _Pouch; }
    }
    public string WatchStatus
    {
        set { _WatchStatus = value; }
        get { return _WatchStatus; }
    }
    public int MovieLength
    {
        set { _MovieLength = value; }
        get { return _MovieLength; }
    }
    public string charactername
    {
        set { _charactername = value; }
        get { return _charactername; }
    }
    public string Type
    {
        set { _Type = value; }
        get { return _Type; }
    }
    public int nameid
    {
        set { _nameid = value; }
        get { return _nameid; }
    }
    public int language
    {
        set { _language = value; }
        get { return _language; }
    }
    public string story
    {
        set { _story = value; }
        get { return _story; }
    }
    public string year
    {
        set { _year = value; }
        get { return _year; }
    }
    public string company
    {
        set { _company = value; }
        get { return _company; }
    }
    public string awards
    {
        set { _awards = value; }
        get { return _awards; }
    }
    public string statusvar
    {
        set { _statusvar = value; }
        get { return _statusvar; }
    }
    public float rating
    {
        set { _rating = value; }
        get { return _rating; }
    }
    public float imdbrating
    {
        set { _imdbrating = value; }
        get { return _imdbrating; }
    }





    public string Image
    {
        set { _Image = value; }
        get { return _Image; }
    }
    public string Category
    {
        set { _Category = value; }
        get { return _Category; }
    }

    public string OriginalName
    {
        set { _OriginalName = value; }
        get { return _OriginalName; }
    }

    public string JobType
    {
        set { _JobType = value; }
        get { return _JobType; }
    }
    public string BirthPlace
    {
        set { _BirthPlace = value; }
        get { return _BirthPlace; }
    }
    public string Birthday
    {
        set { _Birthday = value; }
        get { return _Birthday; }
    }
    public string place
    {
        set { _place = value; }
        get { return _place; }
    }

    public string Biography
    {
        set { _Biography = value; }
        get { return _Biography; }
    }
    public string ProfilePicture
    {
        set { _ProfilePicture = value; }
        get { return _ProfilePicture; }
    }



    public int country
    {
        set { _country = value; }
        get { return _country; }
    }
    public int state
    {
        set { _state = value; }
        get { return _state; }
    }

    public int Size
    {
        set { _Size = value; }
        get { return _Size; }
    }

    public int id
    {
        set { _id = value; }
        get { return _id; }
    }
    public string Comments
    {
        set { _Comments = value; }
        get { return _Comments; }
    }
    public string Brand
    {
        set { _Brand = value; }
        get { return _Brand; }
    }
    public string Disctype
    {
        set { _DiscType = value; }
        get { return _DiscType; }
    }
    public string name
    {
        set { _name = value; }
        get { return _name; }
    }
    public string Contenttype
    {
        set { _contenttype = value; }
        get { return _contenttype; }
    }
    public int Contentid
    {
        set { _contentid = value; }
        get { return _contentid; }
    }
    public DateTime mydate
    {
        set { _mydate = value; }
        get { return _mydate; }
    }
    public int discno
    {
        set { _discno = value; }
        get { return _discno; }
    }
    public string multisession
    {
        set { _multisession = value; }
        get { return _multisession; }
    }
    public int Singlemultiplemovie
    {
        set { _singlemultiplemovie = value; }
        get { return _singlemultiplemovie; }
    }
    public string Usedspace
    {
        set { _usedspace = value; }
        get { return _usedspace; }
    }
    public string Freespace
    {
        set { _freespace = value; }
        get { return _freespace; }
    }
    public string Shop
    {
        set { _shop = value; }
        get { return _shop; }
    }

    public int Price
    {
        set { _price = value; }
        get { return _price; }
    }


    public int InsertBrand()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Brand", Brand);
        p[1] = new SqlParameter("@Flag", 1);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }

    public DataTable checkDiskBrand()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Brand", Brand);
        p[1] = new SqlParameter("@Flag", 1);
        return DAL.Ret_datatable("GetData", p);
    }

    public DataTable getbrands()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 2);
        return DAL.Ret_datatable("GetData", p);

    }
    public int insertdiscinformation()
    {
        SqlParameter[] p = new SqlParameter[14];
        p[0] = new SqlParameter("@Flag", 2);
        p[1] = new SqlParameter("@DiscType", Disctype);
        p[2] = new SqlParameter("@name", name);
        p[3] = new SqlParameter("@contenttype", Contenttype);
        p[4] = new SqlParameter("@date", mydate);
        p[5] = new SqlParameter("@Brand", Brand);
        p[6] = new SqlParameter("@Discno", discno);
        p[7] = new SqlParameter("@SingleMultipleMovie", Singlemultiplemovie);
        p[8] = new SqlParameter("@multisession", multisession);
        p[9] = new SqlParameter("@usedspace", Usedspace);
        p[10] = new SqlParameter("@freespace", Freespace);
        p[11] = new SqlParameter("@Price", Price);
        p[12] = new SqlParameter("@Shop", Shop);
        p[13] = new SqlParameter("@Pouch", Pouch);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;
    }
    public DataTable getexistingdiscs()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 3);
        p[1] = new SqlParameter("@name", name);
        return DAL.Ret_datatable("GetData", p);

    }
    public DataTable LoadDiscs()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[1];
            p[0] = new SqlParameter("@Flag", 4);
            DataTable result = DAL.Ret_datatable("GetData", p);
            return result;
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }

    public DataTable LoadDiscDetails()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[2];
            p[0] = new SqlParameter("@Flag", 5);
            p[1] = new SqlParameter("@id", id);
            DataTable result = DAL.Ret_datatable("GetData", p);
            return result;
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }
    public int insertdisccontents()
    {
        SqlParameter[] p = new SqlParameter[6];
        p[0] = new SqlParameter("@Flag", 3);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@Description", Comments);
        p[3] = new SqlParameter("@id", id);
        p[4] = new SqlParameter("@Size", Size);
        p[5] = new SqlParameter("@Contenttype", Contenttype);

        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;
    }

    public DataTable getexistingcontents()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 6);
        p[1] = new SqlParameter("@name", name);
        return DAL.Ret_datatable("GetData", p);

    }
    public DataTable getCurrentDisccontents()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 7);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData", p);

    }
    public int insertProfileData()
    {
        SqlParameter[] p = new SqlParameter[11];
        p[0] = new SqlParameter("@Flag", 4);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@originalname", OriginalName);
        p[3] = new SqlParameter("@JobType", JobType);
        p[4] = new SqlParameter("@birthplace", BirthPlace);
        p[5] = new SqlParameter("@birthday", Birthday);
        p[6] = new SqlParameter("@place", place);
        p[7] = new SqlParameter("@country", country);
        p[8] = new SqlParameter("@state", state);
        p[9] = new SqlParameter("@biography", Biography);
        p[10] = new SqlParameter("@Profilepicture", ProfilePicture);

        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;
    }
    public int UpdateProfileData()
    {
        SqlParameter[] p = new SqlParameter[11];
        p[0] = new SqlParameter("@Flag", 15);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@originalname", OriginalName);
        p[3] = new SqlParameter("@JobType", JobType);
        p[4] = new SqlParameter("@birthplace", BirthPlace);
        p[5] = new SqlParameter("@birthday", Birthday);
        p[6] = new SqlParameter("@place", place);
        p[7] = new SqlParameter("@country", country);
        p[8] = new SqlParameter("@state", state);
        p[9] = new SqlParameter("@biography", Biography);
        p[10] = new SqlParameter("@id", profileid);

        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;
    }

    public DataTable Getcountry()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[1];
            p[0] = new SqlParameter("@FLAG", 8);
            return DAL.GetItems("GetData", p);
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }
    public DataTable GetAllLanguage()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[1];
            p[0] = new SqlParameter("@FLAG", 2);
            return DAL.GetItems("GetData2", p);
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }
    public DataTable GetStatesByCountryId(int countryid)
    {
        try
        {
            SqlParameter[] p = new SqlParameter[2];
            p[0] = new SqlParameter("@FLAG", 9);
            p[1] = new SqlParameter("@countryid", countryid);
            return DAL.GetItems("GetData", p);
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }

    public DataTable ChechExixtingProfiles()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@Flag", 10);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@originalname", OriginalName);
        return DAL.Ret_datatable("GetData", p);

    }

    public DataTable GetProfiles()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 11);
        return DAL.Ret_datatable("GetData", p);

    }
    public DataTable SearchProfiles()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 9);
        p[1] = new SqlParameter("@name", name);
        return DAL.Ret_datatable("GetData5", p);

    }
    public int insertProfilePictures()
    {
        SqlParameter[] p = new SqlParameter[4];
        p[0] = new SqlParameter("@Flag", 5);
        p[1] = new SqlParameter("@Profilepicture", ProfilePicture);
        p[2] = new SqlParameter("@Description", Comments);
        p[3] = new SqlParameter("@id", id);


        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;
    }

    public DataTable GetProfilePictires()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 12);
        p[1] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("GetData", p);

    }
    public int insertMoviePosters()
    {
        SqlParameter[] p = new SqlParameter[5];
        p[0] = new SqlParameter("@Flag", 6);
        p[1] = new SqlParameter("@Image", Image);
        p[2] = new SqlParameter("@Type", Type);
        p[3] = new SqlParameter("@Description", Comments);
        p[4] = new SqlParameter("@id", id);


        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;
    }
    public DataTable GetMoviePosters()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 13);
        p[1] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("GetData", p);

    }
    public int InsertCategory()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Category", Category);
        p[1] = new SqlParameter("@Flag", 7);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }
    public DataTable checkAvailableCategory()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Category", Category);
        p[1] = new SqlParameter("@Flag", 14);
        return DAL.Ret_datatable("GetData", p);
    }
    public DataTable GetAllCategories()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 15);
        return DAL.Ret_datatable("GetData", p);
    }
    public int Insertnewcast(ref int newcastid)
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@Flag", 10);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@outputid", DbType.Int32);
        p[2].Direction = ParameterDirection.Output;

        int inserted = DAL.executeNonquery_SP("InsertData", p);
        newcastid = Convert.ToInt32(p[2].Value);
        return inserted;

    }
    public int insertNewMovie(ref int newid)
    {
        SqlParameter[] p = new SqlParameter[18];
        p[0] = new SqlParameter("@Flag", 8);
        p[1] = new SqlParameter("@title", name);
        p[2] = new SqlParameter("@originalname", OriginalName);
        p[3] = new SqlParameter("@language", language);
        p[4] = new SqlParameter("@country", country);
        p[5] = new SqlParameter("@Category", Category);
        p[6] = new SqlParameter("@story", story);
        p[7] = new SqlParameter("@Image", Image);
        p[8] = new SqlParameter("@year", year);
        p[9] = new SqlParameter("@company", company);
        p[10] = new SqlParameter("@Awards", awards);
        if (rating > 0)
            p[11] = new SqlParameter("@rating", rating);
        else
            p[11] = new SqlParameter("@rating", DBNull.Value);
        if (imdbrating > 0)
            p[12] = new SqlParameter("@Imdbrating", imdbrating);
        else
            p[12] = new SqlParameter("@Imdbrating", DBNull.Value);
        p[13] = new SqlParameter("@date", mydate);
        p[14] = new SqlParameter("@statusvar", statusvar);
        if (MovieLength > 0)
            p[15] = new SqlParameter("@MovieLength", MovieLength);
        else
            p[15] = new SqlParameter("@MovieLength", DBNull.Value);
        p[16] = new SqlParameter("@watchstatus", WatchStatus);
        p[17] = new SqlParameter("@outputid", DbType.Int32);
        p[17].Direction = ParameterDirection.Output;


        int inserted = DAL.executeNonquery_SP("InsertData", p);
        newid = Convert.ToInt32(p[17].Value);
        return inserted;
    }
    public DataTable checkAvailableMovie()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@title", name);
        p[1] = new SqlParameter("@Flag", 1);
        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable GetAllMovies()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 3);
        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable GetAllMoviesByYear()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 11);
        p[1] = new SqlParameter("@year", year);
        return DAL.Ret_datatable("GetData3", p);
    }
    public DataTable GetAllMoviesByGenre()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 10);
        p[1] = new SqlParameter("@genreid", genreid);
        return DAL.Ret_datatable("GetData3", p);
    }
    public DataTable GetMoviesbyLanguage()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 6);
        p[1] = new SqlParameter("@languageid", language);
        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable GetMoviesbyCountry()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 7);
        p[1] = new SqlParameter("@countryid", country);
        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable GetMoviesbyid()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 4);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable GetDirectorsMovieid()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 5);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData3", p);
    }
    public DataTable GetproducersMovieid()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 6);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData3", p);
    }
    public DataTable GetGenreByMovieid()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 7);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData3", p);
    }
    public int InsertCastAndCrew()
    {
        SqlParameter[] p = new SqlParameter[6];
        p[0] = new SqlParameter("@Flag", 16);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@charactername", charactername);
        p[3] = new SqlParameter("@JobType", JobType);
        p[4] = new SqlParameter("@id", id);
        p[5] = new SqlParameter("@nameid", nameid);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }
    public DataTable checkAvailableCastAndCrew()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@name", name);
        p[1] = new SqlParameter("@Flag", 7);
        p[2] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable GetAlljobtypes()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 8);
        return DAL.Ret_datatable("GetData2", p);
    }

    public DataTable checkCastInProfiles()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 9);
        p[1] = new SqlParameter("@name ", name);
        return DAL.Ret_datatable("GetData2", p);
    }

    public DataTable GetTitlesById()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 10);
        p[1] = new SqlParameter("@nameid", nameid);
        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable GetCastByMovieId()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 11);
        p[1] = new SqlParameter("@nameid", id);
        return DAL.Ret_datatable("GetData2", p);
    }
    public DataTable checkAvailableDirectors()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@name", name);
        p[1] = new SqlParameter("@Flag", 4);
        p[2] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("GetData3", p);
    }
    public DataTable checkAvailableProducers()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@name", name);
        p[1] = new SqlParameter("@Flag", 2);
        p[2] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("GetData3", p);
    }
    public DataTable checkAvailableMusicDirectors()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@name", name);
        p[1] = new SqlParameter("@Flag", 3);
        p[2] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("Getdata3", p);
    }
    public int InsertProducer()
    {
        SqlParameter[] p = new SqlParameter[4];
        p[0] = new SqlParameter("@Flag", 9);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@id", id);
        p[3] = new SqlParameter("@nameid", nameid);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }
    public int InsertDirector()
    {
        SqlParameter[] p = new SqlParameter[4];
        p[0] = new SqlParameter("@Flag", 11);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@id", id);
        p[3] = new SqlParameter("@nameid", nameid);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }
    public int InsertMusicDirector()
    {
        SqlParameter[] p = new SqlParameter[4];
        p[0] = new SqlParameter("@Flag", 12);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@id", id);
        p[3] = new SqlParameter("@nameid", nameid);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }
    public int InsertMovieGenre()
    {
        SqlParameter[] p = new SqlParameter[4];
        p[0] = new SqlParameter("@Flag", 13);
        p[1] = new SqlParameter("@genreid", genreid);
        p[2] = new SqlParameter("@genrename", genrename);
        p[3] = new SqlParameter("@id", id);
        int inserted = DAL.executeNonquery_SP("InsertData", p);
        return inserted;

    }

    public int UpdateMovie()
    {
        SqlParameter[] p = new SqlParameter[17];
        p[0] = new SqlParameter("@Flag", 14);
        p[1] = new SqlParameter("@title", name);
        p[2] = new SqlParameter("@originalname", OriginalName);
        p[3] = new SqlParameter("@language", language);
        p[4] = new SqlParameter("@country", country);
        p[5] = new SqlParameter("@Category", Category);
        p[6] = new SqlParameter("@story", story);
        p[7] = new SqlParameter("@id", id);
        p[8] = new SqlParameter("@year", year);
        p[9] = new SqlParameter("@company", company);
        p[10] = new SqlParameter("@Awards", awards);
        if (rating > 0)
            p[11] = new SqlParameter("@rating", rating);
        else
            p[11] = new SqlParameter("@rating", DBNull.Value);
        if (imdbrating > 0)
            p[12] = new SqlParameter("@Imdbrating", imdbrating);
        else
            p[12] = new SqlParameter("@Imdbrating", DBNull.Value);
        p[13] = new SqlParameter("@date", mydate);
        p[14] = new SqlParameter("@statusvar", statusvar);
        if (MovieLength > 0)
            p[15] = new SqlParameter("@MovieLength", MovieLength);
        else
            p[15] = new SqlParameter("@MovieLength", DBNull.Value);
        p[16] = new SqlParameter("@watchstatus", WatchStatus);

        int inserted = DAL.executeNonquery_SP("InsertData", p);

        return inserted;
    }
    public DataTable GetProfilesInfo()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 13);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData3", p);

    }
    public int UpdateProfilePicture()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@Flag", 1);
        p[1] = new SqlParameter("@Profileid", profileid);
        p[2] = new SqlParameter("@image", ProfilePicture);
        int inserted = DAL.executeNonquery_SP("InsertData2", p);
        return inserted;

    }
    public int UpdatePoster()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@Flag", 2);
        p[1] = new SqlParameter("@id", id);
        p[2] = new SqlParameter("@image", Image);
        int inserted = DAL.executeNonquery_SP("InsertData2", p);
        return inserted;

    }

    public int DeleteCastAndCrew()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 1);
        p[1] = new SqlParameter("@castid", id);

        int result = DAL.executeNonquery_SP("DeleteData", p);
        return result;

    }

    public DataTable CheckDiscContentsbyDiscId()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@Flag", 2);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@Discid", id);
        return DAL.Ret_datatable("GetData3", p);

    }
    public DataTable CheckDiscContents()
    {
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@Flag", 2);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@Discid", id);
        return DAL.Ret_datatable("GetData4", p);

    }

    public DataTable CheckMovieinMovieTable()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 1);
        p[1] = new SqlParameter("@title", name);

        return DAL.Ret_datatable("GetData4", p);

    }

    public int InsertIntoMovie(ref int newMovieid)
    {
        SqlParameter[] p = new SqlParameter[4];
        p[0] = new SqlParameter("@Flag", 3);
        p[1] = new SqlParameter("@title", name);
        p[2] = new SqlParameter("@year", year);
        p[3] = new SqlParameter("@outputid", DbType.Int32);
        p[3].Direction = ParameterDirection.Output;
        int inserted = DAL.executeNonquery_SP("InsertData2", p);
        newMovieid = Convert.ToInt32(p[3].Value);
        return inserted;
    }
    public int insertdiscMovieContent()
    {
        SqlParameter[] p = new SqlParameter[7];
        p[0] = new SqlParameter("@Flag", 4);
        p[1] = new SqlParameter("@name", name);
        p[2] = new SqlParameter("@Description", Comments);
        p[3] = new SqlParameter("@id", id);
        p[4] = new SqlParameter("@Size", Size);
        p[5] = new SqlParameter("@type", Contenttype);
        p[6] = new SqlParameter("@movieid", movieid);


        int inserted = DAL.executeNonquery_SP("InsertData2", p);
        return inserted;
    }
    public DataTable GetProfilesbyId()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 3);
        p[1] = new SqlParameter("@id", profileid);
        return DAL.Ret_datatable("GetData4", p);
    }

    public DataTable GetjobsbyId()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 4);
        p[1] = new SqlParameter("@id", profileid);
        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable GetAlbumPhotos()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 5);
        p[1] = new SqlParameter("@id", id);

        return DAL.Ret_datatable("GetData4", p);

    }
    public DataTable GetTopMoviesById()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 6);
        p[1] = new SqlParameter("@nameid", nameid);
        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable GetTotalMoviesforActors()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 15);
       
        return DAL.Ret_datatable("GetData3", p);
    }
    public int DeleteProfilePictures()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 2);
        p[1] = new SqlParameter("@id", id);

        int result = DAL.executeNonquery_SP("DeleteData", p);
        return result;

    }
    public int DeleteMovieScreens()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 3);
        p[1] = new SqlParameter("@id", id);

        int result = DAL.executeNonquery_SP("DeleteData", p);
        return result;

    }
    public DataTable GetGenreStatistics()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 13);

        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable GetLangStatistics()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 11);

        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable GetYearlyStatistics()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 12);

        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable SearchExactMovie()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 15);
        p[1] = new SqlParameter("@title", name);
        return DAL.Ret_datatable("GetData4", p);
    }
    public DataTable SearchMovies()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 16);
        p[1] = new SqlParameter("@title", name);
        return DAL.Ret_datatable("GetData4", p);
    }

    public DataTable GetDiscInformationByMovId()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 1);
        p[1] = new SqlParameter("@id", id);
        return DAL.Ret_datatable("GetData5", p);
    }
    public DataTable GetMovieList()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[1];

            p[0] = new SqlParameter("@Flag", 3);

            DataTable dt = DAL.Ret_datatable("GetData5", p);
            return dt;
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }
    public DataTable GetProfileList()
    {
        try
        {
            SqlParameter[] p = new SqlParameter[1];
            p[0] = new SqlParameter("@Flag", 4);
            DataTable dt = DAL.Ret_datatable("GetData5", p);
            return dt;
        }
        catch (ArgumentException ex)
        {
            throw new ArgumentException(ex.Message);
        }
    }
    public int insertGenre()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 6);
        p[1] = new SqlParameter("@genre", genrename);
        int inserted = DAL.executeNonquery_SP("InsertData2", p);
        return inserted;
    }
    public DataTable checkGenre()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@genre", genrename);
        p[1] = new SqlParameter("@Flag", 5);
        return DAL.Ret_datatable("GetData5", p);
    }
    public DataTable GetGenresbyMovID()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@id", movieid);
        p[1] = new SqlParameter("@Flag", 6);
        return DAL.Ret_datatable("GetData5", p);
    }
 
    public int DeleteGenresbyMovID()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 4);
        p[1] = new SqlParameter("@Movieid", movieid);

        int result = DAL.executeNonquery_SP("DeleteData", p);
        return result;

    }
    public DataTable GetStory()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 7);
        p[1] = new SqlParameter("@id", movieid);
     
        return DAL.Ret_datatable("GetData5", p);

    }
    public DataTable GetLattestPoster()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 8);
        return DAL.Ret_datatable("GetData5", p);

    }
    public DataTable Searchcontent()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 10);
        p[1] = new SqlParameter("@name", name);
        return DAL.Ret_datatable("GetData5", p);

    }
    public DataTable GetAvgRating()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 11);
        p[1] = new SqlParameter("@nameid", nameid);
        return DAL.Ret_datatable("GetData5", p);
    }
    public DataTable GetTop10Actormain()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 2);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10Actressmain()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 3);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10ActorSupport()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 4);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10ActressSupport()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 5);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10MusicDirectors()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 6);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10Directors()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 7);
        return DAL.Ret_datatable("GetData6", p);
    }

    public DataTable GetTop10Movies()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 8);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10EnglishMovies()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 9);
        return DAL.Ret_datatable("GetData6", p);
    }

    public DataTable GetTop10MalayalamMovies()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 10);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10HindiMovies()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 11);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetTop10TamilMovies()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 12);
        return DAL.Ret_datatable("GetData6", p);
    }
    public DataTable GetMoviesneedUpdation()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 13);
        return DAL.Ret_datatable("GetData6", p);
    }

    public DataTable topCategories()
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Flag", 13);

        return DAL.Ret_datatable("GetData5", p);
    }

    public DataTable SearchMovie()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 14);
        p[1] = new SqlParameter("@title", name);
        return DAL.Ret_datatable("GetData6", p);
    }

    public DataTable SearchProfile()
    {
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Flag", 15);
        p[1] = new SqlParameter("@name", name);
        return DAL.Ret_datatable("GetData6", p);
    }
}

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)