How to insert data in two rows (debit and credit) on save

suman goud

i have two dropdowns and amount in my page

1.Account

2.ContraAccount

3.Amount

when i save this details i want to insert in database like,

Amount should debit from Account(1 row),and amount should credit in another account(2nd row)

Account ContrAccoutn Debit Credit

Cash A 100 0

A Cash 0 100

my controller code

var Ledger = db.LedgerTables.Create();

Ledger.AccountID = strddlAccount;

Ledger.ContraAccountID = strddlCustomer;

Ledger.Debit = transactionGInfo.Amount;

db.LedgerTables.Add(Ledger);

db.SaveChanges();

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
Try writing trigger, that will help you to write custom logic and will insert second row based on conditions.
Vishal Jadav10y ago
Hi,
You have created your table structure as per your requirement in that case you need to insert two entries on condition.
But, if you have table structure like below
FromUser, ToUser, [Amount], [Type(1=Credit,2=Debit)]
In such case you wont need to create two entries and no more records to handle while retrieving and only one entry for both credit and debit.
It can be used if its found suitable to you.
hope it helps,
Thanks.
Nitin Sontakke10y ago
I believe that the contra entries are applicable only in case cash transactions. You will need to conditionally create a contra entry manually and save it.
For example, (this is just an idea)
if( -- check condition when you want to create a contra entry here!)
{
Ledger.AccountID = strddlCustomer;
Ledger.ContraAccountID =strddlAccount;
Ledger.Debit = transactionGInfo.Amount;
db.LedgerTables.Add(Ledger);
db.SaveChanges();
}
Notice I have manually reversed the accounts.
From my point of view, the best approach is to handle all of this in db side. That way you don't have to replicate every time you want to create a contra entry.