public ActionResult Create()
{
IVehicleService vehicleServcie = new VehicleService();
IProjectService projectService = new ProjectService();
RunningchartModel model = new RunningchartModel();
model.BillDate = DateTime.Now;
model.Vehicles = ModelMapper.GetVehicleModelList(vehicleServcie.GetAllVehicles());
model.Lubricants = ModelMapper.GetLubricantModelList(vehicleServcie.GetAllLubricantTypes());
model.Projects = ModelMapper.GetProjectModelList(projectService.GetAllActiveProjects());
ViewBag.Mode = "create";
return View(model);
}
public ActionResult WorkDonePrint(DateTime startDate, DateTime endDate, int vehicleNo)
{
if (startDate.Equals(DateTime.MinValue))
throw new ArgumentNullException("startDate");
if (endDate.Equals(DateTime.MinValue))
throw new ArgumentNullException("endDate");
if (vehicleNo == 0)
throw new InvalidArgumentException("Vehicle No can not be 0", EngineExceptionErrorID.InvalidArgument);
IVehicleService vehicleService = new VehicleService();
var vehicle = vehicleService.GetVehicle(vehicleNo);
var compCode = string.IsNullOrWhiteSpace(vehicle.CompanyCode) || string.Equals(vehicle.CompanyCode.ToLower(), "no") ? "N/A" : vehicle.CompanyCode;
var measure = vehicle.IsVehicle ? " Km" : " Hrs";
var totalWorkDone = decimal.Zero;
var totalFuelUsed = decimal.Zero;
DataTable dataTable = GetWorkDoneReportTable(startDate, endDate, vehicleNo, measure, out totalWorkDone, out totalFuelUsed);
ReportClass reportClass = new ReportClass();
reportClass.FileName = Server.MapPath("~/Reports/WorkDoneReport.rpt");
reportClass.Load();
reportClass.SummaryInfo.ReportTitle = "Work Done Report – Vehicle/Machine";
reportClass.Database.Tables["WorkDoneReport"].SetDataSource(dataTable);
reportClass.SetParameterValue("StartDate", startDate.ToString("d"));
reportClass.SetParameterValue("EndDate", endDate.ToString("d"));
reportClass.SetParameterValue("VehicleNo", vehicle.VehicleNumber);
reportClass.SetParameterValue("CompanyCode", compCode);
reportClass.SetParameterValue("TotalWorkDone", totalWorkDone.ToString("C").Replace("$", string.Empty) + " " + measure);
reportClass.SetParameterValue("TotalFuelUsed", totalFuelUsed.ToString("C").Replace("$", string.Empty) + " L");
reportClass.SetParameterValue("WorkDoneHeading", "Work Done (" + measure.Trim() + ")");
Stream compStream = reportClass.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return File(compStream, "application/pdf");
}
public ActionResult WorkDone(DateTime startDate, DateTime endDate, int vehicleNo, int companyCode)
{
IVehicleService vehicleService = new VehicleService();
var vehicle = vehicleService.GetVehicle(vehicleNo);
var compCode = string.IsNullOrWhiteSpace(vehicle.CompanyCode) || string.Equals(vehicle.CompanyCode.ToLower(), "no") ? "N/A" : vehicle.CompanyCode;
var report = reportService.GetWorkDoneReport(startDate, endDate, vehicleNo);
var model = ModelMapper.GetWorkDoneReportModelList(report);
ViewBag.StartDate = startDate;
ViewBag.EndDate = endDate;
ViewBag.VehicleNumber = vehicle.VehicleNumber;
ViewBag.CompanyCode = compCode;
ViewBag.IsVehicle = vehicle.IsVehicle;
ViewBag.VehicleNo = vehicle.Id;
return View(model);
}
public ActionResult WorkDone()
{
IVehicleService vehicleService = new VehicleService();
ViewBag.Vehicles = ModelMapper.GetVehicleModelList(vehicleService.GetAllVehicles());
return View();
}
public ActionResult HireBillPrivatePrint(DateTime startDate, DateTime endDate, int vehicleNo)
{
if (startDate.Equals(DateTime.MinValue))
throw new ArgumentNullException("startDate");
if (endDate.Equals(DateTime.MinValue))
throw new ArgumentNullException("endDate");
if (vehicleNo == 0)
throw new InvalidArgumentException("Vehicle No can not be 0", EngineExceptionErrorID.InvalidArgument);
IVehicleService vehicleService = new VehicleService();
var vehicle = vehicleService.GetVehicle(vehicleNo);
DataTable dataTable = GetHireBillPrivateReportTable(startDate, endDate, vehicleNo, vehicle.IsVehicle);
ReportClass reportClass = new ReportClass();
reportClass.FileName = Server.MapPath("~/Reports/HireBillPrivateReport.rpt");
reportClass.Load();
reportClass.SummaryInfo.ReportTitle = "Hire Bill (Private) Report";
reportClass.Database.Tables["HireBillPrivateReport"].SetDataSource(dataTable);
reportClass.SetParameterValue("StartDateParameter", startDate.ToString("d"));
reportClass.SetParameterValue("EndDateParameter", endDate.ToString("d"));
reportClass.SetParameterValue("VehicleNumberParameter", vehicle.VehicleNumber);
reportClass.SetParameterValue("OwnerNameParameter", vehicle.OwnerName);
string measure = vehicle.IsVehicle ? " Rs/Km" : " Rs/Hr";
reportClass.SetParameterValue("HireRateParameter", vehicle.HireRate.ConvertToDecimalString() + measure);
Stream compStream = reportClass.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return File(compStream, "application/pdf");
}
public ActionResult HireBillPrivate(DateTime startDate, DateTime endDate, int vehicleNo)
{
IVehicleService vehicleService = new VehicleService();
var vehicle = vehicleService.GetVehicle(vehicleNo);
var reporthp = reportService.GetHireBillPrivateReport(startDate, endDate, vehicleNo);
var modelhp = ModelMapper.GetHireBillPrivateReportModelList(reporthp);
ViewBag.VehicleNo = vehicle.Id;
ViewBag.IsVehicle = vehicle.IsVehicle;
ViewBag.OwnerName = vehicle.OwnerName;
ViewBag.HireRate = vehicle.HireRate.ConvertToDecimalString(); //.ToString("N");
ViewBag.StartDate = startDate;
ViewBag.EndDate = endDate;
ViewBag.VehicleNumber = vehicle.VehicleNumber;
return View(modelhp);
}
public ActionResult HireBillPrivate()
{
IVehicleService vehicleService = new VehicleService();
ViewBag.Vehicles = ModelMapper.GetVehicleModelList(vehicleService.GetAllHiredVehicles());
return View();
}
public ActionResult Create(RunningchartModel model)
{
try
{
Runningchart runningChart = ModelMapper.GetRunningchartFromRunningchartModel(model);
runningChart.EnteredBy = (Session[SessionKeys.UserInfo] as UserModel).Id; // Set DEO
int chartId = runningchartService.AddRunningchart(runningChart);
return RedirectToAction("index", new { lastChartId = chartId });
}
catch
{
IVehicleService vehicleServcie = new VehicleService();
IProjectService projectService = new ProjectService();
model.RunningchartId = runningchartService.GetNextRunningchartId();
model.Vehicles = ModelMapper.GetVehicleModelList(vehicleServcie.GetAllVehicles());
model.Lubricants = ModelMapper.GetLubricantModelList(vehicleServcie.GetAllLubricantTypes());
model.Projects = ModelMapper.GetProjectModelList(projectService.GetAllActiveProjects());
return View(model);
}
}
private RunningchartModel GetRunningchartModel(int runningChartId)
{
IVehicleService vehicleServcie = new VehicleService();
IProjectService projectService = new ProjectService();
IPumpstationService pumpstationService = new PumpstationService();
var chart = runningchartService.GetRunningChart(runningChartId);
var model = ModelMapper.GetRunningchartModel(chart);
model.Vehicles = ModelMapper.GetVehicleModelList(vehicleServcie.GetAllVehicles());
model.Lubricants = ModelMapper.GetLubricantModelList(vehicleServcie.GetAllLubricantTypes());
model.Projects = ModelMapper.GetProjectModelList(projectService.GetAllActiveProjects());
model.Pumpstations = ModelMapper.GetPumpStationModelList(pumpstationService.GetAllPumpstations());
model.VehicleRentalTypes = new List<VehicleRentalTypeModel>()
{
new VehicleRentalTypeModel() { Id = (int)RentalType.Company, RentalTypeName = StringEnum.GetEnumStringValue(RentalType.Company) },
new VehicleRentalTypeModel() { Id = (int)RentalType.CompanyHired, RentalTypeName = StringEnum.GetEnumStringValue(RentalType.CompanyHired) },
new VehicleRentalTypeModel() { Id = (int)RentalType.Hired, RentalTypeName = StringEnum.GetEnumStringValue(RentalType.Hired) }
}; // Not worth to do a DB call since this is very static
return model;
}
public ActionResult Print(int id)
{
IVehicleService vehicleServcie = new VehicleService();
IProjectService projectService = new ProjectService();
IPumpstationService pumpstationService = new PumpstationService();
var pumpstations = pumpstationService.GetAllPumpstations();
var projects = projectService.GetAllActiveProjects();
var lubricants = vehicleServcie.GetAllLubricantTypes();
var vehicles = vehicleServcie.GetAllVehicles();
var chart = runningchartService.GetRunningChart(id);
dsRunningchart ds = new dsRunningchart();
DataTable runningchartTable = ds.Tables["Runningchart"].Clone();
DataTable runningchartDetailsTable = ds.Tables["RunningchartDetails"].Clone();
DataTable runningchartPumpstationsTable = ds.Tables["RunningchartPumpstation"].Clone();
DataTable runningchartLubricantsTable = ds.Tables["RunningchartLubricant"].Clone();
PopulateRunningchartTable(chart, runningchartTable, vehicles);
PopulateRunningchartDetailsTable(chart.RunningchartDetails, runningchartDetailsTable, projects);
PopulateRunningchartPumpstationTable(chart.RunningchartPumpstation, runningchartPumpstationsTable, pumpstations);
PopulateRunningchartLubricantTable(chart.RunningchartLubricants, runningchartLubricantsTable, pumpstations, lubricants);
ReportClass reportClass = new ReportClass();
reportClass.FileName = Server.MapPath("~/Reports/Runningchart.rpt");
reportClass.Load();
reportClass.SummaryInfo.ReportTitle = "Running Chart";
reportClass.Database.Tables["Runningchart"].SetDataSource(runningchartTable);
reportClass.Database.Tables["RunningchartDetails"].SetDataSource(runningchartDetailsTable);
reportClass.Database.Tables["RunningchartPumpstation"].SetDataSource(runningchartPumpstationsTable);
reportClass.Database.Tables["RunningchartLubricant"].SetDataSource(runningchartLubricantsTable);
Stream compStream = reportClass.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return File(compStream, "application/pdf");
}
public ActionResult PoulateLubricantItems(bool isAddingNewItem)
{
IVehicleService vehicleServcie = new VehicleService();
RunningchartModel model = new RunningchartModel();
List<ChartLubricantItemModel> existingLubricantItems = new List<ChartLubricantItemModel>();
UpdateModel<List<ChartLubricantItemModel>>(existingLubricantItems);
IPumpstationService pumpstationService = new PumpstationService();
model.Pumpstations = ModelMapper.GetPumpStationModelList(pumpstationService.GetAllPumpstations());
model.Lubricants = ModelMapper.GetLubricantModelList(vehicleServcie.GetAllLubricantTypes());
model.SelectedLubricants = new List<ChartLubricantItemModel>();
// Add existing chart items
foreach (var item in existingLubricantItems)
{
if (!item.IsRemoving)
{
model.SelectedLubricants.Add(item);
}
}
// Add new chart item
if (isAddingNewItem)
{
model.SelectedLubricants.Add(new ChartLubricantItemModel()
{
SelectedPumpstationId = 0,
SelectedLubricantTypeId = 0,
PumpAmount = 0
});
}
return PartialView("_Lubricants", model);
}
public ActionResult Index(int? lastChartId)
{
IVehicleService vehicleServcie = new VehicleService();
List<Runningchart> runningCharts = new List<Runningchart>();
if (Session[SessionKeys.UserInfo] == null)
{
return RedirectToAction("index", "home");
}
var user = Session[SessionKeys.UserInfo] as UserModel;
if (user.Role == UserRole.Admin)
{
runningCharts = runningchartService.GetNoneApprovedRunningCharts();
}
else if (user.Role == UserRole.RunningChartInspector)
{
//TODO : Limit running charts by a criteria like inspector projects
runningCharts = runningchartService.GetNoneApprovedRunningCharts();
}
else if (user.Role == UserRole.RunningChartOperator)
{
runningCharts = runningchartService.GetOperatorNoneApprovedRunningcharts(user.Id);
}
if (lastChartId.HasValue)
{
ViewBag.LastChartId = lastChartId.Value;
}
var model = ModelMapper.GetRunningchartModelList(runningCharts);
ViewBag.Vehicles = ModelMapper.GetVehicleModelList(vehicleServcie.GetAllVehicles());
return View(model);
}
public ActionResult History()
{
IVehicleService vehicleServcie = new VehicleService();
List<Runningchart> runningCharts = new List<Runningchart>();
var user = Session[SessionKeys.UserInfo] as UserModel;
if (user.Role == UserRole.Admin)
{
runningCharts = runningchartService.GetApprovedRunningCharts();
}
else if (user.Role == UserRole.RunningChartInspector)
{
//TODO : Limit running charts by a criteria like inspector projects
runningCharts = runningchartService.GetApprovedRunningCharts();
}
else if (user.Role == UserRole.RunningChartOperator)
{
runningCharts = runningchartService.GetOperatorApprovedRunningcharts(user.Id);
}
var model = ModelMapper.GetRunningchartModelList(runningCharts);
ViewBag.Vehicles = ModelMapper.GetVehicleModelList(vehicleServcie.GetAllVehicles());
return View(model);
}
