public ActionResult AddNewOrder(NewOrderModel model)
{
Customer customer;
int id = (int) Session["EmployeeId"];
using (NorthwindConnection db = new NorthwindConnection())
{
customer = db.Customers.SingleOrDefault(x => x.CustomerID == model.Order.CustomerID);
db.AddOrderTemporary(customer.CustomerID, id, model.Order.OrderDate, model.Order.RequiredDate,
model.Order.ShippedDate, model.Order.ShipVia, customer.CompanyName);
db.SaveChanges();
}
return RedirectToAction("Index", "Home");
}
public ActionResult AddNewOrder()
{
int employeeId = (int) Session["EmployeeId"];
List<Customer> customers;
List<Customer> customersForEmployee = new List<Customer>();
List<Shipper> shippers;
using (NorthwindConnection db = new NorthwindConnection())
{
shippers = db.Shippers.ToList();
customers = db.Customers.ToList();
var orders = db.Orders.Where(x=>x.EmployeeID == employeeId).ToList().GroupBy(x=>x.CustomerID);
foreach (IGrouping<string, Order> grouping in orders)
{
Customer customer = db.Customers.SingleOrDefault(x => x.CustomerID == grouping.Key);
customersForEmployee.Add(customer);
}
}
NewOrderModel model = new NewOrderModel();
model.CustomerNames = customers.Select(x => new SelectListItem()
{
Value = x.CustomerID,
Text = x.CompanyName
});
model.CustomerNamesForEmployee = customersForEmployee.Select(x => new SelectListItem()
{
Value = x.CustomerID,
Text = x.CompanyName
});
model.Shippers = shippers.Select(x => new SelectListItem()
{
Value = x.ShipperID.ToString(),
Text = x.CompanyName
});
return View(model);
}
