/// <summary>
/// Find a Plant by ID
/// </summary>
/// <param name="id">The id of the requested Plant</param>
/// <returns>The <see cref="Plant"/></returns>
public static Plant Find(int id)
{
const string selectPlantSql = "SELECT * FROM Plant WHERE id = ?";
try
{
using (SQLiteConnection connection = Data.DataBaseAccess.DbConnection)
{
SQLiteCommand command = connection.CreateCommand(selectPlantSql, id);
Plant plant = command.ExecuteQuery <Plant>().SingleOrDefault();
Strain strain = Core.Strain.Find(plant.StrainId);
if (plant == null)
{
return(null);
}
TimeSpan span = DateTime.Now.Subtract(plant.DatePlanted);
plant.Week = span.Days / 7;
plant.ImagePath = ImageHandler.GetMostRecentDefaultImage(plant.Id);
plant.Strain = strain;
return(plant);
}
}
catch (SQLiteException)
{
return(null);
}
}
public static Strain Find(int id)
{
const string selectStrainSql = "SELECT * FROM Strain where id = ?";
using (SQLiteConnection connection = Data.DataBaseAccess.DbConnection)
{
SQLiteCommand command = connection.CreateCommand(selectStrainSql, id);
Strain strain = command.ExecuteQuery <Strain>().SingleOrDefault();
return(strain);
}
}
