/// <summary>
/// Gets the author with the specified Aid. If there is no author
/// with the specified Aid then author is null.
/// </summary>
/// <param name="author"></param>
/// <param name="Aid"></param>
/// <returns></returns>
static public bool GetAuthor(out Author author, int Aid)
{
author = null;
SqlCommand command = new SqlCommand("SELECT * from AUTHOR WHERE Aid = @Aid");
command.Parameters.AddWithValue("@Aid", Aid);
List<Author> authorList;
bool result = GetAuthors(out authorList, command);
if (result && authorList.Count > 0)
{
author = authorList[0];
}
return result;
}
/// <summary>
/// Inserts a new author into the database. Returns false if it fails.
/// </summary>
/// <param name="author"></param>
/// <returns></returns>
static public bool Insert(Author author)
{
try
{
using (SqlConnection connection = HelperFunctions.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO AUTHOR (FirstName, LastName, BirthYear) VALUES (@FirstName, @LastName, @BirthYear)"))
{
command.Connection = connection;
command.Parameters.AddWithValue("@FirstName", HelperFunctions.ValueOrDBNull(author.FirstName));
command.Parameters.AddWithValue("@LastName", HelperFunctions.ValueOrDBNull(author.LastName));
command.Parameters.AddWithValue("@BirthYear", HelperFunctions.ValueOrDBNull(author.BirthYear));
if (command.ExecuteNonQuery() != 1)
{
return false;
}
}
}
}
catch(Exception)
{
return false;
}
return true;
}
/// <summary>
/// Updates the author in the database. Returns false if it fails.
/// </summary>
/// <param name="author"></param>
/// <returns></returns>
static public bool Update(Author author)
{
try
{
using (SqlConnection connection = HelperFunctions.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand("UPDATE AUTHOR SET FirstName=@FirstName, LastName=@LastName, BirthYear=@BirthYear WHERE Aid=@Aid"))
{
command.Connection = connection;
command.Parameters.AddWithValue("@Aid", author.Aid);
command.Parameters.AddWithValue("@FirstName", HelperFunctions.ValueOrDBNull(author.FirstName));
command.Parameters.AddWithValue("@LastName", HelperFunctions.ValueOrDBNull(author.LastName));
command.Parameters.AddWithValue("@BirthYear", HelperFunctions.ValueOrDBNull(author.BirthYear));
if (command.ExecuteNonQuery() != 1)
{
return false;
}
}
}
}
catch(Exception)
{
return false;
}
return true;
}