/// <summary>
/// Updates the Photo table by the primary key, if the Photo is dirty then an update will occur
/// </summary>
/// <param name="photo">a populated photo</param>
/// <returns>update count</returns>
public int UpdateMetaData(Photo photo, string commandText)
{
int updateCount = 0;
if(photo.IsDirty())
{
DbParameter[] parameters =
{
DbClient.MakeParameter("@PhotoID",DbType.Int32,4,photo.PhotoID),
DbClient.MakeParameter("@Title",DbType.String,100,photo.Title),
DbClient.MakeParameter("@Description",DbType.String,255,photo.Description),
DbClient.MakeParameter("@DateTaken",DbType.DateTime,8,photo.DateTaken)
};
updateCount = DbClient.NonQuery(commandText, parameters);
}
return updateCount;
}
