public ActionResult Report(SelectDateViewModel model) { DatabaseControler dc = new DatabaseControler(); SelectDateViewModel selectModel = dc.GetSelectDateModelByCarId(model.CarId); selectModel.MonthId = model.MonthId; selectModel.YearId = model.YearId; if (!ModelState.IsValid) { return(View("SelectDate", selectModel)); } PdfController pc = new PdfController(); return(new FileStreamResult(pc.CreateDistanceReportByCarId(model.CarId, int.Parse(selectModel.Mounth.ToList()[model.MonthId].Value), int.Parse(selectModel.Year.ToList()[model.YearId].Value)), "application/pdf")); }
public ActionResult Report(string id) { DatabaseControler dc = new DatabaseControler(); var userName = User.Identity.Name; ApplicationUserManager userManager = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>(); var user = userManager.FindByName(userName); int Id = 0; if (!int.TryParse(id, out Id)) { return(RedirectToAction("Index", "Home")); } SelectDateViewModel sdvm = dc.GetSelectDateModelByCarId(Id); return(View("SelectDate", sdvm)); }
public SelectDateViewModel GetSelectDateModelByCarId(int carId) { List <Travel> list = context.Travel.Where(t => t.CarId == carId).ToList(); List <string> listYears = new List <string>(); List <string> listMounth = new List <string>(); List <DateViewModel> listYearsForModel = new List <DateViewModel>(); List <DateViewModel> listMounthForModel = new List <DateViewModel>(); int yearId = 1; int mounthId = 1; DateViewModel model = new DateViewModel(); model.Id = 0; model.Value = ""; listMounthForModel.Add(model); listYearsForModel.Add(model); foreach (Travel t in list) { if (!listMounth.Contains((t.TravelDate.Month).ToString())) { listMounth.Add((t.TravelDate.Month).ToString()); DateViewModel dvm = new DateViewModel(); dvm.Id = mounthId; dvm.Value = t.TravelDate.Month.ToString(); listMounthForModel.Add(dvm); mounthId++; } if (!listYears.Contains(t.TravelDate.Year.ToString())) { listYears.Add(t.TravelDate.Year.ToString()); DateViewModel dvm = new DateViewModel(); dvm.Id = yearId; dvm.Value = t.TravelDate.Year.ToString(); listYearsForModel.Add(dvm); yearId++; } } SelectDateViewModel retval = new SelectDateViewModel(); retval.CarId = carId; retval.Mounth = listMounthForModel; retval.Year = listYearsForModel; return(retval); }