public bool insertJournalEntryDetail(JournalEntryDetail pJournalEntryDetail) { bool _success = false; using (MySqlConnection _conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString)) { _conn.Open(); MySqlTransaction _trans = _conn.BeginTransaction(); MySqlCommand _cmd = new MySqlCommand("call spInsertJournalEntryDetail('" + pJournalEntryDetail.JournalEntryId + "','" + pJournalEntryDetail.AccountId + "','" + pJournalEntryDetail.Debit + "','" + pJournalEntryDetail.Credit + "','" + pJournalEntryDetail.Subsidiary + "','" + pJournalEntryDetail.SubsidiaryId + "','" + pJournalEntryDetail.SubsidiaryDescription + "','" + pJournalEntryDetail.Remarks + "','" + pJournalEntryDetail.UserId + "');", _conn); try { _cmd.Transaction = _trans; int _rowsAffected = _cmd.ExecuteNonQuery(); _trans.Commit(); _conn.Close(); if (_rowsAffected > 0) { _success = true; } else { _success = false; } } catch { _trans.Rollback(); _success = false; } } return(_success); }