private ProjectInfo(NuRacingDataSet.ProjectRow projectRow)
{
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;
sponsors = new List <UserInfo>();
foreach (NuRacingDataSet.SponsoredRow sponsorRow in (new SponsoredTableAdapter().GetDataByProjectID(projectID).Rows))
{
sponsors.Add(UserInfo.getUser(sponsorRow.User_UserName));
}
}
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 static void AddProject(string ProjectName, int YearOfProject, string ProjectDescription, bool IsActive = true)
{
ProjectTableAdapter projectAdapter = new ProjectTableAdapter();
NuRacingDataSet.ProjectDataTable projectTable = new NuRacingDataSet.ProjectDataTable();
projectAdapter.Fill(projectTable);
NuRacingDataSet.ProjectRow newProjectRow = projectTable.NewProjectRow();
newProjectRow.Project_Name = ProjectName;
newProjectRow.Project_YearMade = YearOfProject;
newProjectRow.Project_Description = ProjectDescription;
newProjectRow.Project_Active = IsActive;
newProjectRow.Project_Status = "Planning";
newProjectRow.Project_StatusChangedDate = DateTime.Now;
projectTable.AddProjectRow(newProjectRow);
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;
}
