public static Runningchart GetRunningchartFromRunningchartModel(RunningchartModel model)
{
Runningchart runningChart = new Runningchart()
{
BillNumber = model.BillNumber,
BillDate = model.BillDate,
DriverName = model.DriverName,
VehicleId = model.SelectedVehicleId,
//VehicleRate = model.vh
FuelLeftBegning = model.FuelLeftBegningOfDay,
FuelLeftEnd = model.FuelLeftEndOfDay,
FuelUsageOfDay = model.FuelUsageOfDay,
DailyNote = model.DailyNote,
IsApproved = model.IsApproved,
ApprovedBy = model.ApprovedBy,
EnteredBy = model.EnteredBy,
RunningchartDetails = new List<RunningchartDetails>(),
RunningchartPumpstation = new List<RunningchartPumpstation>(),
RunningchartLubricants = new List<RunningchartLubricant>()
};
var startTimePart = Convert.ToDateTime(model.DayStartime);
var endTimePart = Convert.ToDateTime(model.DayEndTime);
DateTime startTime = new DateTime(model.BillDate.Year, model.BillDate.Month, model.BillDate.Day,
startTimePart.Hour, startTimePart.Minute, startTimePart.Second);
DateTime endTime = new DateTime(model.BillDate.Year, model.BillDate.Month, model.BillDate.Day,
endTimePart.Hour, endTimePart.Minute, endTimePart.Second);
runningChart.DayStartime = startTime;
runningChart.DayEndTime = endTime;
foreach (var item in model.SelectedChartItems)
{
var startProjTimePart = Convert.ToDateTime(item.StartTime);
var endProjTimePart = Convert.ToDateTime(item.EndTime);
DateTime startProjTime = new DateTime(model.BillDate.Year, model.BillDate.Month, model.BillDate.Day,
startTimePart.Hour, startTimePart.Minute, startTimePart.Second);
DateTime endProjTime = new DateTime(model.BillDate.Year, model.BillDate.Month, model.BillDate.Day,
endTimePart.Hour, endTimePart.Minute, endTimePart.Second);
runningChart.RunningchartDetails.Add(new RunningchartDetails()
{
StartTime = startProjTime,
EndTime = endProjTime,
TimeDifference = item.TimeDifference,
StartMeter = item.StartMeter,
EndMeter = item.EndMeter,
MeterDifference = item.MeterDifference,
IdleHours = item.IdleHours,
ProjectId = item.SelectedProjectId,
ProjectManagerName = item.SelectedProjectManager,
RentalTypeId = item.SelectedRentalTypeId
});
}
if (model.SelectedPumpstations != null && model.SelectedPumpstations.Count > 0)
{
foreach (var item in model.SelectedPumpstations)
{
if (item.SelectedPumpstationId > 0 && item.PumpAmount > 0)
{
runningChart.RunningchartPumpstation.Add(new RunningchartPumpstation()
{
PumpstationId = item.SelectedPumpstationId,
Amount = item.PumpAmount
});
}
}
}
if (model.SelectedLubricants != null && model.SelectedLubricants.Count > 0)
{
foreach (var item in model.SelectedLubricants)
{
if (item.SelectedPumpstationId > 0 && item.SelectedLubricantTypeId > 0 && item.PumpAmount > 0)
{
runningChart.RunningchartLubricants.Add(new RunningchartLubricant()
{
PumpstationId = item.SelectedPumpstationId,
LubricantTypeId = item.SelectedLubricantTypeId,
Amount = item.PumpAmount
});
}
}
}
return runningChart;
}
public static RunningchartModel GetRunningchartModel(Runningchart runningChart)
{
RunningchartModel model = new RunningchartModel()
{
RunningchartId = runningChart.Id,
BillNumber = runningChart.BillNumber,
BillDate = runningChart.BillDate,
DriverName = runningChart.DriverName,
SelectedVehicleId = runningChart.VehicleId,
//SelectedVehicleNo = c.VehicleNumber, //TODO: Remove
FuelLeftBegningOfDay = runningChart.FuelLeftBegning,
FuelLeftEndOfDay = runningChart.FuelLeftEnd,
FuelUsageOfDay = runningChart.FuelUsageOfDay,
DailyNote = runningChart.DailyNote,
DayStartime = runningChart.DayStartime,
DayEndTime = runningChart.DayEndTime,
IsApproved = runningChart.IsApproved,
ApprovedBy = runningChart.ApprovedBy,
EnteredBy = runningChart.EnteredBy,
SelectedChartItems = GetChartItemModelList(runningChart.RunningchartDetails),
SelectedPumpstations = GetChartPumpstationItemModelList(runningChart.RunningchartPumpstation),
SelectedLubricants = GetChartLubricantItemModelList(runningChart.RunningchartLubricants),
};
return model;
}
private void PopulateRunningchartTable(Runningchart chart, DataTable runningchartTable, List<Vehicle> vehicles)
{
DataRow row = runningchartTable.NewRow();
row["RunningchartId"] = chart.Id;
row["BillNumber"] = chart.BillNumber;
row["BillDate"] = chart.BillDate.ToString("d");
row["DriverName"] = chart.DriverName;
row["VehicleName"] = vehicles.Single(x => x.Id == chart.VehicleId).VehicleNumber;
row["VehicleRate"] = chart.VehicleRate.ConvertToDecimalString();
row["VehicleHireRate"] = chart.VehicleHireRate.ConvertToDecimalString();
row["FuelRate"] = chart.FuelRate.ConvertToDecimalString();
row["FuelLeftBegning"] = chart.FuelLeftBegning.ConvertToDecimalString();
row["FuelLeftEnd"] = chart.FuelLeftEnd.ConvertToDecimalString();
row["FuelUsageOfDay"] = chart.FuelUsageOfDay.ConvertToDecimalString();
row["DailyNote"] = chart.DailyNote;
row["DayStartime"] = chart.DayStartime.ToString("d");
row["DayEndTime"] = chart.DayEndTime.ToString("d");
row["EnteredBy"] = chart.EnteredBy;
row["IsApproved"] = chart.IsApproved;
row["ApprovedBy"] = chart.ApprovedBy;
row["ApprovedDate"] = chart.ApprovedDate.ToString("d");
runningchartTable.Rows.Add(row);
}
