public bool PODColumnsInfoUpdateByTable(DataTable table) { UpdatePodColumnInfoRequest result = new UpdatePodColumnInfoRequest(); using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString)) { DataTable dtable = new DataTable(); SqlCommand cmd = new SqlCommand("Proc_UpdateColumnInfo", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PODColumnsInfoSOURCE", table); cmd.Parameters[0].SqlDbType = SqlDbType.Structured; cmd.Parameters.AddWithValue("@RESULT", 0); cmd.Parameters[1].Direction = ParameterDirection.Output; cmd.Parameters[1].SqlDbType = SqlDbType.Bit; conn.Open(); cmd.ExecuteNonQuery(); result.result = cmd.Parameters[1].Value.ObjectToBoolean(); return(result.result); } }
public Response <bool> PODColumnsInfoUpdateByTable(UpdatePodColumnInfoRequest request) { Response <bool> response = new Response <bool>(); if (request == null) { ArgumentNullException ex = new ArgumentNullException("OrderNoInfoUpdateByTable request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { HiltiAccessor accessor = new HiltiAccessor(); response.Result = accessor.PODColumnsInfoUpdateByTable(request.PodColumnInfo); if (response.Result) { response.IsSuccess = true; } else { response.IsSuccess = false; } } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }