public static Milestone GetMilestone(IDatabaseProvider db, int id)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
MilestonesTableAdapter tableAdapter = db.DB.MilestonesTableAdapter;
PeygirDatabaseDataSet.MilestonesDataTable rows = tableAdapter.GetDataByID(id);
if (rows.Count == 1)
{
// Found.
Milestone milestone = new Milestone(rows[0]);
return(milestone);
}
// Not found.
return(null);
}
public static Milestone[] GetMilestones(IDatabaseProvider db)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
MilestonesTableAdapter tableAdapter = db.DB.MilestonesTableAdapter;
PeygirDatabaseDataSet.MilestonesDataTable rows = tableAdapter.GetData();
// Create list.
List <Milestone> milestones = new List <Milestone>();
foreach (var row in rows)
{
// Add.
Milestone milestone = new Milestone(row);
milestones.Add(milestone);
}
return(milestones.ToArray());
}
