public Milestone(IDatabaseProvider db, int projectID)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
if (projectID == InvalidID)
{
string message = Resources.String_InvalidProjectID;
throw new ArgumentException(message, nameof(projectID));
}
this.projectID = projectID;
name = string.Empty;
description = string.Empty;
state = (MilestoneState)(-1);
displayOrder = -1;
// Find max display order.
MilestonesTableAdapter tableAdapter = db.DB.MilestonesTableAdapter;
int?maxDisplayOrder = tableAdapter.GetMaxDisplayOrder(projectID);
if (maxDisplayOrder.HasValue)
{
displayOrder = maxDisplayOrder.Value + 1;
}
else
{
displayOrder = 1;
}
}
protected override void DeletePrivate(Database db)
{
MilestonesTableAdapter tableAdapter = db.MilestonesTableAdapter;
tableAdapter.DeleteByID(ID);
ID = InvalidID;
}
protected override void AddPrivate(Database db)
{
MilestonesTableAdapter tableAdapter = db.MilestonesTableAdapter;
tableAdapter.Insert(projectID, name, description, (int)state, displayOrder);
// 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 Milestone GetMilestone(IDatabaseProvider db, int id)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
MilestonesTableAdapter tableAdapter = db.DB.MilestonesTableAdapter;
PeygirDatabaseDataSet.MilestonesDataTable rows = tableAdapter.GetDataByID(id);
if (rows.Count == 1)
{
// Found.
Milestone milestone = new Milestone(rows[0]);
return(milestone);
}
// Not found.
return(null);
}
public static Milestone[] GetMilestones(IDatabaseProvider db)
{
if (db == null)
{
throw new ArgumentNullException(nameof(db));
}
MilestonesTableAdapter tableAdapter = db.DB.MilestonesTableAdapter;
PeygirDatabaseDataSet.MilestonesDataTable rows = tableAdapter.GetData();
// Create list.
List <Milestone> milestones = new List <Milestone>();
foreach (var row in rows)
{
// Add.
Milestone milestone = new Milestone(row);
milestones.Add(milestone);
}
return(milestones.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)
{
MilestonesTableAdapter tableAdapter = db.MilestonesTableAdapter;
tableAdapter.UpdateByID(projectID, name, description, (int)state, displayOrder, ID);
}
