public async Task <TblEpisodeCompanion> AddEps(TblEpisodeCompanion ep)
{
var result = await context.TblEpisodeCompanions.AddAsync(ep);
await context.SaveChangesAsync();
return(result.Entity);
}
public void AddCompanionToEpisode(int compid, int episodeid)
{
TblEpisodeCompanion obj = new TblEpisodeCompanion
{
EpisodeId = episodeid,
CompanionId = compid
};
context.Add(obj);
context.SaveChanges();
}
public void Delete_Companions(int id)
{
var DeleteRecord1 = new TblEpisodeCompanion {
CompanionId = id
};
context.TblEpisodeCompanions.Attach(DeleteRecord1);
context.TblEpisodeCompanions.Remove(DeleteRecord1);
context.SaveChanges();
var DeleteRecord = new TblCompanion {
CompanionId = id
};
context.TblCompanions.Attach(DeleteRecord);
context.TblCompanions.Remove(DeleteRecord);
context.SaveChanges();
}
Createepsiode([FromBody] TblEpisodeCompanion epsiode)
{
try
{
if (epsiode == null)
{
return(BadRequest());
}
var createdauthor = await _epsiodeRep.AddEps(epsiode);
return(CreatedAtAction(nameof(GetEps),
new { id = createdauthor.EpisodeId }, createdauthor));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError,
"Error creating new employee record"));
}
}
