/// <summary> /// Fills data with rows loaded from PrintHoursForProjectsGateway /// </summary> /// <param name="companyId">companyId</param> public void FillData(int companyId) { // Fill rows from original data PrintHoursForProjectOriginalGateway originalGateway = new PrintHoursForProjectOriginalGateway(Data); foreach (PrintHoursForProjectTDS.OriginalRow originalRow in (PrintHoursForProjectTDS.OriginalDataTable)originalGateway.Table) { PrintHoursForProjectTDS.PrintHoursForProjectRow newRow = ((PrintHoursForProjectTDS.PrintHoursForProjectDataTable)Table).NewPrintHoursForProjectRow(); 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.Type = originalRow.Type; newRow.Date_ = originalRow.Date_; if (originalRow.CountryID == 1) { newRow.TimeCA = originalRow.ProjectTime; newRow.TimeUS = 0; } else { newRow.TimeCA = 0; newRow.TimeUS = originalRow.ProjectTime; } if ((originalRow.WorkingDetails == "Sick Day") || (originalRow.WorkingDetails == "Holiday") || (originalRow.WorkingDetails == "Vacation / Other")) { newRow.WorkingDetails = originalRow.WorkingDetails; } else { newRow.WorkingDetails = ""; } 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; } if (!originalRow.IsCommentsNull()) { newRow.Comments = originalRow.Comments; } if (!originalRow.IsUnitIDNull()) { UnitInformationUnitDetailsGateway unitInformationUnitDetailsGatewayForUnit = new UnitInformationUnitDetailsGateway(); unitInformationUnitDetailsGatewayForUnit.LoadAllByUnitId(originalRow.UnitID, companyId); newRow.Unit = unitInformationUnitDetailsGatewayForUnit.GetUnitCode(originalRow.UnitID); } if (!originalRow.IsProjectTimeStateNull()) { newRow.ProjectTimeState = originalRow.ProjectTimeState; } else { newRow.ProjectTimeState = "New"; } if (!originalRow.IsTowedUnitIDNull()) { UnitInformationUnitDetailsGateway unitInformationUnitDetailsGatewayForTowedUnit = new UnitInformationUnitDetailsGateway(); unitInformationUnitDetailsGatewayForTowedUnit.LoadAllByUnitId(originalRow.TowedUnitID, companyId); newRow.Towed = unitInformationUnitDetailsGatewayForTowedUnit.GetUnitCode(originalRow.TowedUnitID); } ((PrintHoursForProjectTDS.PrintHoursForProjectDataTable)Table).AddPrintHoursForProjectRow(newRow); } }
/// <summary> /// Load project times for Print Hours For Project report with filters /// </summary> /// <param name="companiesId">Companies filter (client) for project times</param> /// <param name="startDate">Start date filter for project times</param> /// <param name="endDate">End date filter for project times</param> /// <param name="projectTimeState">State filter for project times</param> /// <returns>Dataset with original data table loaded</returns> public void LoadByCompaniesIdStartDateEndDateProjectTimeState(int companiesId, DateTime startDate, DateTime endDate, string projectTimeState, int companyId) { PrintHoursForProjectOriginalGateway printHoursForProjectOriginalGateway = new PrintHoursForProjectOriginalGateway(Data); printHoursForProjectOriginalGateway.LoadByCompaniesIdStartDateEndDateProjectTimeState(companiesId, startDate, endDate, projectTimeState); this.FillData(companyId); }
/// <summary> /// Load project times for Print Hours For Project report with filters /// </summary> /// <param name="startDate">Start date filter for project times</param> /// <param name="endDate">End date filter for project times</param> /// <param name="projectTimeState">State filter for project times</param> /// <returns>Dataset with original data table loaded</returns> /// <param name="teamMemberType">TeamMemberType</param> /// <param name="companyId">companyId</param> public void LoadByStartDateEndDateProjectTimeStateTeamMemberType(DateTime startDate, DateTime endDate, string projectTimeState, string teamMemberType, int companyId) { PrintHoursForProjectOriginalGateway printHoursForProjectOriginalGateway = new PrintHoursForProjectOriginalGateway(Data); printHoursForProjectOriginalGateway.LoadByStartDateEndDateProjectTimeStateTeamMemberType(startDate, endDate, projectTimeState, teamMemberType); this.FillData(companyId); }
// //////////////////////////////////////////////////////////////////////// // METHODS - DATASET // /// <summary> /// Load project times for Print Hours For Project report without filters /// </summary> /// <param name="companyId">companyId</param> public void Load(int companyId) { PrintHoursForProjectOriginalGateway printHoursForProjectOriginalGateway = new PrintHoursForProjectOriginalGateway(Data); printHoursForProjectOriginalGateway.Load(); this.FillData(companyId); }