/// <summary>
/// Save all Revenue Costing Sheet
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="costingSheetId">costingSheetId</param>
public void Save(int companyId, int costingSheetId)
{
ProjectCostingSheetAddTDS informationChanges = (ProjectCostingSheetAddTDS)Data.GetChanges();
if (informationChanges.CombinedRevenueInformation.Rows.Count > 0)
{
foreach (ProjectCostingSheetAddTDS.CombinedRevenueInformationRow row in (ProjectCostingSheetAddTDS.CombinedRevenueInformationDataTable)informationChanges.CombinedRevenueInformation)
{
// Insert new costing sheet Revenue
if ((!row.Deleted) && (!row.InDatabase))
{
ProjectCombinedCostingSheetRevenue projectCostingSheetRevenue = new ProjectCombinedCostingSheetRevenue(null);
projectCostingSheetRevenue.InsertDirect(costingSheetId, row.RefIDRevenue, row.Revenue, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate, row.Comment, row.ProjectID);
}
}
}
}
/// <summary>
/// Save all Revenue Costing Sheets
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="costingSheetId">costingSheetId</param>
public void Save(int companyId, int costingSheetId)
{
ProjectCostingSheetInformationTDS subcontractorsInformationChanges = (ProjectCostingSheetInformationTDS)Data.GetChanges();
if (subcontractorsInformationChanges.CombinedRevenueInformation.Rows.Count > 0)
{
projectCombinedCostingSheetInformationRevenueInformationGateway projectCombinedCostingSheetInformationRevenueInformationGateway = new projectCombinedCostingSheetInformationRevenueInformationGateway(subcontractorsInformationChanges);
foreach (ProjectCostingSheetInformationTDS.CombinedRevenueInformationRow row in (ProjectCostingSheetInformationTDS.CombinedRevenueInformationDataTable)subcontractorsInformationChanges.CombinedRevenueInformation)
{
// Insert new costing sheet Revenue
if ((!row.Deleted) && (!row.InDatabase))
{
ProjectCombinedCostingSheetRevenue subcontractors = new ProjectCombinedCostingSheetRevenue(null);
subcontractors.InsertDirect(costingSheetId, row.RefIDRevenue, row.Revenue, false, row.COMPANY_ID, row.StartDate, row.EndDate, row.Comment, row.ProjectID);
}
// Update costing sheet Revenue
if ((!row.Deleted) && (row.InDatabase))
{
//int subcontractorId = row.SubcontractorID;
//int refId = row.RefID;
//bool deleted = false;
////original values
//string originalUnitOfMeasurement = projectCombinedCostingSheetInformationRevenueInformationGateway.GetUnitOfMeasurementOriginal(costingSheetId, subcontractorId, refId);
//double originalQuantity = projectCostingSheetInformationRevenueInformationGateway.GetQuantityOriginal(costingSheetId, subcontractorId, refId);
//decimal originalCostCad = projectCostingSheetInformationRevenueInformationGateway.GetCostCadOriginal(costingSheetId, subcontractorId, refId);
//decimal originalTotalCostCad = projectCostingSheetInformationRevenueInformationGateway.GetTotalCostCadOriginal(costingSheetId, subcontractorId, refId);
//decimal originalCostUsd = projectCostingSheetInformationRevenueInformationGateway.GetCostUsdOriginal(costingSheetId, subcontractorId, refId);
//decimal originalTotalCostUsd = projectCostingSheetInformationRevenueInformationGateway.GetTotalCostUsdOriginal(costingSheetId, subcontractorId, refId);
//DateTime originalStartDate = projectCostingSheetInformationRevenueInformationGateway.GetStartDateOriginal(costingSheetId, subcontractorId, refId);
//DateTime originalEndDate = projectCostingSheetInformationRevenueInformationGateway.GetEndDateOriginal(costingSheetId, subcontractorId, refId);
////original values
//string newUnitOfMeasurement = projectCostingSheetInformationRevenueInformationGateway.GetUnitOfMeasurement(costingSheetId, subcontractorId, refId);
//double newQuantity = projectCostingSheetInformationRevenueInformationGateway.GetQuantity(costingSheetId, subcontractorId, refId);
//decimal newCostCad = projectCostingSheetInformationRevenueInformationGateway.GetCostCad(costingSheetId, subcontractorId, refId);
//decimal newTotalCostCad = projectCostingSheetInformationRevenueInformationGateway.GetTotalCostCad(costingSheetId, subcontractorId, refId);
//decimal newCostUsd = projectCostingSheetInformationRevenueInformationGateway.GetCostUsd(costingSheetId, subcontractorId, refId);
//decimal newTotalCostUsd = projectCostingSheetInformationRevenueInformationGateway.GetTotalCostUsd(costingSheetId, subcontractorId, refId);
//DateTime newStartDate = projectCostingSheetInformationRevenueInformationGateway.GetStartDate(costingSheetId, subcontractorId, refId);
//DateTime newEndDate = projectCostingSheetInformationRevenueInformationGateway.GetEndDate(costingSheetId, subcontractorId, refId);
//ProjectCombinedCostingSheetRevenue subcontractors = new ProjectCombinedCostingSheetRevenue(null);
//subcontractors.UpdateDirect(costingSheetId, subcontractorId, refId, originalUnitOfMeasurement, originalQuantity, originalCostCad, originalTotalCostCad, originalCostUsd, originalTotalCostUsd, deleted, companyId, originalStartDate, originalEndDate, newUnitOfMeasurement, newQuantity, newCostCad, newTotalCostCad, newCostUsd, newTotalCostUsd, deleted, companyId, newStartDate, newEndDate);
}
// Delete costing sheet Revenue
if ((row.Deleted) && (row.InDatabase))
{
ProjectCombinedCostingSheetRevenue subcontractors = new ProjectCombinedCostingSheetRevenue(null);
subcontractors.DeleteDirect(row.CostingSheetID, row.RefIDRevenue, row.COMPANY_ID);
}
}
}
}