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