static Database() { currentnDatabasePath = null; isOpen = false; projectsTableAdapter = null; milestonesTableAdapter = null; ticketReportersTableAdapter = null; ticketAssigneesTableAdapter = null; ticketsTableAdapter = null; attachmentsWithoutContentsTableAdapter = null; attachmentsTableAdapter = null; ticketsHistoryTableAdapter = null; }
public static Attachment[] GetAttachmentsWithoutContents(IDatabaseProvider db, int ticketID) { if (db == null) { throw new ArgumentNullException(nameof(db)); } AttachmentsWithoutContentsTableAdapter tableAdapter = db.DB.AttachmentsWithoutContentsTableAdapter; PeygirDatabaseDataSet.AttachmentsWithoutContentsDataTable rows = tableAdapter.GetDataByTicketID(ticketID); // Create list. List <Attachment> attachments = new List <Attachment>(); foreach (var row in rows) { // Add. Attachment attachment = new Attachment(row); attachments.Add(attachment); } return(attachments.ToArray()); }
public static void Open(string databasePath) { if (databasePath == null) { throw new ArgumentNullException("databasePath"); } // Close. if (isOpen) { Close(); } PeygirDatabaseDataSet.ChangeDatabasePath(databasePath); projectsTableAdapter = new ProjectsTableAdapter(); milestonesTableAdapter = new MilestonesTableAdapter(); ticketReportersTableAdapter = new TicketReportersTableAdapter(); ticketAssigneesTableAdapter = new TicketAssigneesTableAdapter(); ticketsTableAdapter = new TicketsTableAdapter(); attachmentsWithoutContentsTableAdapter = new AttachmentsWithoutContentsTableAdapter(); attachmentsTableAdapter = new AttachmentsTableAdapter(); ticketsHistoryTableAdapter = new TicketsHistoryTableAdapter(); projectsTableAdapter.Connection.Open(); milestonesTableAdapter.Connection.Open(); ticketReportersTableAdapter.Connection.Open(); ticketAssigneesTableAdapter.Connection.Open(); ticketsTableAdapter.Connection.Open(); attachmentsWithoutContentsTableAdapter.Connection.Open(); attachmentsTableAdapter.Connection.Open(); ticketsHistoryTableAdapter.Connection.Open(); currentnDatabasePath = databasePath; isOpen = true; return; }
public static void Close() { if (!isOpen) { return; } projectsTableAdapter.Connection.Close(); milestonesTableAdapter.Connection.Close(); ticketReportersTableAdapter.Connection.Close(); ticketAssigneesTableAdapter.Connection.Close(); ticketsTableAdapter.Connection.Close(); attachmentsWithoutContentsTableAdapter.Connection.Close(); attachmentsTableAdapter.Connection.Close(); ticketsHistoryTableAdapter.Connection.Close(); projectsTableAdapter = null; milestonesTableAdapter = null; ticketReportersTableAdapter = null; ticketAssigneesTableAdapter = null; ticketsTableAdapter = null; attachmentsWithoutContentsTableAdapter = null; attachmentsTableAdapter = null; ticketsHistoryTableAdapter = null; currentnDatabasePath = null; isOpen = false; return; }