public void Create_Author(string Author_Name)
{
TblAuthor CreateAuthor = new TblAuthor
{
AuthorName = Author_Name
};
context.Add(CreateAuthor);
context.SaveChanges();
}
public void Create_Companios(string Compaion_Name, string Who_Played)
{
TblCompanion Createcompanion = new TblCompanion
{
CompanionName = Compaion_Name,
WhoPlayed = Who_Played
};
context.Add(Createcompanion);
context.SaveChanges();
}
public void Create_Enemy(string Enemy_Name, string Description)
{
TblEnemy CreateEnemy = new TblEnemy
{
EnemyName = Enemy_Name,
Description = Description
};
context.Add(CreateEnemy);
context.SaveChanges();
}
public void AddCompanionToEpisode(int compid, int episodeid)
{
TblEpisodeCompanion obj = new TblEpisodeCompanion
{
EpisodeId = episodeid,
CompanionId = compid
};
context.Add(obj);
context.SaveChanges();
}
public void AddEnemyToEpisode(int enemyid, int episodeid)
{
TblEpisodeEnemy obj = new TblEpisodeEnemy
{
EpisodeId = episodeid,
EnemyId = enemyid
};
context.Add(obj);
context.SaveChanges();
}
public void Create_Doctor(int Doctor_Number, string Doctor_Name, DateTime birth, DateTime FirstEpisode, DateTime LastEpisode)
{
TblDoctor CreateDoctor = new TblDoctor
{
DoctorNumber = Doctor_Number,
DoctorName = Doctor_Name,
BirthDate = birth,
FirstEpisodeDate = FirstEpisode,
LastEpisodeDate = LastEpisode
};
context.Add(CreateDoctor);
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();
}
