// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// Load
/// </summary>
/// <param name="works">works</param>
/// <param name="projectId">projectId</param>
/// <param name="startDate">startDate</param>
/// <param name="endDate">endDate</param>
/// <param name="companyId">companyId</param>
public void Load(ArrayList works, int projectId, DateTime startDate, DateTime endDate, int companyId)
{
int refId = 0;
// Foreach of Works (FLL, RA, JL, PR, MH Rehab, MOB, Other)
foreach (string work_ in works)
{
// Load Functions by Work
ProjectCostingSheetAddFunctionListGateway projectCostingSheetAddFunctionListGateway = new ProjectCostingSheetAddFunctionListGateway();
projectCostingSheetAddFunctionListGateway.LoadByWork_(work_);
// Foreach of Functions
foreach (ProjectCostingSheetAddTDS.FunctionListRow functionListRow in (ProjectCostingSheetAddTDS.FunctionListDataTable)projectCostingSheetAddFunctionListGateway.Table)
{
ProjectCostingSheetAddUnitListGateway projectCostingSheetAddUnitListGateway = new ProjectCostingSheetAddUnitListGateway(Data);
projectCostingSheetAddUnitListGateway.LoadByProjectIdStartDateEndDateWorkFunction(projectId, startDate, endDate, work_, functionListRow.Function_, companyId);
foreach (ProjectCostingSheetAddTDS.UnitListRow unitListRow in (ProjectCostingSheetAddTDS.UnitListDataTable)projectCostingSheetAddUnitListGateway.Table)
{
DateTime newStartDate = new DateTime();
newStartDate = startDate;
DateTime newEndDate = new DateTime();
newEndDate = endDate;
ProjectCostingSheetAddUnitPayPeriodGateway ProjectCostingSheetAddUnitPayPeriodGateway = new ProjectCostingSheetAddUnitPayPeriodGateway(Data);
ProjectCostingSheetAddUnitPayPeriodGateway.LoadByStartDateEndDateUnitId(startDate, endDate, unitListRow.UnitID);
if (ProjectCostingSheetAddUnitPayPeriodGateway.Table.Rows.Count > 0)
{
foreach (ProjectCostingSheetAddTDS.UnitPayPeriodRow unitPayPeriodRow in (ProjectCostingSheetAddTDS.UnitPayPeriodDataTable)ProjectCostingSheetAddUnitPayPeriodGateway.Table)
{
newEndDate = unitPayPeriodRow.Date_.AddDays(-1);
ProjectCostingSheetAddOriginalUnitGateway projectCostingSheetAddOriginalUnitGateway = new ProjectCostingSheetAddOriginalUnitGateway(Data);
projectCostingSheetAddOriginalUnitGateway.Load(projectId, newStartDate, newEndDate, work_, functionListRow.Function_, unitListRow.UnitID);
if (projectCostingSheetAddOriginalUnitGateway.Table.Rows.Count > 0)
{
ArrayList days = new ArrayList();
ArrayList daysTowed = new ArrayList();
double quantity = 0;
bool isTowedUnitId = false;
PrintProjectCostingGateway verifGateway = new PrintProjectCostingGateway(new DataSet());
foreach (ProjectCostingSheetAddTDS.OriginalUnitRow originalUnitRow in (ProjectCostingSheetAddTDS.OriginalUnitDataTable)projectCostingSheetAddOriginalUnitGateway.Table)
{
int towedUnitId = 0;
if (!originalUnitRow.IsTowedUnitIDNull())
{
towedUnitId = Convert.ToInt32(originalUnitRow.TowedUnitID);
}
if (originalUnitRow.UnitID != towedUnitId)
{
if (!days.Contains(originalUnitRow.Date_))
{
int amountProjects = verifGateway.UnitSameDayUseSeveralProjects(originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountProjects > 1)
{
double tempQuantity = 1 / Convert.ToDouble(amountProjects);
int amountFunctions = verifGateway.UnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = tempQuantity / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
else
{
double tempQuantity = 1;
int amountFunctions = verifGateway.UnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = 1 / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
days.Add(originalUnitRow.Date_);
}
}
else
{
isTowedUnitId = true;
if (!daysTowed.Contains(originalUnitRow.Date_))
{
int amountProjects = verifGateway.TowedUnitSameDayUseSeveralProjects(originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountProjects > 1)
{
double tempQuantity = 1 / Convert.ToDouble(amountProjects);
int amountFunctions = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = tempQuantity / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
else
{
double tempQuantity = 1;
int amountFunctions = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = 1 / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
daysTowed.Add(originalUnitRow.Date_);
}
}
}
ProjectCostingSheetAddTDS.UnitsInformationRow newRow = ((ProjectCostingSheetAddTDS.UnitsInformationDataTable)Table).NewUnitsInformationRow();
GetUnitData(newStartDate, newEndDate, unitListRow.UnitID, work_, newRow, isTowedUnitId);
newRow.CostingSheetID = 0;
newRow.Work_ = work_;
newRow.UnitID = unitListRow.UnitID;
newRow.RefID = refId++;
newRow.Quantity = quantity;
newRow.TotalCostCad = (Convert.ToDecimal(quantity) * newRow.CostCad);
newRow.TotalCostUsd = (Convert.ToDecimal(quantity) * newRow.CostUsd);
newRow.Deleted = false;
newRow.InDatabase = false;
newRow.COMPANY_ID = companyId;
newRow.UnitCode = unitListRow.UnitCode;
newRow.UnitDescription = unitListRow.Description;
newRow.UnitOfMeasurement = unitListRow.UnitOfMeasurement;
newRow.StartDate = newStartDate;
newRow.EndDate = newEndDate;
newRow.FromDatabase = true;
newRow.Function_ = functionListRow.Function_;
newRow.WorkFunction = work_ + " . " + functionListRow.Function_;
((ProjectCostingSheetAddTDS.UnitsInformationDataTable)Table).AddUnitsInformationRow(newRow);
}
newStartDate = newEndDate.AddDays(1);
}
if (newEndDate <= endDate)
{
ProjectCostingSheetAddOriginalUnitGateway projectCostingSheetAddOriginalUnitGateway = new ProjectCostingSheetAddOriginalUnitGateway(Data);
projectCostingSheetAddOriginalUnitGateway.Load(projectId, newStartDate, endDate, work_, functionListRow.Function_, unitListRow.UnitID);
if (projectCostingSheetAddOriginalUnitGateway.Table.Rows.Count > 0)
{
ArrayList days = new ArrayList();
ArrayList daysTowed = new ArrayList();
double quantity = 0;
bool isTowedUnitId = false;
PrintProjectCostingGateway verifGateway = new PrintProjectCostingGateway(new DataSet());
foreach (ProjectCostingSheetAddTDS.OriginalUnitRow originalUnitRow in (ProjectCostingSheetAddTDS.OriginalUnitDataTable)projectCostingSheetAddOriginalUnitGateway.Table)
{
int towedUnitId = 0;
if (!originalUnitRow.IsTowedUnitIDNull())
{
towedUnitId = Convert.ToInt32(originalUnitRow.TowedUnitID);
}
if (originalUnitRow.UnitID != towedUnitId)
{
if (!days.Contains(originalUnitRow.Date_))
{
int amountProjects = verifGateway.UnitSameDayUseSeveralProjects(originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountProjects > 1)
{
double tempQuantity = 1 / Convert.ToDouble(amountProjects);
int amountFunctions = verifGateway.UnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = tempQuantity / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
else
{
double tempQuantity = 1;
int amountFunctions = verifGateway.UnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = 1 / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
days.Add(originalUnitRow.Date_);
}
}
else
{
isTowedUnitId = true;
if (!daysTowed.Contains(originalUnitRow.Date_))
{
int amountProjects = verifGateway.TowedUnitSameDayUseSeveralProjects(originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountProjects > 1)
{
double tempQuantity = 1 / Convert.ToDouble(amountProjects);
int amountFunctions = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = tempQuantity / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
else
{
double tempQuantity = 1;
int amountFunctions = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = 1 / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
daysTowed.Add(originalUnitRow.Date_);
}
}
}
ProjectCostingSheetAddTDS.UnitsInformationRow newRow = ((ProjectCostingSheetAddTDS.UnitsInformationDataTable)Table).NewUnitsInformationRow();
GetUnitData(newStartDate, endDate, unitListRow.UnitID, work_, newRow, isTowedUnitId);
newRow.CostingSheetID = 0;
newRow.Work_ = work_;
newRow.UnitID = unitListRow.UnitID;
newRow.RefID = refId++;
newRow.Quantity = quantity;
newRow.TotalCostCad = (Convert.ToDecimal(quantity) * newRow.CostCad);
newRow.TotalCostUsd = (Convert.ToDecimal(quantity) * newRow.CostUsd);
newRow.Deleted = false;
newRow.InDatabase = false;
newRow.COMPANY_ID = companyId;
newRow.UnitCode = unitListRow.UnitCode;
newRow.UnitDescription = unitListRow.Description;
newRow.UnitOfMeasurement = unitListRow.UnitOfMeasurement;
newRow.StartDate = newStartDate;
newRow.EndDate = endDate;
newRow.FromDatabase = true;
newRow.Function_ = functionListRow.Function_;
newRow.WorkFunction = work_ + " . " + functionListRow.Function_;
((ProjectCostingSheetAddTDS.UnitsInformationDataTable)Table).AddUnitsInformationRow(newRow);
}
}
}
else
{
ProjectCostingSheetAddOriginalUnitGateway projectCostingSheetAddOriginalUnitGateway = new ProjectCostingSheetAddOriginalUnitGateway(Data);
projectCostingSheetAddOriginalUnitGateway.Load(projectId, startDate, endDate, work_, functionListRow.Function_, unitListRow.UnitID);
if (projectCostingSheetAddOriginalUnitGateway.Table.Rows.Count > 0)
{
ArrayList days = new ArrayList();
ArrayList daysTowed = new ArrayList();
double quantity = 0;
bool isTowedUnitId = false;
PrintProjectCostingGateway verifGateway = new PrintProjectCostingGateway(new DataSet());
foreach (ProjectCostingSheetAddTDS.OriginalUnitRow originalUnitRow in (ProjectCostingSheetAddTDS.OriginalUnitDataTable)projectCostingSheetAddOriginalUnitGateway.Table)
{
int towedUnitId = 0; if (!originalUnitRow.IsTowedUnitIDNull()) towedUnitId = Convert.ToInt32(originalUnitRow.TowedUnitID);
if (originalUnitRow.UnitID != towedUnitId)
{
if (!days.Contains(originalUnitRow.Date_))
{
int amountProjects = verifGateway.UnitSameDayUseSeveralProjects(originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountProjects > 1)
{
double tempQuantity = 1 / Convert.ToDouble(amountProjects);
int amountFunctions = verifGateway.UnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = tempQuantity / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
else
{
double tempQuantity = 1;
int amountFunctions = verifGateway.UnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = 1 / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
days.Add(originalUnitRow.Date_);
}
}
else
{
isTowedUnitId = true;
if (!daysTowed.Contains(originalUnitRow.Date_))
{
int amountProjects = verifGateway.TowedUnitSameDayUseSeveralProjects(originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountProjects > 1)
{
double tempQuantity = 1 / Convert.ToDouble(amountProjects);
int amountFunctions = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = tempQuantity / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
else
{
double tempQuantity = 1;
int amountFunctions = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(projectId, originalUnitRow.Date_, originalUnitRow.UnitID);
if (amountFunctions > 0)
{
tempQuantity = 1 / Convert.ToDouble(amountFunctions);
}
quantity = quantity + tempQuantity;
}
daysTowed.Add(originalUnitRow.Date_);
}
}
}
ProjectCostingSheetAddTDS.UnitsInformationRow newRow = ((ProjectCostingSheetAddTDS.UnitsInformationDataTable)Table).NewUnitsInformationRow();
GetUnitData(startDate, endDate, unitListRow.UnitID, work_, newRow, isTowedUnitId);
newRow.CostingSheetID = 0;
newRow.Work_ = work_;
newRow.UnitID = unitListRow.UnitID;
newRow.RefID = refId++;
newRow.Quantity = quantity;
newRow.TotalCostCad = (Convert.ToDecimal(quantity) * newRow.CostCad);
newRow.TotalCostUsd = (Convert.ToDecimal(quantity) * newRow.CostUsd);
newRow.Deleted = false;
newRow.InDatabase = false;
newRow.COMPANY_ID = companyId;
newRow.UnitCode = unitListRow.UnitCode;
newRow.UnitDescription = unitListRow.Description;
newRow.UnitOfMeasurement = unitListRow.UnitOfMeasurement;
newRow.StartDate = startDate;
newRow.EndDate = endDate;
newRow.FromDatabase = true;
newRow.Function_ = functionListRow.Function_;
newRow.WorkFunction = work_ + " . " + functionListRow.Function_;
((ProjectCostingSheetAddTDS.UnitsInformationDataTable)Table).AddUnitsInformationRow(newRow);
}
}
}
}
}
}
/// <summary>
/// LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWorkFunction
/// </summary>
/// <para>Load Original to process data for Project Costing report with filters</para>
/// <param name="companiesId">Company filter (client) for Project Costing report</param>
/// <param name="projectId">Project filter for Project Costing reports</param>
/// <param name="startDate">Start date filter Project Costing report</param>
/// <param name="endDate">End date filter for Project Costing report</param>
/// <param name="projectTimeState">State filter for Project Costing report</param>
/// <param name="work">work</param>
/// <param name="function">function</param>
/// <param name="companyId">companyId</param>
public void LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWorkFunction(int companiesId, int projectId, DateTime startDate, DateTime endDate, string projectTimeState, string work, string function, int companyId)
{
PrintProjectCostingGateway printProjectCostingGateway = new PrintProjectCostingGateway(Data);
printProjectCostingGateway.LoadByCompaniesIdProjectIdStartDateEndDateProjectTimeStateWorkFunction(companiesId, projectId, startDate, endDate, projectTimeState, work, function);
this.ProcessDataForProject(companyId);
}
/// <summary>
/// UnitSameDayUseSeveralWorkFunctions
/// </summary>
/// <param name="date">date</param>
/// <param name="unitId">unitId</param>
/// <returns></returns>
private int UnitSameDayUseSeveralWorkFunctions(DateTime date, int unitId)
{
int amount = 0;
PrintProjectCostingGateway verifGateway = new PrintProjectCostingGateway(new DataSet());
verifGateway.UnitSameDayUseSeveralProjects(date, unitId);
amount = verifGateway.Table.Rows.Count;
return amount;
}
/// <summary>
/// ProcessDataForProject
/// </summary>
/// <para>Process de data from the original table for the Project Costing report</para>
/// <param name="companyId">companyId</param>
public void ProcessDataForProject(int companyId)
{
// Instanciate a new PrintProjectCostingGateway for the control of times that one unit is used in different projects
PrintProjectCostingGateway verifGateway = new PrintProjectCostingGateway(new DataSet());
// Fill rows from original data
PrintProjectCostingGateway originalGateway = new PrintProjectCostingGateway(Data);
foreach (PrintProjectCostingTDS.OriginalRow originalRow in (PrintProjectCostingTDS.OriginalDataTable)originalGateway.Table)
{
PrintProjectCostingTDS.PrintProjectCostingRow newRow = ((PrintProjectCostingTDS.PrintProjectCostingDataTable)Table).NewPrintProjectCostingRow();
newRow.ClientID = originalRow.ClientID;
newRow.ClientName = originalRow.ClientName;
newRow.ProjectName = originalRow.ProjectName;
newRow.CountryID = originalRow.CountryID;
newRow.CountryName = originalRow.CountryName;
newRow.EmployeeID = originalRow.EmployeeID;
newRow.EmployeeName = originalRow.EmployeeName;
newRow.Date_ = originalRow.Date_;
if (!originalRow.IsWork_Null()) newRow.Work_ = originalRow.Work_; else newRow.SetWork_Null();
if (!originalRow.IsFunction_Null()) newRow.Function_ = originalRow.Function_; else newRow.SetFunction_Null();
if (!originalRow.IsFairWageNull()) newRow.FairWage = originalRow.FairWage; else newRow.FairWage = false;
if (!originalRow.IsUnitNull()) newRow.Unit = originalRow.Unit; else newRow.SetUnitNull();
if (!originalRow.IsTowedNull()) newRow.Towed = originalRow.Towed; else newRow.SetTowedNull();
// ...Stablishing the country of the project
if (originalRow.CountryID == 1)
{
newRow.TimeCA = originalRow.ProjectTime;
newRow.TimeUS = 0;
}
else
{
newRow.TimeCA = 0;
newRow.TimeUS = originalRow.ProjectTime;
}
// ...Stablishing the type of labour day: Sick Day, Holiday, Vacation or Normal work day
if ((originalRow.WorkingDetails == "Sick Day") || (originalRow.WorkingDetails == "Holiday") || (originalRow.WorkingDetails == "Vacation / Other") || (originalRow.WorkingDetails == "Day Off - No Pay"))
{
newRow.WorkingDetails = originalRow.WorkingDetails;
}
else
{
newRow.WorkingDetails = "";
}
// ...Stablishing the total and the meals, depending on the MealsCountry defined: Canada or United States
if (!originalRow.IsMealsCountryNull())
{
if (originalRow.MealsCountry == 1)
{
newRow.MealsCA = true;
newRow.MealsUS = false;
newRow.TotalCA = originalRow.MealsAllowance;
newRow.TotalUS = 0;
}
else
{
newRow.MealsCA = false;
newRow.MealsUS = true;
newRow.TotalCA = 0;
newRow.TotalUS = originalRow.MealsAllowance;
}
}
else
{
newRow.MealsCA = false;
newRow.MealsUS = false;
newRow.TotalCA = 0;
newRow.TotalUS = 0;
}
// ...Verifing if there is a comment or not
if (!originalRow.IsCommentsNull())
{
newRow.Comments = originalRow.Comments;
}
// ...Definition of project time state
if (!originalRow.IsProjectTimeStateNull())
{
newRow.ProjectTimeState = originalRow.ProjectTimeState;
}
else
{
newRow.ProjectTimeState = "For Approval";
}
// ...Definition of variables that will help in the calculation of the cost column at the report
decimal valCostUnit = 0.00M;
decimal valCostTowedUnit = 0.00M;
int amountProjectsTowedVerified = 0;
int amountFunctionTowedVerified = 0;
int amountProjectsUnitVerified = 0;
int amountFunctionUnitVerified = 0;
decimal? dailyRateTowed = 0M;
decimal? dailyRateUnit = 0M;
if (!originalRow.IsTowedUnitIDNull())
{
amountProjectsTowedVerified = verifGateway.TowedUnitSameDayUseSeveralProjects(originalRow.Date_, originalRow.TowedUnitID);
amountFunctionTowedVerified = verifGateway.TowedUnitSameDayUseSeveralWorkFunctions(originalRow.ProjectID, originalRow.Date_, originalRow.TowedUnitID);
dailyRateTowed = GetUnitDailyRate(originalRow.Date_, originalRow.Date_, originalRow.TowedUnitID, originalRow.Work_, originalRow.ProjectID, originalRow.CountryID);
}
if (!originalRow.IsUnitIDNull())
{
amountProjectsUnitVerified = verifGateway.UnitSameDayUseSeveralProjects(originalRow.Date_, originalRow.UnitID);
amountFunctionUnitVerified = verifGateway.UnitSameDayUseSeveralWorkFunctions(originalRow.ProjectID, originalRow.Date_, originalRow.UnitID);
dailyRateUnit = GetUnitDailyRate(originalRow.Date_, originalRow.Date_, originalRow.UnitID, originalRow.Work_, originalRow.ProjectID, originalRow.CountryID);
}
// ...If only a unit was used
if (!originalRow.IsUnitIDNull() && originalRow.IsTowedUnitIDNull())
{
valCostTowedUnit = 0.00M;
if (UnitAlreadyProcessedInProjectWork_Function_(originalRow.ProjectName, originalRow.Date_, originalRow.UnitID, originalRow.Unit, companyId, originalRow.Work_, originalRow.Function_))
{
valCostUnit = 0.00M;
}
else
{
decimal? dailyRate = null; if (GetUnitDailyRate(originalRow.Date_, originalRow.Date_, originalRow.UnitID, originalRow.Work_, originalRow.ProjectID, originalRow.CountryID).HasValue) dailyRate = GetUnitDailyRate(originalRow.Date_, originalRow.Date_, originalRow.UnitID, originalRow.Work_, originalRow.ProjectID, originalRow.CountryID).Value;
if (amountProjectsUnitVerified > 1)
{
if (dailyRate.HasValue)
{
valCostUnit = Decimal.Round(dailyRate.Value / amountProjectsUnitVerified, 2);
if (amountFunctionUnitVerified > 0)
{
valCostUnit = Decimal.Round(valCostUnit / amountFunctionUnitVerified, 2);
}
}
else
{
valCostUnit = 0.00M;
}
}
else
{
if (dailyRate.HasValue)
{
if (amountFunctionUnitVerified > 0)
{
valCostUnit = Decimal.Round(dailyRate.Value / amountFunctionUnitVerified, 2);
}
else
{
valCostUnit = dailyRate.Value;
}
}
else
{
valCostTowedUnit = 0.00M;
}
}
}
}
// ...If only a towed unit was used
if (!originalRow.IsTowedUnitIDNull() && originalRow.IsUnitIDNull())
{
valCostUnit = 0.00M;
if (TowedUnitAlreadyProcessedInProjectWork_Function_(originalRow.ProjectName, originalRow.Date_, originalRow.TowedUnitID, originalRow.Towed, companyId, originalRow.Work_, originalRow.Function_))
{
valCostTowedUnit = 0.00M;
}
else
{
if (amountProjectsTowedVerified > 1)
{
if (dailyRateTowed.HasValue)
{
valCostTowedUnit = Decimal.Round(dailyRateTowed.Value / amountProjectsTowedVerified, 2);
if (amountFunctionTowedVerified > 0)
{
valCostTowedUnit = Decimal.Round(valCostTowedUnit / amountFunctionTowedVerified, 2);
}
}
else
{
valCostTowedUnit = 0.00M;
}
}
else
{
if (dailyRateTowed.HasValue)
{
if (amountFunctionTowedVerified > 0)
{
valCostTowedUnit = Decimal.Round(dailyRateTowed.Value / amountFunctionTowedVerified, 2);
}
else
{
valCostTowedUnit = dailyRateTowed.Value;
}
}
else
{
valCostTowedUnit = 0.00M;
}
}
}
}
// ...If towed unit and a unit were used
if (!originalRow.IsTowedUnitIDNull() && !originalRow.IsUnitIDNull())
{
if (UnitAlreadyProcessedInProjectWork_Function_(originalRow.ProjectName, originalRow.Date_, originalRow.UnitID, originalRow.Unit, companyId, originalRow.Work_, originalRow.Function_))
{
valCostUnit = 0.00M;
}
else
{
if (amountProjectsUnitVerified > 1)
{
if (dailyRateUnit.HasValue)
{
valCostUnit = Decimal.Round(dailyRateUnit.Value / amountProjectsUnitVerified, 2);
if (amountFunctionUnitVerified > 0)
{
valCostUnit = Decimal.Round(valCostUnit / amountFunctionUnitVerified, 2);
}
}
else
{
valCostUnit = 0.00M;
}
}
else
{
if (dailyRateUnit.HasValue)
{
if (amountFunctionUnitVerified > 0)
{
valCostUnit = Decimal.Round(dailyRateUnit.Value / amountFunctionUnitVerified, 2);
}
else
{
valCostUnit = dailyRateUnit.Value;
}
}
else
{
valCostTowedUnit = 0.00M;
}
}
}
if (TowedUnitAlreadyProcessedInProjectWork_Function_(originalRow.ProjectName, originalRow.Date_, originalRow.TowedUnitID, originalRow.Towed, companyId, originalRow.Work_, originalRow.Function_))
{
valCostTowedUnit = 0.00M;
}
else
{
if (amountProjectsTowedVerified > 1)
{
if (dailyRateTowed.HasValue)
{
valCostTowedUnit = Decimal.Round(dailyRateTowed.Value / amountProjectsTowedVerified, 2);
if (amountFunctionTowedVerified > 0)
{
valCostTowedUnit = Decimal.Round(valCostTowedUnit / amountFunctionTowedVerified, 2);
}
}
else
{
valCostTowedUnit = 0.00M;
}
}
else
{
if (dailyRateTowed.HasValue)
{
if (amountFunctionTowedVerified > 0)
{
valCostTowedUnit = Decimal.Round(dailyRateTowed.Value / amountFunctionTowedVerified, 2);
}
else
{
valCostTowedUnit = dailyRateTowed.Value;
}
}
else
{
valCostTowedUnit = 0.00M;
}
}
}
}
// ...Summary of Unit and Towed cost
if (!originalRow.IsUnitIDNull())
{
if (!originalRow.IsTowedUnitIDNull())
{
newRow.EquipmentCost = valCostUnit + valCostTowedUnit;
}
else
{
newRow.EquipmentCost = valCostUnit;
}
}
else
{
if (!originalRow.IsTowedUnitIDNull())
{
newRow.EquipmentCost = valCostTowedUnit;
}
else
{
newRow.EquipmentCost = 0.00M;
}
}
((PrintProjectCostingTDS.PrintProjectCostingDataTable)Table).AddPrintProjectCostingRow(newRow);
}
}
/// <summary>
/// LoadByStartDateEndDateProjectTimeStateWork
/// </summary>
/// <para>Load Original to process data for Project Costing report with filters</para>
/// <param name="startDate">Start date filter for Project Costing report</param>
/// <param name="endDate">End date filter for Project Costing report</param>
/// <param name="projectTimeState">State filter for Project Costing report</param>
/// <param name="work">work</param>
/// <param name="companyId">companyId</param>
public void LoadByStartDateEndDateProjectTimeStateWork(DateTime startDate, DateTime endDate, string projectTimeState, string work, int companyId)
{
PrintProjectCostingGateway printProjectCostingGateway = new PrintProjectCostingGateway(Data);
printProjectCostingGateway.LoadByStartDateEndDateProjectTimeStateWork(startDate, endDate, projectTimeState, work);
this.ProcessDataForProject(companyId);
}
/// <summary>
/// LoadByCompaniesIdStartDateEndDateProjectTimeState
/// </summary>
/// <para>Load Original to process data for Project Costing report with filters</para>
/// <param name="companiesId">Company filter (client) for project Costing report</param>
/// <param name="startDate">Start date filter for Project Costing report</param>
/// <param name="endDate">End date filter for Project Costing report</param>
/// <param name="projectTimeState">State filter for Project Costing report</param>
/// <param name="companyId">companyId</param>
public void LoadByCompaniesIdStartDateEndDateProjectTimeState(int companiesId, DateTime startDate, DateTime endDate, string projectTimeState, int companyId)
{
PrintProjectCostingGateway printProjectCostingGateway = new PrintProjectCostingGateway(Data);
printProjectCostingGateway.LoadByCompaniesIdStartDateEndDateProjectTimeState(companiesId, startDate, endDate, projectTimeState);
this.ProcessDataForProject(companyId);
}
