public Ticket[] GetTickets(IDatabaseProvider db)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
if (ID == InvalidID)
{
string message = Resources.String_CurrentObjectDoesNotExistInTheDatabase;
throw new InvalidOperationException(message);
}
TicketsTableAdapter tableAdapter = db.DB.TicketsTableAdapter;
PeygirDatabaseDataSet.TicketsDataTable rows = tableAdapter.GetDataByProjectID(ID);
// Create list.
List <Ticket> tickets = new List <Ticket>();
foreach (var row in rows)
{
// Add.
Ticket ticket = new Ticket(row);
tickets.Add(ticket);
}
return(tickets.ToArray());
}
public static Ticket GetTicket(IDatabaseProvider db, int id)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
TicketsTableAdapter tableAdapter = db.DB.TicketsTableAdapter;
PeygirDatabaseDataSet.TicketsDataTable rows = tableAdapter.GetDataByID(id);
if (rows.Count == 1)
{
// Found.
Ticket ticket = new Ticket(rows[0]);
return(ticket);
}
// Not found.
return(null);
}
public static Ticket[] GetTickets(IDatabaseProvider db, int milestoneID)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
TicketsTableAdapter tableAdapter = db.DB.TicketsTableAdapter;
PeygirDatabaseDataSet.TicketsDataTable rows = tableAdapter.GetDataByMilestoneID(milestoneID);
// Create list.
List <Ticket> tickets = new List <Ticket>();
foreach (var row in rows)
{
// Add.
Ticket ticket = new Ticket(row);
tickets.Add(ticket);
}
return(tickets.ToArray());
}
