public ActionResult Detail(Guid id, DateTime startDate, DateTime endDate)
{
FilterModelDetail filter = new FilterModelDetail(startDate, endDate, id);
ViewBag.licensePlate = RepoCar.FindByPk(id).license_plate;
return(View(filter));
}
public JsonResult BindingDetail(FilterModelDetail model)
{
if (ModelState.IsValid)
{
//kasmus
Business.Infrastructure.FilterInfo filters;
List <expense_item> expenseItems;
List <car_expense> carExpenses;
DateTime dtStart, dtEnd;
//algoritma
dtStart = new DateTime(model.StartDate.Year, model.StartDate.Month, model.StartDate.Day, 0, 0, 0);
dtEnd = new DateTime(model.EndDate.Year, model.EndDate.Month, model.EndDate.Day, 23, 59, 59);
//mengambil expense_item (pemasukan kendaraan)
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "expense.date", Operator = "gte", Value = dtStart.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense.date", Operator = "lte", Value = dtEnd.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "category", Operator = "eq", Value = ExpenseItemCategory.VEHICLE.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense.rent.id_car", Operator = "eq", Value = model.IdCar.ToString()
}
}
};
expenseItems = RepoExpense.FindAllItem(null, null, null, filters);
//mengambil carExpense (biaya kendaraan)
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "expense_date", Operator = "gte", Value = dtStart.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense_date", Operator = "lte", Value = dtEnd.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "id_car", Operator = "eq", Value = model.IdCar.ToString()
}
}
};
carExpenses = RepoCarExpense.FindAll(null, null, null, filters);
return(Json(new CarDetailReportPresentationStub().MapList(expenseItems, carExpenses), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
