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);
}
