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 AddOrEditItem(int id = 0) { ViewBag.Locations = UoW.Locations.GetAll(); ViewBag.GroupID = new SelectList(UoW.Groups.GetAll(), "GpID", "Name"); ViewBag.Products = UoW.Products.GetAll(); ViewBag.Unit = new SelectList(UoW.Units.GetAll(), "Notation", "Notation"); // InventoryItem item = new InventoryItem(); ItemViewVM itemVM = new ItemViewVM(); // itemVM.Locations = UoW.Locations.GetAll(); itemVM.Item = new InventoryItem(); itemVM.Products = UoW.Products.GetAll(); if (itemVM.Item.ItemID != 0) { itemVM.Item = UoW.Stocks.Get(id); } return(View(itemVM)); }