/// <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);*/
}
}
}
}
