// //////////////////////////////////////////////////////////////////////// // PRIVATE METHODS // /// <summary> /// GetNewRefId /// </summary> /// <param name="projectId">projectId</param> /// <param name="companyId">companyId</param> /// <returns>New ID</returns> public int GetNewRefId(int projectId, int companyId) { int newRefId = 0; if (Table.Rows.Count == 0) { ActualCostsAddSubcontractorCostsGateway rr = new ActualCostsAddSubcontractorCostsGateway(); rr.LoadAllByProjectId(projectId, companyId); foreach (ActualCostsAddTDS.SubcontractorCostsRow row1 in (ActualCostsAddTDS.SubcontractorCostsDataTable)rr.Table) { if (newRefId < row1.RefID) { newRefId = row1.RefID; } } } else { // ... If there are rows at the grid // ... ... Verify if there are rows for the same project at the grid bool existProject = false; foreach (ActualCostsAddTDS.SubcontractorCostsRow row2 in (ActualCostsAddTDS.SubcontractorCostsDataTable)Table) { if (projectId == row2.ProjectID) { existProject = true; } } // ... ... If there are rows at the grid get new Id if (existProject) { foreach (ActualCostsAddTDS.SubcontractorCostsRow row3 in (ActualCostsAddTDS.SubcontractorCostsDataTable)Table) { if (projectId == row3.ProjectID) { if (newRefId < row3.RefID) { newRefId = row3.RefID; } } } } else { // ... ... There are no rows for the project at the grid, verify on de db. ActualCostsAddSubcontractorCostsGateway rrsc = new ActualCostsAddSubcontractorCostsGateway(); rrsc.LoadAllByProjectId(projectId, companyId); foreach (ActualCostsAddTDS.SubcontractorCostsRow row3 in (ActualCostsAddTDS.SubcontractorCostsDataTable)rrsc.Table) { if (newRefId < row3.RefID) { newRefId = row3.RefID; } } } } newRefId++; return newRefId; }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS - DATASET // /// <summary> /// LoadAllByProjectId /// </summary> /// <param name="projectId">projectId</param> /// <param name="companyId">companyId</param> public void LoadAllByProjectId(int projectId, int companyId) { ActualCostsAddSubcontractorCostsGateway actualCostsAddSubcontractorCostsGateway = new ActualCostsAddSubcontractorCostsGateway(Data); actualCostsAddSubcontractorCostsGateway.LoadAllByProjectId(projectId, companyId); }