/// <summary>
///
/// </summary>
/// <param name="dier"></param>
/// <param name="afkorting"></param>
/// <param name="error"></param>
/// <returns></returns>
public bool GetDier(out Dier dier, string afkorting, out string error)
{
error = string.Empty;
dier = new Dier("", "", new DateTime(1, 1, 1), new DateTime(1, 1, 1), -1);
try
{
string query = "SELECT * FROM Dier WHERE afkorting = :afkorting";
using (OracleConnection conn = new OracleConnection(connectionString))
{
OracleCommand command = new OracleCommand(query, conn);
command.Parameters.Add(new OracleParameter("afkorting",afkorting));
conn.Open();
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//item = Convert.ToInt32(reader["item"]);
string naam = Convert.ToString(reader["naam"]);
string dateStr1 = Convert.ToString(reader["broedBegin"]);
string dateStr2 = Convert.ToString(reader["broedEind"]);
int minWaarneemPaar = Convert.ToInt32(reader["minWaarnemingPaar"]);
DateTime date1 = new DateTime(0, Convert.ToInt32(dateStr1.Split('-')[0]), Convert.ToInt32(dateStr1.Split('-')[1]));
DateTime date2 = new DateTime(0, Convert.ToInt32(dateStr2.Split('-')[0]), Convert.ToInt32(dateStr2.Split('-')[1]));
dier=new Dier(naam, afkorting, date1, date2, minWaarneemPaar);
}
reader.Close();
}
if (dier.ToString() == new Dier("", "", new DateTime(1, 1, 1), new DateTime(1, 1, 1), -1).ToString())
{
error = "Kon geen dieren vinden.";
return false;
}
return true;
}
catch (Exception e)
{
// set error message and return false
error = e.Message;
return false;
}
}
