public string InsertOrder(Models.InsertSearch order)
{
string sql = @"INSERT INTO Sales.Orders
(CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipperID,Freight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry)
VALUES (@CustomerID,@EmployeeID,@OrderDate,@RequiredDate,@ShippedDate,@ShipperID,@Freight,@ShipName,@ShipAddress,@ShipCity,@ShipRegion,@ShipPostalCode,@ShipCountry)
Select SCOPE_IDENTITY()";
string sql2 = @"INSERT INTO Sales.OrderDetails
(OrderID,ProductID,UnitPrice,Qty)
VALUES (@OrderID,@ProductID,@UnitPrice,@Qty)";
string OrderID;
using (SqlConnection conn = new SqlConnection(this.GetconnectionStrings()))
{
conn.Open();
SqlCommand command = new SqlCommand(sql, conn);
SqlCommand command2 = new SqlCommand(sql2, conn);
command.Parameters.Add(new SqlParameter("@CustomerID", order.CustomerID));
command.Parameters.Add(new SqlParameter("@EmployeeID", order.EmployeeID));
command.Parameters.Add(new SqlParameter("@OrderDate", order.OrderDate));
command.Parameters.Add(new SqlParameter("@RequiredDate", order.RequiredDate));
command.Parameters.Add(new SqlParameter("@ShippedDate", order.ShippedDate));
command.Parameters.Add(new SqlParameter("@ShipperID", order.ShipperID));
command.Parameters.Add(new SqlParameter("@Freight", order.Freight));
command.Parameters.Add(new SqlParameter("@ShipName", order.ShipName));
command.Parameters.Add(new SqlParameter("@ShipAddress", order.ShipAddress));
command.Parameters.Add(new SqlParameter("@ShipCity", order.ShipCity));
command.Parameters.Add(new SqlParameter("@ShipRegion", order.ShipRegion));
command.Parameters.Add(new SqlParameter("@ShipPostalCode", order.ShipPostalCode));
command.Parameters.Add(new SqlParameter("@ShipCountry", order.ShipCountry));
OrderID = command.ExecuteScalar().ToString();
for (int i = 0; i < order.OrderDetails.Count; i++)
{
command2 = new SqlCommand(sql2, conn);
command2.Parameters.Add(new SqlParameter("@OrderID", OrderID));
command2.Parameters.Add(new SqlParameter("@ProductID", order.OrderDetails[i].ProductID));
command2.Parameters.Add(new SqlParameter("@UnitPrice", order.OrderDetails[i].UnitPrice));
command2.Parameters.Add(new SqlParameter("@Qty", order.OrderDetails[i].Qty));
command2.ExecuteNonQuery();
}
conn.Close();
}
return(OrderID);
}
public ActionResult InsertOrder(Models.InsertSearch order)
{
if (ModelState.IsValid)
{
try
{
CustomersService CustomersService = new CustomersService();
CustomersService.InsertOrder(order);
return(RedirectToAction("../Employees/Index"));
}
catch (Exception ex)
{
throw ex;
}
}
return(View(order));
}
public ActionResult UpdateIndex(Models.InsertSearch update)
{
if (ModelState.IsValid)
{
try
{
OrdersService OrdersService = new OrdersService();
OrdersService.DeleteOrderDetailByID(update.OrderID);
OrdersService.updateorder(update);
return(RedirectToAction("../Employees/Index"));
}
catch (Exception ex)
{
throw ex;
}
}
return(View(update));
}
