public string OrderInsert([FromQuery] InsertOrders Insertdata, [FromBody] InsertOrderDetails IOD)
{
for (int i = 0; i < IOD.ProductID.Count(); i++)
{
//required information
if (IOD.ProductID[i] == null)
{
return("Please input ProductId");
}
if (IOD.Quantity[i] == null)
{
return("Please input Quantity");
}
if (IOD.Discount[i] == null)
{
return("Please input Discount");
}
}
//Insert Orders
var Insert = new DataInsert();
var InsertOrder = Insert.InsertOrderData(Insertdata);
//Insert OrderDetails
var result = Insert.InsertOrderDetailData(IOD, InsertOrder);
return(result);
}
public int InsertOrderData(InsertOrders Insertdata)
{
var dynamicParams = new DynamicParameters();//←動態參數
SqlConnection conn = new SqlConnection("Data Source=howardorder.database.windows.net;Initial Catalog=OrderDatabase;Persist Security Info=True;User Id =howard;Password=Yihao1222");
conn.Open();
var queryOrderID = conn.Query <OrderDataVM>(
@"select max(OrderID) +1 as OrderID From Orders"
);
conn.Close();
dynamicParams.Add("OrderID", queryOrderID.First().OrderID);
dynamicParams.Add("CustomerID", Insertdata.CustomerID);
dynamicParams.Add("EmployeeID", Insertdata.EmployeeID);
dynamicParams.Add("OrderDate", Insertdata.OrderDate);
dynamicParams.Add("RequiredDate", Insertdata.RequiredDate);
dynamicParams.Add("ShippedDate", Insertdata.ShippedDate);
dynamicParams.Add("ShipVia", Insertdata.ShipVia);
dynamicParams.Add("Freight", Insertdata.Freight);
dynamicParams.Add("ShipName", Insertdata.ShipName);
dynamicParams.Add("ShipAddress", Insertdata.ShipAddress);
dynamicParams.Add("ShipCity", Insertdata.ShipCity);
dynamicParams.Add("ShipRegion", Insertdata.ShipRegion);
dynamicParams.Add("ShipPostalCode", Insertdata.ShipPostalCode);
dynamicParams.Add("ShipCountry", Insertdata.ShipCountry);
string SqlString = @"SET IDENTITY_INSERT Orders ON
insert into Orders
(OrderID ,CustomerID ,EmployeeID ,OrderDate ,RequiredDate ,ShippedDate ,ShipVia ,Freight ,ShipName
,ShipAddress ,ShipCity ,ShipRegion ,ShipPostalCode ,ShipCountry)
Values
(@OrderID ,@CustomerID ,@EmployeeID ,@OrderDate ,@RequiredDate ,@ShippedDate ,@ShipVia ,@Freight ,@ShipName
,@ShipAddress ,@ShipCity ,@ShipRegion ,@ShipPostalCode ,@ShipCountry)
SET IDENTITY_INSERT Orders Off";
var Insert = new SqlServices();
string result = Insert.SqlInsert(SqlString, dynamicParams);
return(queryOrderID.First().OrderID);
}
