private void InsertProjectEngineerSubcontractors(int originalProjectId) { // ... Data for current project ProjectEngineerSubcontractorsGateway projectEngineerSubcontractorsGateway = new ProjectEngineerSubcontractorsGateway(projectTDS); projectEngineerSubcontractorsGateway.LoadAllByProjectId(originalProjectId); if (projectEngineerSubcontractorsGateway.Table.Rows.Count > 0) { // ... Definition of general variables bool generalContractor = projectEngineerSubcontractorsGateway.GetGeneralContractor(originalProjectId); bool generalWSIB = projectEngineerSubcontractorsGateway.GetGeneralWSIB(originalProjectId); bool generalInsuranceCertificate = projectEngineerSubcontractorsGateway.GetGeneralInsuranceCertificate(originalProjectId); string generalBondingSupplied = projectEngineerSubcontractorsGateway.GetGeneralBondingSupplied(originalProjectId); string generalMOLForm = projectEngineerSubcontractorsGateway.GetGeneralMOLForm(originalProjectId); bool generalNoticeProject = projectEngineerSubcontractorsGateway.GetGeneralNoticeProject(originalProjectId); bool generalForm1000 = projectEngineerSubcontractorsGateway.GetGeneralForm1000(originalProjectId); int? engineeringFirmId = null; if (projectEngineerSubcontractorsGateway.GetEngineeringFirmId(originalProjectId).HasValue) engineeringFirmId = (int)projectEngineerSubcontractorsGateway.GetEngineeringFirmId(originalProjectId); int? engineerId = null; if (projectEngineerSubcontractorsGateway.GetEngineerId(originalProjectId).HasValue) engineerId = (int)projectEngineerSubcontractorsGateway.GetEngineerId(originalProjectId); string engineerNumber = projectEngineerSubcontractorsGateway.GetEngineerNumber(originalProjectId); bool subcontractorUsed = projectEngineerSubcontractorsGateway.GetSubcontractorUsed(originalProjectId); string bondNumber = projectEngineerSubcontractorsGateway.GetBondNumber(originalProjectId); // ... insert Engineer Subcontractors ProjectEngineerSubcontractors projectEngineerSubcontractors = new ProjectEngineerSubcontractors(projectTDS); projectEngineerSubcontractors.Insert(0, generalContractor, generalWSIB, generalInsuranceCertificate, generalBondingSupplied, generalMOLForm, generalNoticeProject, generalForm1000, engineeringFirmId, engineerId, engineerNumber, subcontractorUsed, Int32.Parse(hdfCompanyId.Value.Trim()), bondNumber); } }