public List <ItemViewVM> GetItemView(ViewReportVM viewReport) { SqlConnection connection = new SqlConnection(connectionString); string query = @"SELECT * FROM Reports WHERE Id = " + viewReport.MemberId + " AND OrderDate = '" + viewReport.OrderDate.Date.ToString("d") + "';"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <ItemViewVM> itemList = new List <ItemViewVM>(); while (reader.Read()) { ItemViewVM item = new ItemViewVM(); item.ItemName = reader["Name"].ToString(); item.Quantity = (decimal)reader["Quantity"]; item.TotalPrice = (decimal)reader["Total"]; itemList.Add(item); } reader.Close(); connection.Close(); return(itemList); }
public ActionResult ViewReport(ViewReportVM viewReport) { decimal tot = 0; List <Member> members = _orderManager.GetAllMembers(); ViewBag.Members = new SelectList(members, "Id", "Code"); List <ItemViewVM> itemList = _orderManager.GetItemView(viewReport); foreach (var item in itemList) { tot += item.TotalPrice; } ViewBag.Items = itemList; ViewBag.Tot = tot; return(View()); }
public List <ItemViewVM> GetItemView(ViewReportVM viewReport) { return(_orderGateway.GetItemView(viewReport)); }