public ActionResult CreateOrder() { Order order = new Order(); ViewBag.CustomerId = new SelectList(CustomerDataBase.Customers, "CustomerId", "Name"); ViewBag.ProductId = new SelectList(ProductDataBase.Products, "ProductId", "Name"); return View(order); }
public static void EditOrder(Order order,int orderId) { SQLQueryCommand(String.Format("update [Order] set CustomerId = {0},ProductId = {1},Amount={2},TotalPrice={3} where OrderId = {4}",order.CustomerId,order.ProductId,order.Amount,order.TotalPrice,orderId)); }
public static Order CreateOrder(Order order) { SQLQueryCommand(String.Format("insert into [ShopDb].[dbo].[Order](CustomerId,ProductId,Amount,TotalPrice) values ('{0}','{1}','{2}','{3}')", order.CustomerId, order.ProductId,order.Amount,order.TotalPrice)); return order; }
public static Order SelectOrderForEdit(int OrderId) { SqlDataReader reader = SQLSelectQueryCommand(String.Format("select OrderId, [Order].CustomerId,[Order].ProductId, Customer.Name AS 'Customer Name', SurName AS 'Customer Surname', Product.Name AS 'Product Name', Price, Amount,TotalPrice from [Order] INNER JOIN Customer ON [Order].CustomerId = Customer.CustomerId INNER JOIN Product ON [Order].ProductId = Product.ProductId where OrderId = {0}", OrderId)); Order order = new Order(); while (reader.Read()) { order = new Order(); order.OrderId = (int)reader[0]; order.CustomerId = (int)reader[1]; order.ProductId = (int)reader[2]; order.CustomerName = (string)reader[3]; order.CustomerSurName = (string)reader[4]; order.ProductName = (string)reader[5]; order.ProductPrice = (decimal)reader[6]; order.Amount = (int)reader[7]; order.TotalPrice = (decimal)reader[8]; } connection.Close(); return order; }
public static List<Order> SelectAllOrders(List<Order> orders) { SqlDataReader reader = SQLSelectQueryCommand("select OrderId, [Order].CustomerId,[Order].ProductId, Customer.Name AS 'Customer Name', SurName AS 'Customer Surname', Product.Name AS 'Product Name', Price, Amount,TotalPrice from [Order] INNER JOIN Customer ON [Order].CustomerId = Customer.CustomerId INNER JOIN Product ON [Order].ProductId = Product.ProductId"); Order order; orders = new List<Order>(); while (reader.Read()) { order = new Order(); order.OrderId = (int)reader[0]; order.CustomerId = (int)reader[1]; order.ProductId = (int)reader[2]; order.CustomerName = (string)reader[3]; order.CustomerSurName = (string)reader[4]; order.ProductName = (string)reader[5]; order.ProductPrice = (decimal)reader[6]; order.Amount = (int)reader[7]; order.TotalPrice = (decimal)reader[8]; orders.Add(order); } reader.Close(); connection.Close(); return orders; }
public ActionResult CreateOrder(Order incomingOrder) { return View("SuccesOrderCreation", DataBase.CreateOrder(incomingOrder)); }
public ActionResult Edit(Order incomingOrder) { DataBase.EditOrder(incomingOrder,Convert.ToInt32(TempData["OrderId"])); return View("SuccessEdit"); }