protected override void DeletePrivate(Database db)
{
TicketsHistoryTableAdapter tableAdapter = db.TicketsHistoryTableAdapter;
tableAdapter.DeleteByID(ID);
ID = InvalidID;
}
protected override void AddPrivate(Database db)
{
TicketsHistoryTableAdapter tableAdapter = db.TicketsHistoryTableAdapter;
tableAdapter.Insert(ticketID, timestamp, changes, comment);
// 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 TicketHistory GetTicketHistory(IDatabaseProvider db, int id)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
TicketsHistoryTableAdapter tableAdapter = db.DB.TicketsHistoryTableAdapter;
PeygirDatabaseDataSet.TicketsHistoryDataTable rows = tableAdapter.GetDataByID(id);
if (rows.Count == 1)
{
// Found.
TicketHistory ticketsHistory = new TicketHistory(rows[0]);
return(ticketsHistory);
}
// Not found.
return(null);
}
public static TicketHistory[] GetTicketsHistory(IDatabaseProvider db)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
TicketsHistoryTableAdapter tableAdapter = db.DB.TicketsHistoryTableAdapter;
PeygirDatabaseDataSet.TicketsHistoryDataTable rows = tableAdapter.GetData();
// Create list.
List <TicketHistory> ticketsHistory = new List <TicketHistory>();
foreach (var row in rows)
{
// Add.
TicketHistory ticketHistory = new TicketHistory(row);
ticketsHistory.Add(ticketHistory);
}
return(ticketsHistory.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)
{
TicketsHistoryTableAdapter tableAdapter = db.TicketsHistoryTableAdapter;
tableAdapter.UpdateByID(ticketID, timestamp, changes, comment, ID);
}
