public ActionResult GetOrder(int orderID)
{
var repo = new NorthwindsRepo();
Order order = new Order();
order = repo.GetByIdStoredProcedure(orderID);
return View(order);
}
public ActionResult GetOrder()
{
int orderID = int.Parse(Request.Form["orderID"]);
var repo = new NorthwindsRepo();
Order order = new Order();
order = repo.GetByIdStoredProcedure(orderID);
return View(order);
}
public Order GetByIdStoredProcedure(int orderId)
{
Order order = new Order();
using (var cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "OrderInfoByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@OrderID", orderId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (order.OrderID == null)
{
order.OrderID = (int)(dr["OrderID"]);
order.CustomerID = dr["CustomerID"].ToString();
order.CompanyName = dr["CompanyName"].ToString();
order.OrderDate = (DateTime)(dr["OrderDate"]);
}
order.Products.Add(PopulateProductsFromDataReader(dr));
}
order.Total = order.Products.Sum(p => p.ProdTotalCost);
}
}
return order;
}