/// <summary>
/// Save all Other Costs Costing Sheet
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="costingSheetId">costingSheetId</param>
public void Save(int companyId, int costingSheetId)
{
ProjectCostingSheetAddTDS otherCostsInformationChanges = (ProjectCostingSheetAddTDS)Data.GetChanges();
if (otherCostsInformationChanges.OtherCostsInformation.Rows.Count > 0)
{
foreach (ProjectCostingSheetAddTDS.OtherCostsInformationRow row in (ProjectCostingSheetAddTDS.OtherCostsInformationDataTable)otherCostsInformationChanges.OtherCostsInformation)
{
// Insert new costing sheet Other Costs
if ((!row.Deleted) && (!row.InDatabase))
{
ProjectCostingSheetOtherCosts otherCosts = new ProjectCostingSheetOtherCosts(null);
otherCosts.InsertDirect(costingSheetId, row.RefID, row.Work_, row.Function_, row.Description, row.UnitOfMeasurement, row.Quantity, row.CostCad, row.TotalCostCad, row.CostUsd, row.TotalCostUsd, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate);
}
}
}
}
/// <summary>
/// Save all Other Costs Costing Sheet
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="costingSheetId">costingSheetId</param>
public void Save(int companyId, int costingSheetId)
{
ProjectCostingSheetInformationTDS otherCostsInformationChanges = (ProjectCostingSheetInformationTDS)Data.GetChanges();
if (otherCostsInformationChanges.OtherCostsInformation.Rows.Count > 0)
{
ProjectCostingSheetInformationOtherCostsInformationGateway projectCostingSheetInformationOtherCostsInformationGateway = new ProjectCostingSheetInformationOtherCostsInformationGateway(otherCostsInformationChanges);
foreach (ProjectCostingSheetInformationTDS.OtherCostsInformationRow row in (ProjectCostingSheetInformationTDS.OtherCostsInformationDataTable)otherCostsInformationChanges.OtherCostsInformation)
{
// Insert new costing sheet Other Costs
if ((!row.Deleted) && (!row.InDatabase))
{
ProjectCostingSheetOtherCosts otherCosts = new ProjectCostingSheetOtherCosts(null);
otherCosts.InsertDirect(costingSheetId, row.RefID, row.Work_, row.Function_, row.Description, row.UnitOfMeasurement, row.Quantity, row.CostCad, row.TotalCostCad, row.CostUsd, row.TotalCostUsd, row.Deleted, row.COMPANY_ID, row.StartDate, row.EndDate);
}
// Update costing sheet Other Costs
if ((!row.Deleted) && (row.InDatabase))
{
int refId = row.RefID;
bool deleted = false;
//original values
string originalWork_ = projectCostingSheetInformationOtherCostsInformationGateway.GetWork_Original(costingSheetId, refId);
string originalFunction = projectCostingSheetInformationOtherCostsInformationGateway.GetFunction_Original(costingSheetId, refId);
string originalDescription = projectCostingSheetInformationOtherCostsInformationGateway.GetDescriptionOriginal(costingSheetId, refId);
string originalUnitOfMeasurement = projectCostingSheetInformationOtherCostsInformationGateway.GetUnitOfMeasurementOriginal(costingSheetId, refId);
double originalQuantity = projectCostingSheetInformationOtherCostsInformationGateway.GetQuantityOriginal(costingSheetId, refId);
decimal originalCostCad = projectCostingSheetInformationOtherCostsInformationGateway.GetCostCadOriginal(costingSheetId, refId);
decimal originalTotalCostCad = projectCostingSheetInformationOtherCostsInformationGateway.GetTotalCostCadOriginal(costingSheetId, refId);
decimal originalCostUsd = projectCostingSheetInformationOtherCostsInformationGateway.GetCostUsdOriginal(costingSheetId, refId);
decimal originalTotalCostUsd = projectCostingSheetInformationOtherCostsInformationGateway.GetTotalCostUsdOriginal(costingSheetId, refId);
DateTime originalStartDate = projectCostingSheetInformationOtherCostsInformationGateway.GetStartDateOriginal(costingSheetId, refId);
DateTime originalEndDate = projectCostingSheetInformationOtherCostsInformationGateway.GetEndDateOriginal(costingSheetId, refId);
//original values
string newWork_ = projectCostingSheetInformationOtherCostsInformationGateway.GetWork_(costingSheetId, refId);
string newFunction = projectCostingSheetInformationOtherCostsInformationGateway.GetFunction_(costingSheetId, refId);
string newDescription = projectCostingSheetInformationOtherCostsInformationGateway.GetDescription(costingSheetId, refId);
string newUnitOfMeasurement = projectCostingSheetInformationOtherCostsInformationGateway.GetUnitOfMeasurement(costingSheetId, refId);
double newQuantity = projectCostingSheetInformationOtherCostsInformationGateway.GetQuantity(costingSheetId, refId);
decimal newCostCad = projectCostingSheetInformationOtherCostsInformationGateway.GetCostCad(costingSheetId, refId);
decimal newTotalCostCad = projectCostingSheetInformationOtherCostsInformationGateway.GetTotalCostCad(costingSheetId, refId);
decimal newCostUsd = projectCostingSheetInformationOtherCostsInformationGateway.GetCostUsd(costingSheetId, refId);
decimal newTotalCostUsd = projectCostingSheetInformationOtherCostsInformationGateway.GetTotalCostUsd(costingSheetId, refId);
DateTime newStartDate = projectCostingSheetInformationOtherCostsInformationGateway.GetStartDate(costingSheetId, refId);
DateTime newEndDate = projectCostingSheetInformationOtherCostsInformationGateway.GetEndDate(costingSheetId, refId);
ProjectCostingSheetOtherCosts otherCosts = new ProjectCostingSheetOtherCosts(null);
otherCosts.UpdateDirect(costingSheetId, refId, originalWork_, originalFunction, originalDescription, originalUnitOfMeasurement, originalQuantity, originalCostCad, originalTotalCostCad, originalCostUsd, originalTotalCostUsd, deleted, companyId, originalStartDate, originalEndDate, newWork_, newFunction, newDescription, newUnitOfMeasurement, newQuantity, newCostCad, newTotalCostCad, newCostUsd, newTotalCostUsd, deleted, companyId, newStartDate, newEndDate);
}
// Delete costing sheet Other Costs
if ((row.Deleted) && (row.InDatabase))
{
ProjectCostingSheetOtherCosts otherCosts = new ProjectCostingSheetOtherCosts(null);
otherCosts.DeleteDirect(row.CostingSheetID, row.RefID, row.COMPANY_ID);
}
}
}
}
