public async Task <TblEpisode> AddEpsiode(TblEpisode epsiode) { var result = await context.TblEpisodes.AddAsync(epsiode); await context.SaveChangesAsync(); return(result.Entity); }
public void Delete_Episode(int id) { var DeleteRecord = new TblEpisode { EpisodeId = id }; context.TblEpisodes.Attach(DeleteRecord); context.TblEpisodes.Remove(DeleteRecord); context.SaveChanges(); }
public void Create_Episode(int seriesNumber, int episodenumber, string episodeType, string title, DateTime episodeDate, int authorId, int doctorId, string notes) { TblEpisode CreateEpisode = new TblEpisode { SeriesNumber = seriesNumber, EpisodeNumber = episodenumber, EpisodeType = episodeType, Title = title, EpisodeDatedate = episodeDate, AuthorId = authorId, DoctorId = doctorId, Notes = notes }; context.Add(CreateEpisode); context.SaveChanges(); }
Create_Epsiode([FromBody] TblEpisode episode) { try { if (episode == null) { return(BadRequest()); } var createdauthor = await _epsiode_Rep.AddEpsiode(episode); return(CreatedAtAction(nameof(GetEpsiode), new { id = createdauthor.AuthorId }, createdauthor)); } catch (Exception) { return(StatusCode(StatusCodes.Status500InternalServerError, "Error creating new author record")); } }