private void PostPageChanges() { // Insert subcontractors ProjectSubcontractor projectSubcontractor = new ProjectSubcontractor(projectTDS); int refId = projectSubcontractor.GetNewRefId(); int subcontractorId = int.Parse(ddlSubcontractorId.SelectedValue); bool writtenQuote = cbxSubcontractorWrittenQuote.Checked; bool surveyedSite = cbxSubcontractorSurveyedSite.Checked; bool workedBefore = cbxSubcontractorWorkedBefore.Checked; string role = tbxSubcontractorRole.Text.Trim(); bool agreement = cbxSubcontractorAgreement.Checked; string issues = tbxSubcontractorIssues.Text.Trim(); bool purchaseOrder = cbxSubcontractorPurchaseOrder.Checked; bool insuranceCertificate = cbxSubcontractorInsuranceCertificate.Checked; bool wsib = cbxSubcontractorWSIB.Checked; string molForm1000 = ddlSubcontractorMOLForm1000.SelectedValue; int royalties = int.Parse(tbxRoyalties.Text.Trim()); projectSubcontractor.Insert(int.Parse(hdfProjectId.Value), refId, subcontractorId, writtenQuote, surveyedSite, workedBefore, role, agreement, issues, purchaseOrder, insuranceCertificate, wsib, molForm1000, false, Int32.Parse(hdfCompanyId.Value.Trim()), royalties); }
private void InsertProjectSubcontractor(int originalProjectId) { // ... Data for current project ProjectTDS projectTDSTemp = new ProjectTDS(); ProjectSubcontractorGateway projectSubcontractorGatewayTemp = new ProjectSubcontractorGateway(projectTDSTemp); projectSubcontractorGatewayTemp.LoadAllByProjectId(originalProjectId); ProjectSubcontractorGateway projectSubcontractorGateway = new ProjectSubcontractorGateway(projectTDS); projectSubcontractorGateway.LoadAllByProjectId(originalProjectId); // ... Definition of general variables ProjectSubcontractor projectSubcontractor = new ProjectSubcontractor(projectTDS); int refId; int subcontractorId; bool writtenQuote; bool surveyedSite; bool workedBefore; string role; bool agreement; string issues; bool purchaseOrder; bool insuranceCertificate; bool wsib; string molForm1000; bool deleted; int? royalties; foreach (ProjectTDS.LFS_PROJECT_SUBCONTRACTORRow row in projectTDSTemp.Tables["LFS_PROJECT_SUBCONTRACTOR"].Rows) { refId = row.RefID; subcontractorId = row.SubcontractorID; writtenQuote = row.WrittenQuote; surveyedSite = row.SurveyedSite; workedBefore = row.WorkedBefore; try { role = row.Role; } catch { role = ""; } agreement = row.Agreement; try { issues = row.Issues; } catch { issues = ""; } purchaseOrder = row.PurchaseOrder; insuranceCertificate = row.InsuranceCertificate; wsib = row.WSIB; try { molForm1000 = row.MOLForm1000; } catch { molForm1000 = ""; } deleted = row.Deleted; try {royalties = row.Royalties;} catch { royalties = null; } // ... Insert Subcontractors projectSubcontractor.Insert(0, refId, subcontractorId, writtenQuote, surveyedSite, workedBefore, role, agreement, issues, purchaseOrder, insuranceCertificate, wsib, molForm1000, deleted, Int32.Parse(hdfCompanyId.Value.Trim()), royalties); } }