public bool DeleteFilms(FilmsMember filmsMember) { return(_filmsRepository.DeleteFilm(new FilmsMemberDAO { FilmId = filmsMember.FilmId })); }
public ValidationResultString UpdateFilms(FilmsMember filmsMember) { if (sqlConnect.GetConnect) { sqlConnect.OpenConn(); } ValidationResultString result = new ValidationResultString() { IsValid = true }; try { string commPart = " UPDATE maindb.\"Films\" " + " SET \"BasePrice\" = @1, \"Country\" = @2, " + "\"Duration\" = @3::interval, \"Genre\" = @4, \"Producer\" = @5, \"ReleaseDate\" = @6, \"Title\" = @7 " + " WHERE \"FilmId\" = @8;"; NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn); command.Parameters.AddWithValue("@1", Convert.ToDouble(filmsMember.BasePrice)); command.Parameters.AddWithValue("@2", Convert.ToString(filmsMember.Country)); command.Parameters.AddWithValue("@3", filmsMember.Duration); command.Parameters.AddWithValue("@4", Convert.ToString(filmsMember.Genre)); command.Parameters.AddWithValue("@5", Convert.ToString(filmsMember.Producer)); command.Parameters.AddWithValue("@6", Convert.ToDateTime(filmsMember.ReleaseDate)); command.Parameters.AddWithValue("@7", Convert.ToString(filmsMember.Title)); command.Parameters.AddWithValue("@8", Convert.ToInt32(filmsMember.FilmId)); NpgsqlDataReader readerTable = command.ExecuteReader(); readerTable.Close(); } catch (Npgsql.PostgresException exp) { return(new ValidationResultString { Errors = new List <string> { exp.SqlState } }); } finally { if (!sqlConnect.GetConnect) { sqlConnect.CloseConn(); } } return(result); }
public bool InsertFilms(FilmsMember filmsMember) { return(_filmsRepository.InsertFilm(new FilmsMemberDAO { Country = filmsMember.Country, Duration = filmsMember.Duration, Producer = filmsMember.Producer, Genre = filmsMember.Genre, ReleaseDate = filmsMember.ReleaseDate, Title = filmsMember.Title, BasePrice = filmsMember.BasePrice })); }
public ValidationResultString InsertFilms(FilmsMember filmsMember) { if (sqlConnect.GetConnect) { sqlConnect.OpenConn(); } ValidationResultString result = new ValidationResultString() { IsValid = true }; try { string commPart = "INSERT INTO maindb.\"Films\" ( \"BasePrice\", \"Country\", \"Duration\", \"Genre\", \"Producer\", \"ReleaseDate\", \"Title\") VALUES " + " (@1, @2, @3::interval, @4, @5, @6, @7)"; NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn); command.Parameters.AddWithValue("@1", Convert.ToDouble(filmsMember.BasePrice)); command.Parameters.AddWithValue("@2", Convert.ToString(filmsMember.Country)); command.Parameters.AddWithValue("@3", filmsMember.Duration); command.Parameters.AddWithValue("@4", Convert.ToString(filmsMember.Genre)); command.Parameters.AddWithValue("@5", Convert.ToString(filmsMember.Producer)); command.Parameters.AddWithValue("@6", Convert.ToDateTime(filmsMember.ReleaseDate)); command.Parameters.AddWithValue("@7", Convert.ToString(filmsMember.Title)); NpgsqlDataReader readerTable = command.ExecuteReader(); readerTable.Close(); } catch (Npgsql.PostgresException exp) { return(new ValidationResultString { Errors = new List <string> { exp.SqlState } }); } finally { if (!sqlConnect.GetConnect) { sqlConnect.CloseConn(); } } return(result); }
public ValidationResultString DeleteFilms(FilmsMember filmsMember) { if (sqlConnect.GetConnect) { sqlConnect.OpenConn(); } ValidationResultString result = new ValidationResultString() { IsValid = true }; try { string commPart = "DELETE FROM maindb.\"Films\" WHERE \"FilmId\"=@1"; NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn); command.Parameters.AddWithValue("@1", Convert.ToInt32(filmsMember.FilmId)); NpgsqlDataReader readerTable = command.ExecuteReader(); readerTable.Close(); } catch (Npgsql.PostgresException exp) { return(new ValidationResultString { Errors = new List <string> { exp.SqlState } }); } finally { if (!sqlConnect.GetConnect) { sqlConnect.CloseConn(); } } return(result); }
public bool UpdateFilm(FilmsMember filmsMember) { var res = UpdateFilms(filmsMember); return(res.IsValid); }
public bool DeleteFilm(FilmsMember filmsMember) { var res = DeleteFilms(filmsMember); return(res.IsValid); }
public bool InsertFilm(FilmsMember filmsMember) { var res = InsertFilms(filmsMember); return(res.IsValid); }