public ActionResult Put([FromBody] PicturesDTO picturesDto)
{
if (PicturesDAO.Update(picturesDto))
{
return(Ok());
}
return(BadRequest());
}
public static PicturesDTO Post(PicturesDTO pictures)
{
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = REQ_POST;
command.Parameters.AddWithValue($@"{FIELD_ID_RECIPE}", pictures.IdRecipe);
command.Parameters.AddWithValue($@"{FIELD_PICTURE}", pictures.Picture);
pictures.IdPicture = (int)command.ExecuteScalar();
}
return(pictures);
}
public async Task <ActualResult> UpdateAsync(PicturesDTO dto)
{
try
{
_context.Entry(_mapper.Map <Pictures>(dto)).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(new ActualResult());
}
catch (Exception e)
{
return(new ActualResult(e.Message));
}
}
public static bool Update(PicturesDTO picture)
{
bool hasBeenChanged = false;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = REQ_UPDATE;
command.Parameters.AddWithValue($"{FIELD_ID_RECIPE}", picture.IdRecipe);
command.Parameters.AddWithValue($"{FIELD_PICTURE}", picture.Picture);
command.Parameters.AddWithValue($"{FIELD_ID_PICTURE}", picture.IdPicture);
hasBeenChanged = command.ExecuteNonQuery() == 1;
}
return(hasBeenChanged);
}
public async Task <ActualResult <string> > CreateAsync(PicturesDTO dto)
{
try
{
var mapping = _mapper.Map <Pictures>(dto);
await _context.Pictures.AddAsync(mapping);
await _context.SaveChangesAsync();
return(new ActualResult <string> {
Result = mapping.HashId
});
}
catch (Exception e)
{
return(new ActualResult <string>(e.Message));
}
}
public List <PicturesDTO> GetMovies()
{
Categories c = new Categories {
Description = "Horror",
Id = 0
};
List <Categories> listaCategorias = new List <Categories>();
PicturesDTO p = new PicturesDTO
{
category = "Action",
Id = 0,
picture_path = "../Content/Pictures/ironman1.jpg",
thumbnail_path = "../Content/ThumbNails/ironman1Icon.png",
title = "Iron Man 1",
description = "A great movie about a men in an armor",
punctuation = 4
};
PicturesDTO p1 = new PicturesDTO
{
category = "Drama",
Id = 1,
picture_path = "../Content/Pictures/thegodfather.jpg",
thumbnail_path = "../Content/ThumbNails/thegodfather.png",
title = "The Godfather",
description = "A movie of big mobster boss",
punctuation = 5
};
PicturesDTO p2 = new PicturesDTO
{
category = "Comedy",
Id = 2,
picture_path = "../Content/Pictures/scary2.jpg",
thumbnail_path = "../Content/ThumbNails/scaryIcon.png",
title = "Scary Movie 2",
description = "The horror in the whole sense of the word",
punctuation = 1
};
PicturesDTO p3 = new PicturesDTO
{
category = "Action",
Id = 3,
picture_path = "../Content/Pictures/ironman2.jpg",
thumbnail_path = "../Content/ThumbNails/Ironman2Icon.png",
title = "iron Man 2",
description = "The secuel of the men in the armor",
punctuation = 5
};
PicturesDTO p4 = new PicturesDTO
{
category = "Action",
Id = 4,
picture_path = "../Content/Pictures/venom.jpg",
thumbnail_path = "../Content/ThumbNails/venom.jpg",
title = "Venom",
description = "A venom actually",
punctuation = 3
};
PicturesDTO p5 = new PicturesDTO
{
category = "Drama",
Id = 5,
picture_path = "../Content/Pictures/shawshank.jpg",
thumbnail_path = "../Content/ThumbNails/The-Shawshank-Redemption-icon.png",
title = "Shawshank redemption",
description = "A great story about a men unfairly imprisoned",
punctuation = 5
};
List <PicturesDTO> pictures = new List <PicturesDTO>();
pictures.Add(p);
pictures.Add(p1);
pictures.Add(p2);
pictures.Add(p3);
pictures.Add(p4);
pictures.Add(p5);
return(pictures);
}
public PicturesDTO Post([FromBody] PicturesDTO picturesDto)
{
return(PicturesDAO.Post(picturesDto));
}
