public int SaveInitialBalance(party_journal partyJournal) { try { var objPartyJournal = new party_journal { transaction_date = DateTime.Now, transaction_type = "INITIAL-BALANCE", party_id = partyJournal.party_id, opening_balance = partyJournal.opening_balance, dr_amount = 0, cr_amount = 0, closing_balance = partyJournal.opening_balance, remarks = "Initial Balance", created_by = partyJournal.created_by, document_code = "INITIAL-BALANCE", created_date = DateTime.Now, updated_by = partyJournal.created_by, updated_date = DateTime.Now, }; _entities.party_journal.Add(objPartyJournal); _entities.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }
public long PartyJournalEntry(string transactionType, long partyId, decimal transactionAmount, string remarks, long userId, string documentCode) { try { // GET TRANSACTION CONFIGURATION var tranConfig = _entities.transaction_configuration.FirstOrDefault(w => w.transaction_type == transactionType); if (tranConfig != null) { party_journal partyJournal = new party_journal { transaction_date = DateTime.Now, transaction_type = transactionType, party_id = partyId, opening_balance = 0, dr_amount = 0, cr_amount = 0, closing_balance = 0, remarks = remarks, created_by = userId, document_code = documentCode, created_date = DateTime.Now, updated_by = userId, updated_date = DateTime.Now, }; // GET OPENNIG BALANCE var partyTransaction = _entities.party_journal.Where(w => w.party_id == partyId) .OrderByDescending(o => o.party_journal_id) .FirstOrDefault(); decimal closingBalance = 0; if (partyTransaction != null) { closingBalance = partyTransaction.closing_balance ?? 0; } partyJournal.opening_balance = closingBalance; // DEBIT OR CREDIT if (tranConfig.is_dr ?? false) { partyJournal.dr_amount = transactionAmount; } else if (tranConfig.is_cr ?? false) { partyJournal.cr_amount = transactionAmount; } partyJournal.closing_balance = partyJournal.opening_balance + partyJournal.dr_amount - partyJournal.cr_amount; // INSERT PARTY JOURNAL _entities.party_journal.Add(partyJournal); _entities.SaveChanges(); return(partyJournal.party_journal_id); } } catch (Exception) { return(0); } return(0); }
public HttpResponseMessage SaveInitialBalance(party_journal partyJournal) { var saved = partyjournalRepository.SaveInitialBalance(partyJournal); var formatter = RequestFormat.JsonFormaterString(); if (saved == 1) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { output = "success", msg = "Information is saved successfully." }, formatter)); } else { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { output = "error", msg = "Cannot save initial balance" }, formatter)); } }