public static ProjectInfo getProject(int ProjectID)
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(ProjectID);
if (projectTable.Rows.Count == 0)
{
throw new ArgumentException("Project doesn't exist");
}
return(new ProjectInfo((NuRacingDataSet.ProjectRow)projectTable.Rows[0]));
}
public static bool projectActive(int ProjectID)
{
if (!projectExists(ProjectID))
{
throw new ArgumentException("Project doesn't exist");
}
else
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(ProjectID);
return(((NuRacingDataSet.ProjectRow)projectTable.Rows[0]).Project_Active);
}
}
public void updateDatabase()
{
if (beenChanged)
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(projectID);
NuRacingDataSet.ProjectRow projectRow = (NuRacingDataSet.ProjectRow)(projectTable.Rows[0]);
projectRow.Project_Active = active;
projectRow.Project_Name = name;
projectRow.Project_Description = description;
projectRow.Project_UID = projectID;
projectRow.Project_Status = status;
projectRow.Project_StatusChangedDate = statusLastChanged;
projectAdapter.Update(projectTable);
}
}
public void resetData()
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(projectID);
NuRacingDataSet.ProjectRow projectRow = (NuRacingDataSet.ProjectRow)(projectTable.Rows[0]);
active = projectRow.Project_Active;
name = projectRow.Project_Name;
description = projectRow.Project_Description;
projectID = projectRow.Project_UID;
status = projectRow.Project_Status;
statusLastChanged = projectRow.Project_StatusChangedDate;
if (projectRow.IsProject_YearMadeNull())
{
yearMade = null;
}
else
{
yearMade = projectRow.Project_YearMade;
}
beenChanged = false;
}
public static bool projectActive(int ProjectID)
{
if (!projectExists(ProjectID))
{
throw new ArgumentException("Project doesn't exist");
}
else
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(ProjectID);
return ((NuRacingDataSet.ProjectRow)projectTable.Rows[0]).Project_Active;
}
}
public void updateDatabase()
{
if (beenChanged)
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(projectID);
NuRacingDataSet.ProjectRow projectRow = (NuRacingDataSet.ProjectRow)(projectTable.Rows[0]);
projectRow.Project_Active = active;
projectRow.Project_Name = name;
projectRow.Project_Description = description;
projectRow.Project_UID = projectID;
projectRow.Project_Status = status;
projectRow.Project_StatusChangedDate = statusLastChanged;
projectAdapter.Update(projectTable);
}
}
public void resetData()
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(projectID);
NuRacingDataSet.ProjectRow projectRow = (NuRacingDataSet.ProjectRow)(projectTable.Rows[0]);
active = projectRow.Project_Active;
name = projectRow.Project_Name;
description = projectRow.Project_Description;
projectID = projectRow.Project_UID;
status = projectRow.Project_Status;
statusLastChanged = projectRow.Project_StatusChangedDate;
if (projectRow.IsProject_YearMadeNull())
{
yearMade = null;
}
else
{
yearMade = projectRow.Project_YearMade;
}
beenChanged = false;
}
public static ProjectInfo getProject(int ProjectID)
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = projectAdapter.GetProject(ProjectID);
if (projectTable.Rows.Count == 0)
{
throw new ArgumentException("Project doesn't exist");
}
return new ProjectInfo((NuRacingDataSet.ProjectRow) projectTable.Rows[0]);
}
