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()); }