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"));
}
}
}
public IHttpActionResult GetUsersByCredentials(String pass, String nickOrEmail)
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
Models.USERS _user = new Models.USERS();
try
{
_user = db.USERS.FirstOrDefault(u => u.U_Pass == pass && (u.U_Email == nickOrEmail || u.U_Nick == nickOrEmail));
if (_user == null)
{
return(NotFound());
}
if (_user.U_Status != "A")
{
return(BadRequest("Usuario Inactivo, Comuníquese con el administrador"));
}
return(Ok(_user));
}
catch (Exception)
{
return(BadRequest("Ha ocurrido un error en la autenticación del usuario"));
}
}
}
public IHttpActionResult getFoodsByCategoryAd(int id)
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
IList <Models.ModelRequest.Food> foods = null;
foods = (from p in db.FOOD.Select(u => new Models.ModelRequest.Food()
{
id = u.id,
name = u.name,
description = u.description,
price = u.price,
img = u.img,
category = u.CATEGORY_FOOD.id,
status = u.status
})
where (p.category == id)
select p).ToList <Models.ModelRequest.Food>();
if (foods == null)
{
return(NotFound());
}
return(Ok(foods));
}
}
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"));
}
}
public IHttpActionResult UpdateUser(Models.ModelRequest.Users user)
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
try
{
Models.USERS _user = new Models.USERS();
_user = db.USERS.FirstOrDefault(u => u.U_Nick == user.U_Nick && u.U_Email != user.U_Email);
if (_user != null)
{
return(BadRequest("Ya existe un usuario con este Alias"));
}
_user = db.USERS.FirstOrDefault(u => u.U_Id == user.U_Id);
_user.U_Name = user.U_Name;
_user.U_Apellidos = user.U_Apellidos;
_user.U_Nick = user.U_Nick;
_user.U_Email = user.U_Email;
_user.U_Pass = user.U_Pass;
_user.U_Gender = user.U_Gender;
db.Entry(_user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
return(BadRequest("Ha ocurrido un error al actualizar el usuario"));
}
}
return(Ok("Usuario actualizado Satisfactoriamente"));
}
public IHttpActionResult ChangeTheStatusOfTheUser(int id)
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
try
{
Models.USERS _user = new Models.USERS();
_user = db.USERS.FirstOrDefault(u => u.U_Id == id);
if (_user == null)
{
return(NotFound());
}
_user.U_Status = (_user.U_Status == "A") ? "I" : "A";
db.Entry(_user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
return(BadRequest("Ha ocurrido un error al cambiar de estado"));
}
}
return(Ok("OK"));
}
public IHttpActionResult getUsers()
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
IList <Models.ModelRequest.Users> listUsers = null;
listUsers = db.USERS.Select(u => new Models.ModelRequest.Users()
{
U_Id = u.U_Id,
U_Name = u.U_Name,
U_Apellidos = u.U_Apellidos,
U_Nick = u.U_Nick,
U_Email = u.U_Email,
U_Pass = u.U_Pass,
U_Status = u.U_Status,
U_Gender = u.U_Gender
}).ToList <Models.ModelRequest.Users>();
if (listUsers != null && listUsers.Count == 0)
{
return(NotFound());
}
return(Ok(listUsers));
}
}
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;
}
}
public IHttpActionResult GetUsersById(int id)
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
try
{
Models.USERS _user = new Models.USERS();
_user = db.USERS.FirstOrDefault(u => u.U_Id == id);
if (_user == null)
{
return(NotFound());
}
return(Ok(_user));
}
catch (Exception)
{
return(BadRequest("Ha ocurrido un error al buscar el usuario"));
}
}
}
public IHttpActionResult AddUser(Models.ModelRequest.Users user)
{
using (Models.NJFOODEntities db = new Models.NJFOODEntities())
{
try
{
if (user.U_Name != null)
{
Models.USERS _User = new Models.USERS
{
U_Id = 0,
U_Name = user.U_Name,
U_Apellidos = user.U_Apellidos,
U_Nick = user.U_Nick,
U_Email = user.U_Email,
U_Pass = user.U_Pass,
U_Gender = user.U_Gender
};
_User.U_Status = "A";
db.USERS.Add(_User);
db.SaveChanges();
}
else
{
return(BadRequest("Debe completar los datos para finalizar el registro"));
}
}
catch (Exception)
{
return(BadRequest("No se puedo insertar el registro"));
}
}
return(Ok("OK"));
}
