static Database()
{
currentnDatabasePath = null;
isOpen = false;
projectsTableAdapter = null;
milestonesTableAdapter = null;
ticketReportersTableAdapter = null;
ticketAssigneesTableAdapter = null;
ticketsTableAdapter = null;
attachmentsWithoutContentsTableAdapter = null;
attachmentsTableAdapter = null;
ticketsHistoryTableAdapter = null;
}
public static string[] GetAssignees(IDatabaseProvider db)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
TicketAssigneesTableAdapter tableAdapter = db.DB.TicketAssigneesTableAdapter;
PeygirDatabaseDataSet.TicketAssigneesDataTable rows = tableAdapter.GetData();
// Create list.
List <string> assignees = new List <string>();
foreach (var row in rows)
{
// Add.
string assignee = row.Assignee;
assignees.Add(assignee);
}
return(assignees.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;
}