public ActionResult SalesMonth(FormCollection collection) { // get the date in form collection try { DateTime date = DateTime.Parse(collection["datepicker"]); DateTime date2 = date.AddMonths(1); //get list with this time constraint IEnumerable <Database.Pass_Log> saleList = db.GetSaleReport(date, date2); List <SaleReportViewModel> list = new List <SaleReportViewModel>(); foreach (var sale in saleList) { SaleReportViewModel saleReport = new SaleReportViewModel(); var classPass = db.getClassPasse(sale.Pass_Id); var user = db.getUserById(sale.U_Id); saleReport.Pass_Log_Id = sale.Pass_Log_Id; saleReport.Pass_Id = sale.Pass_Id; saleReport.Pass_Name = classPass.Pass_Name; saleReport.U_Id = sale.U_Id; saleReport.U_First_Name = user.U_First_Name; saleReport.U_Last_Name = user.U_Last_Name; saleReport.Num_Classes = sale.Num_Classes.GetValueOrDefault(); saleReport.Purchase_Price = Convert.ToDouble(sale.Purchase_Price); saleReport.Date_Purchased = sale.Date_Purchased; list.Add(saleReport); TempData["saleList"] = list; } }catch (Exception e) { TempData["Message"] = e.ToString(); return(RedirectToAction("MessageView")); } // redirect view with list of passlog return(RedirectToAction("SaleList")); }