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