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);
}
