/// <summary> /// Save all Hotels Costing Sheet /// </summary> /// <param name="companyId">companyId</param> /// <param name="costingSheetId">costingSheetId</param> public void Save(int companyId, int costingSheetId) { ProjectCostingSheetAddTDS changes = (ProjectCostingSheetAddTDS)Data.GetChanges(); if (changes.HotelsInformation.Rows.Count > 0) { foreach (ProjectCostingSheetAddTDS.HotelsInformationRow row in (ProjectCostingSheetAddTDS.HotelsInformationDataTable)changes.HotelsInformation) { // Insert new costing sheet Hotels if ((!row.Deleted) && (!row.InDatabase)) { ProjectCostingSheetHotels projectCostingSheetHotels = new ProjectCostingSheetHotels(null); projectCostingSheetHotels.InsertDirect(costingSheetId, row.HotelID, row.RefID, row.Rate, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate, row.Comment); } } } }
/// <summary> /// Save all Hotels Costing Sheets /// </summary> /// <param name="companyId">companyId</param> /// <param name="costingSheetId">costingSheetId</param> public void Save(int companyId, int costingSheetId) { ProjectCostingSheetInformationTDS hotelsInformationChanges = (ProjectCostingSheetInformationTDS)Data.GetChanges(); if (hotelsInformationChanges.HotelsInformation.Rows.Count > 0) { ProjectCostingSheetInformationHotelsInformationGateway projectCostingSheetInformationHotelsInformationGateway = new ProjectCostingSheetInformationHotelsInformationGateway(hotelsInformationChanges); foreach (ProjectCostingSheetInformationTDS.HotelsInformationRow row in (ProjectCostingSheetInformationTDS.HotelsInformationDataTable)hotelsInformationChanges.HotelsInformation) { // Insert new costing sheet Hotels if ((!row.Deleted) && (!row.InDatabase)) { ProjectCostingSheetHotels hotels = new ProjectCostingSheetHotels(null); hotels.InsertDirect(costingSheetId, row.HotelID, row.RefID, row.Rate, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate, row.Comment); } // Update costing sheet Hotels if ((!row.Deleted) && (row.InDatabase)) { int hotelId = row.HotelID; int refId = row.RefID; bool deleted = false; //original values decimal originalRate = projectCostingSheetInformationHotelsInformationGateway.GetRateOriginal(costingSheetId, hotelId, refId); DateTime originalStartDate = projectCostingSheetInformationHotelsInformationGateway.GetStartDateOriginal(costingSheetId, hotelId, refId); DateTime originalEndDate = projectCostingSheetInformationHotelsInformationGateway.GetEndDateOriginal(costingSheetId, hotelId, refId); //original values decimal newRate = projectCostingSheetInformationHotelsInformationGateway.GetRate(costingSheetId, hotelId, refId); DateTime newStartDate = projectCostingSheetInformationHotelsInformationGateway.GetStartDate(costingSheetId, hotelId, refId); DateTime newEndDate = projectCostingSheetInformationHotelsInformationGateway.GetEndDate(costingSheetId, hotelId, refId); ProjectCostingSheetHotels hotels = new ProjectCostingSheetHotels(null); //hotels.UpdateDirect(costingSheetId, hotelId, refId, originalRate, deleted, companyId, originalStartDate, originalEndDate, newRate, deleted, companyId, newStartDate, newEndDate); } // Delete costing sheet Hotels if ((row.Deleted) && (row.InDatabase)) { /*ProjectCostingSheetHotels hotels = new ProjectCostingSheetHotels(null); hotels.DeleteDirect(row.CostingSheetID, row.HotelID, row.RefID, row.COMPANY_ID);*/ } } } }