/// <summary>
/// Get a ComicstripBundle by ID
/// </summary>
public ComicstripBundle GetByID(int id)
{
try
{
SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[ComicstripBundles] WHERE Id = @Id", this.context);
cmd.Parameters.AddWithValue("@Id", id);
context.Open();
SqlDataAdapter reader = new SqlDataAdapter(cmd);
DataTable table = new DataTable();
reader.Fill(table);
context.Close();
if (table.Rows.Count > 0)
{
PublisherRepository pr = new PublisherRepository(this.context);
return(table.AsEnumerable().Select(b => new ComicstripBundle(b.Field <int>("Id"), b.Field <string>("Title"), this.GetComicstrips(b.Field <int>("Id")), pr.GetByID(b.Field <int>("Publisher_Id")))).Single <ComicstripBundle>());
}
}
catch (Exception) { throw new QueryException(); }
return(null);
}