static StripeDisputeTransaction DisputesResponseToStripeDisputes(StripeDispute d) { var disp = new StripeDisputeTransaction() { DisputeId = d.Id, TransactionType = d.Object, Reason = d.Reason, Status = d.Status, ChargeId = d.ChargeId, BalanceTransaction = JsonConvert.SerializeObject(d.BalanceTransactions), CreatedTime = d.Created, Amount = (-1) * d.Amount / 100m, Currency = d.Currency, Evidence = JsonConvert.SerializeObject(d.Evidence), EvidenceDetails = JsonConvert.SerializeObject(d.EvidenceDetails), IsChargeRefundable = d.IsChargeRefundable, LiveMode = d.LiveMode, Metadata = JsonConvert.SerializeObject(d.Metadata) }; return(disp); }
public static void UpsertStripeDispute(StripeDisputeTransaction disputes, TraceWriter log) { try { var cnnString = ConfigurationManager.ConnectionStrings["PP_ConnectionString"].ConnectionString; using (var connection = new SqlConnection(cnnString)) { connection.Open(); using (SqlCommand cmd = new SqlCommand(upsertCommand, connection)) { cmd.Parameters.Add("@DisputeID", SqlDbType.NVarChar, 50).Value = disputes.DisputeId ?? (object)DBNull.Value; cmd.Parameters.Add("@TransactionType", SqlDbType.NVarChar, 25).Value = disputes.TransactionType ?? (object)DBNull.Value; cmd.Parameters.Add("@Reason", SqlDbType.NVarChar, 255).Value = disputes.Reason ?? (object)DBNull.Value; cmd.Parameters.Add("@Status", SqlDbType.NVarChar, 255).Value = disputes.Status ?? (object)DBNull.Value; cmd.Parameters.Add("@BalanceTransaction", SqlDbType.NVarChar).Value = disputes.BalanceTransaction ?? (object)DBNull.Value; cmd.Parameters.Add("@ChargeID", SqlDbType.NVarChar, 50).Value = disputes.ChargeId ?? (object)DBNull.Value; cmd.Parameters.Add("@CreatedTime", SqlDbType.DateTime2).Value = disputes.CreatedTime ?? (object)DBNull.Value; cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = disputes.Amount ?? (object)DBNull.Value; cmd.Parameters.Add("@Currency", SqlDbType.NVarChar, 10).Value = disputes.Currency ?? (object)DBNull.Value; cmd.Parameters.Add("@Evidence", SqlDbType.NVarChar).Value = disputes.Evidence ?? (object)DBNull.Value; cmd.Parameters.Add("@EvidenceDetails ", SqlDbType.NVarChar).Value = disputes.EvidenceDetails ?? (object)DBNull.Value; cmd.Parameters.Add("@IsChargeRefundable ", SqlDbType.Bit).Value = disputes.IsChargeRefundable ?? (object)DBNull.Value; cmd.Parameters.Add("@LiveMode", SqlDbType.Bit).Value = disputes.LiveMode ?? (object)DBNull.Value; cmd.Parameters.Add("@Metadata", SqlDbType.NVarChar).Value = disputes.Metadata ?? (object)DBNull.Value; cmd.Parameters.Add("@RecordUpdatedDate", SqlDbType.DateTime2, 50).Value = DateTime.UtcNow; var resultCount = cmd.ExecuteNonQuery(); } } } catch (Exception ex) { log.Error("InsertStripeTransaction error", ex); } }