/// <summary> /// Save all to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { ActualCostsAddTDS hotelChanges = (ActualCostsAddTDS)Data.GetChanges(); if (hotelChanges != null) { if (hotelChanges.HotelCosts.Rows.Count > 0) { ActualCostsAddHotelCostsGateway actualCostsAddHotelCostsGateway = new ActualCostsAddHotelCostsGateway(hotelChanges); foreach (ActualCostsAddTDS.HotelCostsRow row in (ActualCostsAddTDS.HotelCostsDataTable)hotelChanges.HotelCosts) { // Insert new hotel cost if ((!row.Deleted) && (!row.InDatabase)) { int projectId = row.ProjectID; int refId = row.RefID; int hotelId = row.HotelID; decimal rateUsd = 0; if (!row.IsRateUsdNull()) rateUsd = row.RateUsd; string comment = ""; if (!row.IsCommentNull()) comment = row.Comment; ActualCostsHotelCosts actualCostsHotelCosts = new ActualCostsHotelCosts(null); actualCostsHotelCosts.InsertDirect(projectId, refId, hotelId, row.Date, row.RateCad, rateUsd, comment, row.Deleted, row.COMPANY_ID); } } } } }
// //////////////////////////////////////////////////////////////////////// // 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) { ActualCostsAddHotelCostsGateway rr = new ActualCostsAddHotelCostsGateway(); rr.LoadAllByProjectId(projectId, companyId); foreach (ActualCostsAddTDS.HotelCostsRow row1 in (ActualCostsAddTDS.HotelCostsDataTable)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.HotelCostsRow row2 in (ActualCostsAddTDS.HotelCostsDataTable)Table) { if (projectId == row2.ProjectID) { existProject = true; } } // ... ... If there are rows at the grid get new Id if (existProject) { foreach (ActualCostsAddTDS.HotelCostsRow row3 in (ActualCostsAddTDS.HotelCostsDataTable)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. ActualCostsAddHotelCostsGateway rrsc = new ActualCostsAddHotelCostsGateway(); rrsc.LoadAllByProjectId(projectId, companyId); foreach (ActualCostsAddTDS.HotelCostsRow row3 in (ActualCostsAddTDS.HotelCostsDataTable)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) { ActualCostsAddHotelCostsGateway actualCostsAddHotelCostsGateway = new ActualCostsAddHotelCostsGateway(Data); actualCostsAddHotelCostsGateway.LoadAllByProjectId(projectId, companyId); }