public Response <UpdatePodInfoUpdateRequest> PodInfoUpdateByTable(UpdatePodInfoUpdateRequest request) { Response <UpdatePodInfoUpdateRequest> response = new Response <UpdatePodInfoUpdateRequest>(); if (request == null) { ArgumentNullException ex = new ArgumentNullException("PodInfoUpdateByTable request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { HiltiAccessor accessor = new HiltiAccessor(); response.Result = accessor.PodInfoUpdateByTable(request); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }
public UpdatePodInfoUpdateRequest PodInfoUpdateByTable(UpdatePodInfoUpdateRequest Info) { using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString)) { //var PodInfo = new List<PodInfoUpdateToDb>(); //PodInfo.Add(new PodInfoUpdateToDb(Info.PodInfoUpdate)); DataTable dtable = new DataTable(); SqlCommand cmd = new SqlCommand("Proc_Hilti_UpdateNotDeliverGoods", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NotDeliverGoodsSOURCE", Info.NotDeliverGoods); cmd.Parameters[0].SqlDbType = SqlDbType.Structured; cmd.Parameters.AddWithValue("@ERRORSOURCEVALUE", ""); cmd.Parameters[1].Direction = ParameterDirection.Output; cmd.Parameters[1].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[1].Size = 2000; cmd.Parameters.AddWithValue("@ISORSUCCESS", 0); cmd.Parameters[2].Direction = ParameterDirection.Output; cmd.Parameters[2].SqlDbType = SqlDbType.Bit; cmd.Parameters.AddWithValue("@ActualDeliveryDate", Info.ActualDeliveryDate); cmd.Parameters[3].Direction = ParameterDirection.Input; cmd.Parameters[3].SqlDbType = SqlDbType.DateTime; cmd.CommandTimeout = 180; conn.Open(); SqlDataAdapter Adp = new SqlDataAdapter(cmd); Adp.Fill(dtable); Info.ERRORSOURCEVALUE = cmd.Parameters[1].Value.ToString(); Info.ISORSUCCESS = cmd.Parameters[2].Value.ObjectToBoolean(); Info.DeliverGoods = dtable; return(Info); } }