/// <summary>
/// Save all Bondings 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.BondingsInformation.Rows.Count > 0)
{
foreach (ProjectCostingSheetAddTDS.BondingsInformationRow row in (ProjectCostingSheetAddTDS.BondingsInformationDataTable)changes.BondingsInformation)
{
// Insert new costing sheet Bondings
if ((!row.Deleted) && (!row.InDatabase))
{
ProjectCostingSheetBondings projectCostingSheetBondings = new ProjectCostingSheetBondings(null);
projectCostingSheetBondings.InsertDirect(costingSheetId, row.BondingCompanyID, row.RefID, row.Rate, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate, row.Comment);
}
}
}
}
/// <summary>
/// Save all Bondings Costing Sheets
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="costingSheetId">costingSheetId</param>
public void Save(int companyId, int costingSheetId)
{
ProjectCostingSheetInformationTDS bondingsInformationChanges = (ProjectCostingSheetInformationTDS)Data.GetChanges();
if (bondingsInformationChanges.BondingsInformation.Rows.Count > 0)
{
ProjectCostingSheetInformationBondingsInformationGateway projectCostingSheetInformationBondingsInformationGateway = new ProjectCostingSheetInformationBondingsInformationGateway(bondingsInformationChanges);
foreach (ProjectCostingSheetInformationTDS.BondingsInformationRow row in (ProjectCostingSheetInformationTDS.BondingsInformationDataTable)bondingsInformationChanges.BondingsInformation)
{
// Insert new costing sheet Bondings
if ((!row.Deleted) && (!row.InDatabase))
{
ProjectCostingSheetBondings bondings = new ProjectCostingSheetBondings(null);
bondings.InsertDirect(costingSheetId, row.BondingCompanyID, row.RefID, row.Rate, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate, row.Comment);
}
// Update costing sheet Bondings
if ((!row.Deleted) && (row.InDatabase))
{
int bondingCompanyId = row.BondingCompanyID;
int refId = row.RefID;
bool deleted = false;
//original values
decimal originalRate = projectCostingSheetInformationBondingsInformationGateway.GetRateOriginal(costingSheetId, bondingCompanyId, refId);
DateTime originalStartDate = projectCostingSheetInformationBondingsInformationGateway.GetStartDateOriginal(costingSheetId, bondingCompanyId, refId);
DateTime originalEndDate = projectCostingSheetInformationBondingsInformationGateway.GetEndDateOriginal(costingSheetId, bondingCompanyId, refId);
//original values
decimal newRate = projectCostingSheetInformationBondingsInformationGateway.GetRate(costingSheetId, bondingCompanyId, refId);
DateTime newStartDate = projectCostingSheetInformationBondingsInformationGateway.GetStartDate(costingSheetId, bondingCompanyId, refId);
DateTime newEndDate = projectCostingSheetInformationBondingsInformationGateway.GetEndDate(costingSheetId, bondingCompanyId, refId);
ProjectCostingSheetBondings bondings = new ProjectCostingSheetBondings(null);
//bondings.UpdateDirect(costingSheetId, bondingCompanyId, refId, originalRate, deleted, companyId, originalStartDate, originalEndDate, newRate, deleted, companyId, newStartDate, newEndDate);
}
// Delete costing sheet Bondings
if ((row.Deleted) && (row.InDatabase))
{
/*ProjectCostingSheetBondings bondings = new ProjectCostingSheetBondings(null);
bondings.DeleteDirect(row.CostingSheetID, row.BondingCompanyID, row.RefID, row.COMPANY_ID);*/
}
}
}
}