Example #1
0
        public object getMovieDetails(string movieid)
        {
            try
            {
                int MOVIE_ID = 0;
                MovieOperationsDAL mo_dal         = new MovieOperationsDAL();
                DataTable          dtMovieDetails = new DataTable();
                if (movieid.Length > 0)
                {
                    MOVIE_ID = int.Parse(movieid);
                }
                else
                {
                    return(new { Message = "error", MessageReason = "No movie found" });
                }
                dtMovieDetails = mo_dal.GetMovieCrew(MOVIE_ID);

                string actorAnids            = string.Empty;
                List <GetMovieDetails> lstMD = new List <GetMovieDetails>();
                foreach (DataRow dr in dtMovieDetails.Rows)
                {
                    GetMovieDetails gmd = new GetMovieDetails();
                    gmd.MOVIE_ANID     = dr["MOVIE_ANID"].ToString();
                    gmd.MOVIE_NAME     = dr["MOVIE_NAME"].ToString();
                    gmd.MOVIE_PLOT     = dr["MOVIE_PLOT"].ToString();
                    gmd.MOVIE_POSTER   = dr["MOVIE_POSTER"].ToString();
                    gmd.MOVIE_YOR      = dr["MOVIE_YOR"].ToString();
                    gmd.PRODUCER_ANID  = dr["PRODUCER_ANID"].ToString();
                    gmd.PRODUCER_NAME  = dr["PRODUCER_NAME"].ToString();
                    gmd.CREWUNION_ANID = dr["CREWUNION_ANID"].ToString();
                    actorAnids         = dr["ACTOR_ANIDS"].ToString().TrimEnd(',');
                    lstMD.Add(gmd);
                }
                string[] actorAnid = actorAnids.Split(',');

                List <actor_ANIDs> lstACTORS = new List <actor_ANIDs>();

                for (int i = 0; i < actorAnid.Length; i++)
                {
                    actor_ANIDs ai = new actor_ANIDs();
                    ai.ACTOR_ANID = actorAnid[i].ToString();
                    lstACTORS.Add(ai);
                }

                if (dtMovieDetails.Rows.Count > 0)
                {
                    return new { Message = "success", MovieDetails = lstMD, actorAnids = lstACTORS }
                }
                ;
                else
                {
                    return new { message = "error", MessageReason = "No movie avilable" }
                };
            }
            catch (Exception ex)
            {
                string error = " API - getmoviedetails " + ex.Message;
                return(new { Message = "error", MessageReason = "There was some problem loading the data. Please try again! <br>  " + error });
            }
        }
Example #2
0
        public object CreateProducer(JObject json)
        {
            try
            {
                MovieOperationsDAL mo_dal          = new MovieOperationsDAL();
                DataTable          dtActorsList    = new DataTable();
                string             PRODUCER_NAME   = (json["PRODUCER_NAME"].ToString());
                string             PRODUCER_GENDER = (json["PRODUCER_GENDER"].ToString());
                string             PRODUCER_DOB    = (json["PRODUCER_DOB"].ToString());

                string PRODUCER_BIO = (json["PRODUCER_BIO"].ToString());

                int iRowsEffected = mo_dal.CreateProducer(PRODUCER_NAME, PRODUCER_GENDER, PRODUCER_DOB, PRODUCER_BIO, "Admin");
                if (iRowsEffected > 0)
                {
                    return new { Message = "Success", MessageReason = "Successfully Created movie." }
                }
                ;
                else
                {
                    return new { Message = "error", MessageReason = "Insert failed." }
                };
            }
            catch (Exception ex)
            {
                string error = " API - updatemovie " + ex.Message;
                return(new { Message = "error", MessageReason = "There was some problem. Please refresh try again! <br>" + error });
            }
        }
Example #3
0
 public object CreateMovie(JObject json)
 {
     try
     {
         MovieOperationsDAL mo_dal       = new MovieOperationsDAL();
         DataTable          dtActorsList = new DataTable();
         string             MOVIE_NAME   = (json["MOVIE_NAME"].ToString());
         string             MOVIE_YOR    = (json["MOVIE_YOR"].ToString());
         string             MOVIE_PLOT   = (json["MOVIE_PLOT"].ToString());
         string             MOVIE_POSTER = (json["MOVIE_POSTER"].ToString());
         int    PRODUCER_ANID            = int.Parse(json["PRODUCER_ANID"].ToString());
         string ACTORS_ANIDS             = (json["ACTORS_ANIDS"].ToString());
         int    iRowsEffected            = mo_dal.CreateMovie(MOVIE_NAME, MOVIE_YOR, MOVIE_PLOT, MOVIE_POSTER, PRODUCER_ANID, ACTORS_ANIDS, "Admin");
         if (iRowsEffected > 0)
         {
             return new { Message = "success", MessageReason = "Successfully Created movie." }
         }
         ;
         else
         {
             return new { Message = "error", MessageReason = "Insert failed." }
         };
     }
     catch (Exception ex)
     {
         string error = " API - updatemovie " + ex.Message;
         return(new { Message = "error", MessageReason = "There was some problem. Please refresh try again! <br>" + error });
     }
 }
Example #4
0
        public object getMoviesList()
        {
            try
            {
                MovieOperationsDAL  mo_dal          = new MovieOperationsDAL();
                DataTable           dtMovieDetails  = new DataTable();
                List <MovieDetails> lstMovieDetails = new List <MovieDetails>();
                dtMovieDetails = mo_dal.GetMoviesList();
                for (int i = 0; i < dtMovieDetails.Rows.Count; i++)
                {
                    MovieDetails md = new MovieDetails();
                    md.Name     = dtMovieDetails.Rows[i]["Name"].ToString();
                    md.Year     = dtMovieDetails.Rows[i]["Year"].ToString();
                    md.Actors   = dtMovieDetails.Rows[i]["Actors"].ToString();
                    md.Producer = dtMovieDetails.Rows[i]["Producer"].ToString();
                    md.Poster   = String.Format("<div align=center><img src='{0}' width='50' vspace='5'></div>", dtMovieDetails.Rows[i]["Poster"].ToString());
                    md.Actions  = dtMovieDetails.Rows[i]["Actions"].ToString();
                    lstMovieDetails.Add(md);
                }

                return(new { Message = "Success", MovieList = lstMovieDetails });
            }
            catch (Exception ex)
            {
                string error = " API - getmovieslist " + ex.Message;
                return(new { Message = "error", MessageReason = "There was some problem loading data. Please refresh try again! <br>" + error });
            }
        }
Example #5
0
 public object getActorList()
 {
     try
     {
         MovieOperationsDAL mo_dal       = new MovieOperationsDAL();
         DataTable          dtActorsList = new DataTable();
         dtActorsList = mo_dal.GetActorsList();
         if (dtActorsList.Rows.Count > 0)
         {
             return new { Message = "Success", ActorsList = DataTableToJSONWithJavaScriptSerializer(dtActorsList) }
         }
         ;
         else
         {
             return new { Message = "error", MessageReason = "No Actor avilable." }
         };
     }
     catch (Exception ex)
     {
         string error = " API - getactorlist " + ex.Message;
         return(new { Message = "error", MessageReason = "There was some problem loading data. Please refresh try again! <br>" + error });
     }
 }