public string DeleteUserSoupKitchen(int idSk, int idUser)
{
string result = "";
try
{
using (SEDESOLEntities db = new SEDESOLEntities())
{
USER_SOUP_KITCHEN att = db.USER_SOUP_KITCHEN.FirstOrDefault(v => v.Id_Soup_Kitchen == idSk && v.Id_User == idUser);
if (att != null)
{
db.USER_SOUP_KITCHEN.Remove(att);
db.SaveChanges();
result = "SUCCESS";
}
else
{
result = "No se pudo desasociar el comedor.";
}
}
}
catch (Exception ex)
{
result = "No se pudo desasociar el comedor";
}
return(result);
}
public UserSoupKitchen SaveUserSoupKitchen(UserSoupKitchen dto)
{
try
{
using (SEDESOLEntities db = new SEDESOLEntities())
{
USER_SOUP_KITCHEN ut = db.USER_SOUP_KITCHEN.FirstOrDefault(v => v.Id_User == dto.Id_User && v.Id_Soup_Kitchen == dto.Id_Soup_Kitchen);
if (ut != null)
{
dto.Message = "Se ha ingresado previamente.";
}
else
{
ut = new USER_SOUP_KITCHEN();
ut.Id_Soup_Kitchen = dto.Id_Soup_Kitchen;
ut.Id_User = dto.Id_User;
ut.IsActive = true;
db.USER_SOUP_KITCHEN.Add(ut);
if (db.SaveChanges() > 0)
{
dto.Id = ut.Id;
dto.Message = "SUCCESS";
}
}
return(dto);
}
}
catch (Exception ex)
{
return(new UserSoupKitchen());
}
}
