private void InsertProjectTechnical(int originalProjectId)
{
// ... Data for current project
ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(projectTDS);
projectTechnicalGateway.LoadByProjectId(originalProjectId);
if (projectTechnicalGateway.Table.Rows.Count > 0)
{
// ... Definition of general variables
bool availableDrawings = projectTechnicalGateway.GetDrawings(originalProjectId);
bool availableVideo = projectTechnicalGateway.GetVideo(originalProjectId);
bool groundConditions = projectTechnicalGateway.GetGroundConditions(originalProjectId);
string grounConditionNotes = null; if (projectTechnicalGateway.GetGrounConditionsNotes(originalProjectId) != "") grounConditionNotes = projectTechnicalGateway.GetGrounConditionsNotes(originalProjectId);
bool reviewVideoInspections = projectTechnicalGateway.GetReviewVideo(originalProjectId);
bool strangeConfigurations = projectTechnicalGateway.GetStrangeConfigurations(originalProjectId);
string strangeConfigurationsNotes = null; if (projectTechnicalGateway.GetStrangeConfigurationsNotes(originalProjectId) != "") strangeConfigurationsNotes = projectTechnicalGateway.GetStrangeConfigurationsNotes(originalProjectId);
string furtherObservations = null; if (projectTechnicalGateway.GetFurtherObservations(originalProjectId) != "") furtherObservations = projectTechnicalGateway.GetFurtherObservations(originalProjectId);
string restrictiveFactors = null; if (projectTechnicalGateway.GetRestrictiveFactors(originalProjectId) != "") restrictiveFactors = projectTechnicalGateway.GetRestrictiveFactors(originalProjectId);
// ... Insert Technical
ProjectTechnical projectTechnical = new ProjectTechnical(projectTDS);
projectTechnical.Insert(0, availableDrawings, availableVideo, groundConditions, grounConditionNotes, reviewVideoInspections, strangeConfigurations, strangeConfigurationsNotes, furtherObservations, restrictiveFactors, Int32.Parse(hdfCompanyId.Value.Trim()));
}
}
private void LoadTechnical()
{
// Data for Technical tab
ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(projectTDS);
if (projectTDS.LFS_PROJECT_TECHNICAL.Rows.Count == 0)
{
// ... If the project has no Technical
ProjectTechnical projectTechnical = new ProjectTechnical(projectTDS);
projectTechnical.Insert(int.Parse(hdfProjectId.Value), false, false, false, null, false, false, null, null, null, Int32.Parse(hdfCompanyId.Value.Trim()));
}
else
{
// ... If the project has Technical
cbxAvailableDrawings.Checked = projectTechnicalGateway.GetDrawings(int.Parse(hdfProjectId.Value));
cbxAvailableVideo.Checked = projectTechnicalGateway.GetVideo(int.Parse(hdfProjectId.Value));
//cbxGroundConditions.Checked = projectTechnicalGateway.GetGroundConditions(int.Parse(hdfProjectId.Value));
//tbxGroundCondition.Text = projectTechnicalGateway.GetGrounConditionsNotes(int.Parse(hdfProjectId.Value));
//cbxReviewVideoInspections.Checked = projectTechnicalGateway.GetReviewVideo(int.Parse(hdfProjectId.Value));
//cbxStrangeConfigurations.Checked = projectTechnicalGateway.GetStrangeConfigurations(int.Parse(hdfProjectId.Value));
//tbxStrangeConfigurations.Text = projectTechnicalGateway.GetStrangeConfigurationsNotes(int.Parse(hdfProjectId.Value));
//tbxFurtherObservations.Text = projectTechnicalGateway.GetFurtherObservations(int.Parse(hdfProjectId.Value));
//tbxRestrictiveFactors.Text = projectTechnicalGateway.GetRestrictiveFactors(int.Parse(hdfProjectId.Value));
}
}
private void LoadTechnical()
{
// Data for Technical tab
ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(projectTDS);
if (projectTechnicalGateway.Table.Rows.Count > 0)
{
cbxAvailableDrawings.Checked = projectTechnicalGateway.GetDrawings(int.Parse(hdfProjectId.Value));
cbxAvailableVideo.Checked = projectTechnicalGateway.GetVideo(int.Parse(hdfProjectId.Value));
//cbxGroundConditions.Checked = projectTechnicalGateway.GetGroundConditions(int.Parse(hdfProjectId.Value));
//tbxGroundCondition.Text = projectTechnicalGateway.GetGrounConditionsNotes(int.Parse(hdfProjectId.Value));
//cbxReviewVideoInspections.Checked = projectTechnicalGateway.GetReviewVideo(int.Parse(hdfProjectId.Value));
//cbxStrangeConfigurations.Checked = projectTechnicalGateway.GetStrangeConfigurations(int.Parse(hdfProjectId.Value));
//tbxStrangeConfigurations.Text = projectTechnicalGateway.GetStrangeConfigurationsNotes(int.Parse(hdfProjectId.Value));
//tbxFurtherObservations.Text = projectTechnicalGateway.GetFurtherObservations(int.Parse(hdfProjectId.Value));
//tbxRestrictiveFactors.Text = projectTechnicalGateway.GetRestrictiveFactors(int.Parse(hdfProjectId.Value));
}
}