public void Post(ManufacturingOrderPostDto manufacturingOrderPostDto)
{
var dateTable = new DataTable();
dateTable.Columns.Add(new DataColumn("sweet_id", typeof(int)));
dateTable.Columns.Add(new DataColumn("count", typeof(int)));
foreach (var orderItem in manufacturingOrderPostDto.ManufacturingOrderItems)
{
dateTable.Rows.Add(orderItem.SweetId, orderItem.Count);
}
var parameters = new[]
{
new SqlParameter
{
SqlDbType = SqlDbType.Structured,
Direction = ParameterDirection.Input,
ParameterName = "ManufacturingOrderItems",
TypeName = "[dbo].[ManufacturingOrderList]",
Value = dateTable
},
new SqlParameter
{
SqlDbType = SqlDbType.Date,
Direction = ParameterDirection.Input,
ParameterName = "DeadLineDate",
Value = manufacturingOrderPostDto.DeadLineDate
},
new SqlParameter
{
SqlDbType = SqlDbType.BigInt,
Direction = ParameterDirection.Input,
ParameterName = "FactoryUnitId",
Value = manufacturingOrderPostDto.FactoryUnitId
},
new SqlParameter
{
SqlDbType = SqlDbType.BigInt,
Direction = ParameterDirection.Input,
ParameterName = "StatusId",
Value = manufacturingOrderPostDto.StatusId
}
};
_context.Database.ExecuteSqlCommand(
"dbo.SaveManufacturingOrder @DeadLineDate, @FactoryUnitId, @StatusId, @ManufacturingOrderItems",
parameters);
_context.SaveChanges();
}
public void Post([FromBody] ManufacturingOrderPostDto manufacturingOrderPostDto)
{
_service.Post(manufacturingOrderPostDto);
}
