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)); } }