コード例 #1
0
        public string GetAllProducts()
        {
            List <movy> pro = new List <movy>();

            using (movieoutletEntities contex = new movieoutletEntities())
            {
                var  productList = from m in contex.movies select m;
                movy pros        = new movy();
                pro = productList.ToList();
                JavaScriptSerializer json = new JavaScriptSerializer();
                return(json.Serialize(pro));
            }
        }
コード例 #2
0
        public string Delete(int id)
        {
            movy itm = new movy();

            using (movieoutletEntities contex = new movieoutletEntities())
            {
                JavaScriptSerializer json = new JavaScriptSerializer();
                var productList           = from m in contex.movies where m.Id == id select m;
                itm = productList.First();
                contex.movies.Remove(itm);
                contex.SaveChanges();
                return(json.Serialize("Successful"));
            }
        }
コード例 #3
0
        public string Post(movy pro)
        {
            JavaScriptSerializer json = new JavaScriptSerializer();
            movy itm = new movy();

            itm.Id          = pro.Id;
            itm.Name        = pro.Name;
            itm.Category    = pro.Category;
            itm.Price       = pro.Price;
            itm.Description = pro.Description;

            using (movieoutletEntities contex = new movieoutletEntities())
            {
                contex.movies.Add(itm);
                contex.SaveChanges();
                return(json.Serialize("Successful"));
            }
        }
コード例 #4
0
        public IHttpActionResult GetCat(string category)
        {
            List <movy> pro = new List <movy>();

            using (movieoutletEntities contex = new movieoutletEntities())
            {
                var  productList = from m in contex.movies where m.Category == category select m;
                movy pros        = new movy();
                pro = productList.ToList();
                JavaScriptSerializer json = new JavaScriptSerializer();



                if (pro == null)
                {
                    return(NotFound());
                }
                return(Ok(json.Serialize(pro)));
            }
        }
コード例 #5
0
        public IHttpActionResult GetProduct(int id)
        {
            List <movy> pro = new List <movy>();

            using (movieoutletEntities contex = new movieoutletEntities())
            {
                var  movieList = from m in contex.movies select m;
                movy pros      = new movy();
                pro = movieList.ToList();
                JavaScriptSerializer json = new JavaScriptSerializer();


                var product = pro.FirstOrDefault((p) => p.Id == id);
                if (product == null)
                {
                    return(NotFound());
                }
                return(Ok(json.Serialize(product)));
            }
        }
コード例 #6
0
        public string Update(int id, movy pro)
        {
            movy itm = new movy();

            using (movieoutletEntities contex = new movieoutletEntities())
            {
                JavaScriptSerializer json = new JavaScriptSerializer();
                var productList           = from m in contex.movies where m.Id == id select m;
                itm = productList.First();
                contex.movies.Remove(itm);
                contex.SaveChanges();

                itm.Id          = pro.Id;
                itm.Name        = pro.Name;
                itm.Category    = pro.Category;
                itm.Price       = pro.Price;
                itm.Description = pro.Description;

                contex.movies.Add(itm);
                contex.SaveChanges();
                return(json.Serialize("Successful"));
            }
        }