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