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