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