Esempio n. 1
0
        public IHttpActionResult getFoodById(int id)
        {
            using (Models.NJFOODEntities db = new Models.NJFOODEntities())
            {
                try
                {
                    Models.FOOD food = null;
                    food = db.FOOD.FirstOrDefault(u => u.id == id);

                    if (food == null)
                    {
                        return(NotFound());
                    }

                    Models.ModelRequest.Food foodReturn = new Models.ModelRequest.Food
                    {
                        id          = food.id,
                        name        = food.name,
                        description = food.description,
                        price       = food.price,
                        img         = food.img,
                        status      = food.status,
                        category    = food.CATEGORY_FOOD.id
                    };

                    return(Ok(foodReturn));
                }
                catch (Exception)
                {
                    return(BadRequest("Ocurrió un error al recuperar la comida"));
                }
            }
        }
Esempio n. 2
0
        public IHttpActionResult updateFood(Models.ModelRequest.Food food)
        {
            try
            {
                using (Models.NJFOODEntities db = new Models.NJFOODEntities())
                {
                    Models.FOOD dbFood = new Models.FOOD();

                    dbFood = db.FOOD.FirstOrDefault(u => u.id == food.id);

                    if (dbFood == null)
                    {
                        return(NotFound());
                    }

                    dbFood.name        = food.name;
                    dbFood.price       = food.price;
                    dbFood.description = food.description;
                    dbFood.status      = food.status;

                    db.Entry(dbFood).State = System.Data.Entity.EntityState.Modified;
                    db.SaveChanges();
                }


                return(Ok("Registro actualizado satisfactoriamente"));
            }
            catch (Exception)
            {
                return(BadRequest("Ocurrió un error al conectarse al servidor"));
            }
        }
Esempio n. 3
0
        public IHttpActionResult addFood(Models.ModelRequest.Food food)
        {
            try
            {
                using (Models.NJFOODEntities db = new Models.NJFOODEntities())
                {
                    Models.CATEGORY_FOOD category = new Models.CATEGORY_FOOD();

                    category = db.CATEGORY_FOOD.FirstOrDefault(u => u.id == food.category);

                    if (category == null)
                    {
                        return(NotFound());
                    }
                    Models.FOOD dbFood = new Models.FOOD
                    {
                        id            = 0,
                        name          = food.name,
                        description   = food.description,
                        price         = food.price,
                        img           = "",
                        status        = "A",
                        CATEGORY_FOOD = category
                    };


                    db.FOOD.Add(dbFood);
                    db.SaveChanges();

                    return(Ok("Comida agregada Satisfactoriamente"));
                }
            }
            catch (Exception)
            {
                return(BadRequest("Ha ocurrido un error al agregar la comida"));

                throw;
            }
        }