예제 #1
0
        public int Add(int MovieID, string MovieTitle, int RunningTime, System.DateTime ReleaseDate)
        {
            HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect();
            string             sql            = "Insert INTO Movies values (@MovieId, @MovieTitle, @RunningTime, @ReleaseDate)";

            SqlParameter param1 = new SqlParameter("@MovieId", SqlDbType.Int);

            param1.Value = MovieID;
            SqlParameter param2 = new SqlParameter("@MovieTitle", SqlDbType.Text);

            param2.Value = MovieTitle;
            SqlParameter param3 = new SqlParameter("@RunningTime", SqlDbType.Int);

            param3.Value = RunningTime;
            SqlParameter param4 = new SqlParameter("@ReleaseDate", SqlDbType.DateTime);

            param4.Value = ReleaseDate;

            try
            {
                return(aHollywoodConn.ExecuteNonQuery(sql, CommandType.Text, param1, param2, param3, param4));
            }
            catch (Exception ex)
            {
                LastError = ex.Message;
                return(-1);
            }
        }
예제 #2
0
 public int GetCount()
 {
     try
     {
         HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect();
         return(Convert.ToInt32(aHollywoodConn.GetScalar("SELECT COUNT(*) FROM MOVIES", CommandType.Text)));
     }
     catch (Exception ex)
     {
         LastError = ex.Message;
         return(-1);
     }
 }
예제 #3
0
        public DataTable GetBestPictures()
        {
            HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect();

            try
            {
                return(aHollywoodConn.GetTable("spBestMovies", CommandType.StoredProcedure));
            }
            catch (Exception ex)
            {
                LastError = ex.Message;
                return(null);
            }
        }
        public DataTable GetAllActors()
        {
            try
            {
                string sqlString = "SELECT * FROM Actors";
                HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect();

                DataSet actorsDS = new DataSet();
                actorsDS = aHollywoodConn.GetDataSet(sqlString);
                return actorsDS.Tables[0];
            }
            catch (Exception ex)
            {
                LastError = ex.Message;
                return null;
            }
        }
예제 #5
0
        public DataTable GetAllActors()
        {
            try
            {
                string             sqlString      = "SELECT * FROM Actors";
                HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect();

                DataSet actorsDS = new DataSet();
                actorsDS = aHollywoodConn.GetDataSet(sqlString);
                return(actorsDS.Tables[0]);
            }
            catch (Exception ex)
            {
                LastError = ex.Message;
                return(null);
            }
        }
예제 #6
0
        public DataTable GetActors(int mID)
        {
            HollywoodDBConnect aHollywoodConn = new HollywoodDBConnect();
            SqlParameter       param          = new SqlParameter("@MovieID", SqlDbType.Int);

            param.Value = mID;

            try
            {
                return(aHollywoodConn.GetTable("SELECT Actors.LastName, Actors.FirstName, Actors.DateOfBirth FROM Actors INNER JOIN Roles ON Actors.ActorID = Roles.ActorID WHERE MovieID = @MovieID", CommandType.Text, param));
            }
            catch (Exception ex)
            {
                LastError = ex.Message;
                return(null);
            }
        }