public HireBillPrivateReport GetHireBillPrivateReport(DateTime startDate, DateTime endDate, int vehicleId)
        {
            DataSet pumpStationDataSet;
            DataSet lubricantsDataSet;
            DataSet detailsDataSet = reportDataProvider.GetHireBillPrivateReport(startDate, endDate, vehicleId,
                out pumpStationDataSet, out lubricantsDataSet);

            var detailList = ConversionHelper.ConvertToList<HireBillPrivateReportDetails>(detailsDataSet);
            var lubricantList = ConversionHelper.ConvertToList<HireBillPrivateReportLubricant>(lubricantsDataSet);
            var pumpStationList = ConversionHelper.ConvertToList<HireBillPrivateReportPumpstation>(pumpStationDataSet);

            HireBillPrivateReport reportData = new HireBillPrivateReport()
            {
                HireBillPrivateReportDetails = detailList,
                HireBillPrivateReportLubricants = lubricantList,
                HireBillPrivateReportPumpstations = pumpStationList
            };

            return reportData;
        }
        public static HireBillPrivateReportModel GetHireBillPrivateReportModelList(HireBillPrivateReport report)
        {
            HireBillPrivateReportModel model = new HireBillPrivateReportModel()
            {
                HireBillPrivateReportDetails = new List<HireBillPrivateReportDetailsModel>(),
                HireBillPrivateReportFuel = new List<HireBillPrivateReportPumpstationModel>(),
                HireBillPrivateReportLubricants = new List<HireBillPrivateReportLubricantModel>()
            };

            foreach (var item in report.HireBillPrivateReportDetails)
            {
                model.HireBillPrivateReportDetails.Add(new HireBillPrivateReportDetailsModel()
                {
                    RunningchartId = item.Id,
                    BillDate = item.BillDate,
                    ProjectLocation = item.ProjectLocation,
                    FuelUsageOfDay = item.FuelUsageOfDay,
                    KmHrDone = item.KmHrDone,
                    HireAmount = item.HireAmount,
                    VehicleRate = item.VehicleRate
                });
            }

            foreach (var item in report.HireBillPrivateReportPumpstations)
            {
                model.HireBillPrivateReportFuel.Add(new HireBillPrivateReportPumpstationModel()
                {
                    Id = item.Id,
                    RunningchartId = item.RunningchartId,
                    BillDate = item.BillDate,
                    VehicleId = item.VehicleId,
                    Amount = item.Amount,
                    FuelRate = item.FuelRate,
                    PumpstationId = item.PumpstationId,
                    PumpstationName = item.PumpstationName
                });
            }

            foreach (var item in report.HireBillPrivateReportLubricants)
            {
                model.HireBillPrivateReportLubricants.Add(new HireBillPrivateReportLubricantModel()
                {
                    Id = item.Id,
                    RunningchartId = item.RunningchartId,
                    BillDate = item.BillDate,
                    VehicleId = item.VehicleId,
                    Amount = item.Amount,
                    LubricantTypeId = item.LubricantTypeId,
                    LubricantType = item.LubricantType,
                    LubricantRate = item.LubricantRate,
                    PumpstationId = item.PumpstationId,
                    PumpstationName = item.PumpstationName
                });
            }

            return model;
        }