protected override void DeletePrivate(Database db) { AttachmentsTableAdapter tableAdapter = db.AttachmentsTableAdapter; tableAdapter.DeleteByID(ID); ID = InvalidID; }
protected override void AddPrivate(Database db) { AttachmentsTableAdapter tableAdapter = db.AttachmentsTableAdapter; tableAdapter.Insert(ticketID, name, size, contents); // Find ID. ID = tableAdapter.Connection.GetInsertedIdentity(); }
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 GetAttachment(IDatabaseProvider db, int id) { if (db == null) { throw new ArgumentNullException(nameof(db)); } AttachmentsTableAdapter tableAdapter = db.DB.AttachmentsTableAdapter; PeygirDatabaseDataSet.AttachmentsDataTable rows = tableAdapter.GetDataByID(id); if (rows.Count == 1) { // Found. Attachment attachment = new Attachment(rows[0]); return(attachment); } // Not found. return(null); }
public static Attachment[] GetAttachments(IDatabaseProvider db) { if (db == null) { throw new ArgumentNullException(nameof(db)); } AttachmentsTableAdapter tableAdapter = db.DB.AttachmentsTableAdapter; PeygirDatabaseDataSet.AttachmentsDataTable rows = tableAdapter.GetData(); // 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; }
protected override void UpdatePrivate(Database db) { AttachmentsTableAdapter tableAdapter = db.AttachmentsTableAdapter; tableAdapter.UpdateByID(ticketID, name, size, contents, ID); }