首页 > 解决方案 > 从类方法获取错误到 Web api 调用的最佳方法

问题描述

我有一个可以正确插入数据的类,但是这个函数正在与 webapi 通信。

我如何可能从共享库将异常信息返回到 web api?

public void AddStockTransfer(StockTransfer item)
{
  using (var connection = new SqlConnection(ConfigurationManager.AppSettings["DataConnectionLive"]))
  {
   connection.Open();
   string insertQuery = @"
INSERT INTO[fuel].[StockTransfer]
        ([StockTransferGuid]
          ,[StockItemId]
          ,[Quantity]
          ,[SourceWarehouseId]
          ,[SourceBin]
          ,[TargetWarehouseId]
          ,[TargetBin]
          ,[DateTimeCreated]
          ,[DateTimeLastUpdated]
          ,[StockTransferStatus]
          ,[StatusMessage])
    VALUES (@StockTransferGuid,@StockItemId,@Quantity,@SourceWarehouseId,@SourceBin,@TargetWarehouseId,@TargetBin,@DateTimeCreated,@DateTimeLastUpdated,@StockTransferStatus,@StatusMessage)";

                    var mydate = DateTime.Now;
                    var mydate2 = DateTime.Now;
                    var result = connection.Execute(insertQuery, new
                    {
                        item.StockTransferGuid,
                        item.StockItemId,
                        item.Quantity,
                        item.SourceWarehouseId,
                        item.SourceBin,
                        item.TargetWarehouseId,
                        item.TargetBin,
                        mydate,
                        mydate2,
                        item.StockTransferStatus,
                        item.StatusMessage
                    });



            }catch (Exception ex)

            {
                    logger.Warn("Connection string is " + connection.ConnectionString.ToString());
                logger.Warn("Error occoured on add stock transfer funciton " + ex.Message.ToString());
            }


        }
    }

我想传递记录器看到的内容,并将其传递给我的网络方法。

[HttpPost]
public ActionResult Create(StockTransfer stockTrans)
{
  try
        {

            database.AddStockTransfer(stockTrans);
        }
        catch (Exception ex)
        {

            logger.Warn("Error on Create ex");
        }



        return Json(true);
  }

标签: c#asp.net-web-api

解决方案


推荐阅读