public TVSeriesExtended GetExtendedTVSeriesItem(TVSeries item) { TVSeriesExtended res = null; DbCommand command = _factory.CreateCommand(); command.Connection = _connection; command.CommandText = $"SELECT TVSeriesTable.Id, TVSeriesTable.Image, TVSeriesTable.Name, TVSeriesTable.Seasons, TVSeriesTable.YearOfIssue, TVSeriesTable.Desription, Channels.Name as 'Channel' FROM TVSeriesTable JOIN Channels ON TVSeriesTable.Channel_Id = Channels.Id WHERE TVSeriesTable.Id = {item.Id}"; DbDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { res = new TVSeriesExtended((String)reader["Desription"], (String)reader["Channel"], new List <string>(), (int?)reader["Seasons"], (int)reader["Id"], (String)reader["Image"], (String)reader["Name"], (int?)reader["YearOfIssue"]); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ooops", MessageBoxButton.OK); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } command.CommandText = $"SELECT Genres.Name FROM Genres JOIN TVSeriesGenres ON Genres.Id = TVSeriesGenres.Genre_Id WHERE TVSeriesGenres.TVSeries_Id = {item.Id}"; try { reader = command.ExecuteReader(); while (reader.Read()) { res.GenreList.Add((String)reader["Name"]); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ooops", MessageBoxButton.OK); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } return(res); }
public void RemoveTvSeriesItem(TVSeries item) { try { DbCommand command = _factory.CreateCommand(); command.Connection = _connection; command.CommandText = "DELETE FROM TVSeriesTable WHERE Id = @Id"; DbParameter idParameter = _factory.CreateParameter(); SqlParameter firstNameParam = new SqlParameter("@FirstName", System.Data.SqlDbType.NVarChar, 15); idParameter.ParameterName = "@Id"; idParameter.DbType = System.Data.DbType.Int32; idParameter.Value = item.Id; command.Parameters.Add(idParameter); command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ooops", MessageBoxButton.OK); } }