public string CreateCharMedia(PostCharMedia model)
{
var entity =
new CharMedia()
{
CharId = model.CharId,
MediaId = model.MediaId
};
using (var ctx = new ApplicationDbContext())
{
if (ctx.Characters.Count(e => e.CharId == model.CharId) == 0)
{
return($"Character {model.CharId} NOT found in table");
}
if (ctx.Media.Count(e => e.MediaId == model.MediaId) == 0)
{
return($"Media {model.MediaId} NOT found in table");
}
if (ctx.CharMedia.Count(e => e.Character.CharId == model.CharId && e.Media.MediaId == model.MediaId)
> 0)
{
return("Combination already exists");
}
ctx.CharMedia.Add(entity);
if (ctx.SaveChanges() == 1)
{
return(null);
}
return("Character/Media Combination NOT created - unknown error");
}
}
public IHttpActionResult PostCharMedia(PostCharMedia charMedia)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var service = CreateCharMediaService();
string errorText = service.CreateCharMedia(charMedia);
if (errorText == null)
{
return(Ok("Character/Media Combination created"));
}
return(BadRequest(errorText));
}
