public Sales AddSales(int movieId, int domesticsales, int foreignsales)
{
if (string.IsNullOrWhiteSpace(movieId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(movieId));
}
var d = new CreateDelegate(movieId, domesticsales, foreignsales);
return(executor.ExecuteNonQuery(d));
}
public Person CeatePerson(string Name, string DOB, string DeathDate)
{
if (string.IsNullOrWhiteSpace(Name))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(Name));
}
if (string.IsNullOrWhiteSpace(DOB))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(DOB));
}
var d = new CreateDelegate(Name, DOB, DeathDate);
return(executor.ExecuteNonQuery(d));
}
public Oscars CreateOscars(int IndividualAwardsWonId, int MovieAwardsWonId, int Year)
{
if (string.IsNullOrWhiteSpace(IndividualAwardsWonId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(IndividualAwardsWonId));
}
if (string.IsNullOrWhiteSpace(MovieAwardsWonId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(MovieAwardsWonId));
}
if (string.IsNullOrWhiteSpace(Year.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(Year));
}
var d = new CreateDelegate(IndividualAwardsWonId, MovieAwardsWonId, Year);
return(executor.ExecuteNonQuery(d));
}
public Movie CreateMovie(int ProductionId, string MovieName, string ReleaseDate)
{
if (string.IsNullOrWhiteSpace(ProductionId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(ProductionId));
}
if (string.IsNullOrWhiteSpace(MovieName))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(MovieName));
}
if (string.IsNullOrWhiteSpace(ReleaseDate))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(ReleaseDate));
}
var d = new CreateDelegate(ProductionId, MovieName, ReleaseDate);
return(executor.ExecuteNonQuery(d));
}
public IndividualAwardsWon CreateIndividualAwardsWon(int movieId)
{
if (string.IsNullOrWhiteSpace(movieId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(movieId));
}
var d = new CreateDelegate(movieId);
return(executor.ExecuteNonQuery(d));
}
public ProductionHouse AddProductionHouse(string productionName, string location)
{
if (string.IsNullOrWhiteSpace(productionName))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(productionName));
}
if (string.IsNullOrWhiteSpace(location))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(location));
}
var d = new CreateDelegate(productionName, location);
return(executor.ExecuteNonQuery(d));
}
public MoviePerson CreateMoviePerson(int PersonId, int MovieId, string Role)
{
if (string.IsNullOrWhiteSpace(PersonId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(PersonId));
}
if (string.IsNullOrWhiteSpace(MovieId.ToString()))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(MovieId));
}
if (string.IsNullOrWhiteSpace(Role))
{
throw new ArgumentException("The parameter cannot be null or empty.", nameof(Role));
}
var d = new CreateDelegate(PersonId, MovieId, Role);
return(executor.ExecuteNonQuery(d));
}
