public static void InsertTransactions(CorporatePaymentsDto modal)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InterbetConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("spInsertTransactions", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AccountNumber", modal.AccountNumber);
cmd.Parameters.AddWithValue("@BankName", modal.BankName);
cmd.Parameters.AddWithValue("@BranchCode", modal.BranchCode);
cmd.Parameters.AddWithValue("@ChequeNumber", modal.ChequeNumber);
cmd.Parameters.AddWithValue("@DrCrIndicator", modal.DrCrIndicator);
cmd.Parameters.AddWithValue("@EffectiveDate", modal.EffectiveDate);
cmd.Parameters.AddWithValue("@Identifier", modal.Identifier);
cmd.Parameters.AddWithValue("@ReferenceNumber", modal.ReferenceNumber);
cmd.Parameters.AddWithValue("@TransactionAmount", modal.TransactionAmount);
cmd.Parameters.AddWithValue("@TransactionCode", modal.TransactionCode);
cmd.Parameters.AddWithValue("@TransactionDate", modal.TransactionDate);
cmd.Parameters.AddWithValue("@TransactionTime", modal.TransactionTime);
cmd.Parameters.AddWithValue("@UniqueInstanceID", modal.UniqueInstanceID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string folderPath = "C:\\xmlTest";
foreach (string file in Directory.EnumerateFiles(folderPath, "*.txt"))
{
string contents = File.ReadAllText(file);
var transaction = LoadFromXMLString(contents);
var effectiveDate = Convert.ToDateTime(DateTime.ParseExact(transaction.EffectiveDate, "yyyyMMdd", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"));
var transactionDate = Convert.ToDateTime(DateTime.ParseExact(transaction.TransactionDate, "yyyyMMdd", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd"));
CorporatePaymentsDto modal = new CorporatePaymentsDto
{
EffectiveDate = effectiveDate,
TransactionDate = transactionDate,
UniqueInstanceID = transaction.UniqueInstanceID,
TransactionCode = transaction.TransactionCode,
TransactionAmount = transaction.TransactionAmount,
TransactionTime = transaction.TransactionTime,
ChequeNumber = transaction.ChequeNumber,
DrCrIndicator = transaction.DrCrIndicator,
BankName = transaction.BankName,
BranchCode = transaction.BranchCode,
ReferenceNumber = transaction.ReferenceNumber,
AccountNumber = transaction.AccountNumber,
Identifier = transaction.Identifier
};
TransactionService.InsertTransactions(modal);
label1.Text = "Succesfully exported";
}
}
catch (Exception ex)
{
label1.Text = ex.Message.ToString();
}
}
