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 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 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);
}
}
