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

Question

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

Tapan Patel · Answer

Try writing trigger that will help you to write custom logic and will insert second row based on conditions.

Vishal Jadav · Answer

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=Credit2=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 Sontakke · Answer

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.