public bool Savegenaralreceipt(RdReceiptDTO ObjRdReceiptDTO, NpgsqlTransaction trans, out string Receiptid) { bool IsSaved = false; StringBuilder sbQuery = new StringBuilder(); AccountingTransactionsDAL Accontstrans = new AccountingTransactionsDAL(); try { GeneralreceiptDTO Objgeneralreceipt = new GeneralreceiptDTO(); Objgeneralreceipt.preceiptid = ""; Objgeneralreceipt.ppartyid = ObjRdReceiptDTO.pConid; Objgeneralreceipt.ppartyreferenceid = ObjRdReceiptDTO.pContactid; Objgeneralreceipt.ppartyreftype = "Recurring Deposit"; Objgeneralreceipt.ppartyname = ObjRdReceiptDTO.pMembername; Objgeneralreceipt.preceiptdate = ObjRdReceiptDTO.pReceiptdate.ToString(); Objgeneralreceipt.pmodofreceipt = ObjRdReceiptDTO.pModeofreceipt; Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount); Objgeneralreceipt.pnarration = ObjRdReceiptDTO.pNarration; Objgeneralreceipt.pbankname = ObjRdReceiptDTO.pBank; Objgeneralreceipt.pBankId = ObjRdReceiptDTO.pBankid; Objgeneralreceipt.pdepositbankid = ObjRdReceiptDTO.pdepositbankid; Objgeneralreceipt.pbranchname = ObjRdReceiptDTO.pBranch; Objgeneralreceipt.ptranstype = ObjRdReceiptDTO.pTranstype; Objgeneralreceipt.ptypeofpayment = ObjRdReceiptDTO.ptypeofpayment; Objgeneralreceipt.pChequenumber = ObjRdReceiptDTO.pChequenumber; if (ObjRdReceiptDTO.ptypeofpayment == "Debit Card") { Objgeneralreceipt.pchequedate = ObjRdReceiptDTO.pReceiptdate.ToString(); } else if (ObjRdReceiptDTO.ptypeofpayment == "Credit Card") { Objgeneralreceipt.pchequedate = ObjRdReceiptDTO.pReceiptdate.ToString(); } else { Objgeneralreceipt.pchequedate = ObjRdReceiptDTO.pchequedate; } Objgeneralreceipt.pCardNumber = ObjRdReceiptDTO.pCardnumber; Objgeneralreceipt.pUpiid = ObjRdReceiptDTO.pUpiid; Objgeneralreceipt.pCreatedby = ObjRdReceiptDTO.pCreatedby; List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>(); ReceiptsDTO objpreceipts = new ReceiptsDTO(); objpreceipts.psubledgerid = ObjRdReceiptDTO.pSubledgerid; objpreceipts.pledgername = "Recurring Deposit"; objpreceipts.ptdsamountindividual = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount); objpreceipts.pamount = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount); preceiptslist.Add(objpreceipts); Objgeneralreceipt.preceiptslist = preceiptslist; if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid)) { IsSaved = true; } } catch (Exception ex) { throw ex; } return(IsSaved); }
public async Task <IActionResult> SaveRdReceipt([FromBody] RdReceiptDTO ObjRdReceiptDTO) { try { string OUTReceiptid = string.Empty; if (objRdReceipt.SaveRdReceipt(ObjRdReceiptDTO, Con, out OUTReceiptid)) { if (!string.IsNullOrEmpty(OUTReceiptid)) { if (ObjRdReceiptDTO.pModeofreceipt != "ADJUSTMENT") { _GeneralReceiptReportDTO = new GeneralReceiptReportDTO(); _GeneralReceiptReportDTO = await _AccountingTransactionsDAL.GetgeneralreceiptReportData1(OUTReceiptid, Con); return(Ok(_GeneralReceiptReportDTO)); } else { _JournalVoucherReportDTO = new List <JournalVoucherReportDTO>(); _JournalVoucherReportDTO = await _AccountingTransactionsDAL.GetJournalVoucherReportData(Con, OUTReceiptid); return(Ok(_JournalVoucherReportDTO)); } } else { return(Ok(false)); } } else { return(StatusCode(StatusCodes.Status304NotModified)); } } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError)); throw ex; } }
public bool SaveRdReceipt(RdReceiptDTO ObjRdReceiptDTO, string ConnectionString, out string OUTReceiptid) { bool Issaved = false; StringBuilder sbInsert = new StringBuilder(); bool IsAccountSaved = false; string Referenceno = string.Empty; try { con = new NpgsqlConnection(ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } trans = con.BeginTransaction(); if (ObjRdReceiptDTO.pModeofreceipt != "ADJUSTMENT") { if (Savegenaralreceipt(ObjRdReceiptDTO, trans, out OUTReceiptid)) { IsAccountSaved = true; Referenceno = OUTReceiptid; } } else { string adjustrefno = string.Empty; JournalVoucherNewDTO objJournalVoucherDTO = new JournalVoucherNewDTO(); List <PaymentsNewDTO> _Paymentslist = new List <PaymentsNewDTO>(); objJournalVoucherDTO.pjvdate = ObjRdReceiptDTO.pReceiptdate; objJournalVoucherDTO.pCreatedby = ObjRdReceiptDTO.pCreatedby; objJournalVoucherDTO.pnarration = ObjRdReceiptDTO.pNarration; objJournalVoucherDTO.pmodoftransaction = "MANUAL"; PaymentsNewDTO objPaymentsDTO = new PaymentsNewDTO { ppartyid = null, ptranstype = "C", psubledgerid = ObjRdReceiptDTO.pSubledgerid, pamount = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount) }; _Paymentslist.Add(objPaymentsDTO); objPaymentsDTO = new PaymentsNewDTO { ptranstype = "D", ppartyid = null, ppartyname = "", ppartyreferenceid = "", ppartyreftype = "" }; // long creditaccountid = memberaccountid; objPaymentsDTO.psubledgerid = ObjRdReceiptDTO.pSavingsMemberAccountid; objPaymentsDTO.pamount = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount); _Paymentslist.Add(objPaymentsDTO); objJournalVoucherDTO.pJournalVoucherlist = _Paymentslist; AccountingTransactionsDAL Accontstrans = new AccountingTransactionsDAL(); if (Accontstrans.SaveJournalVoucherNew(objJournalVoucherDTO, trans, out adjustrefno)) { Referenceno = adjustrefno; } } if (string.IsNullOrEmpty(ObjRdReceiptDTO.pRecordid.ToString()) || ObjRdReceiptDTO.pRecordid == 0) { sbInsert.Append("INSERT INTO Rd_receipt(rd_receipt_date,member_id,rd_account_id,deposit_type, instalment_amount,penalty_amount, received_amount, mode_of_receipt,receipt_no)VALUES('" + FormatDate(ObjRdReceiptDTO.pReceiptdate) + "'," + ObjRdReceiptDTO.pMemberid + "," + ObjRdReceiptDTO.pAccountid + ",'" + ObjRdReceiptDTO.pDeposittype + "'," + ObjRdReceiptDTO.pInstalmentamount + ", " + ObjRdReceiptDTO.pPenaltyamount + "," + ObjRdReceiptDTO.pReceivedamount + ",'" + ObjRdReceiptDTO.pModeofreceipt + "','" + Referenceno + "');"); } if (!string.IsNullOrEmpty(sbInsert.ToString())) { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbInsert.ToString()); } if (ObjRdReceiptDTO.pModeofreceipt == "CASH" || ObjRdReceiptDTO.pModeofreceipt == "ADJUSTMENT") { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, "select fn_rd_instalments_update('" + ObjRdReceiptDTO.pAccountno + "','" + Referenceno + "')"); } trans.Commit(); Issaved = true; OUTReceiptid = Referenceno; } catch (Exception ex) { trans.Rollback(); throw ex; } finally { if (con.State == ConnectionState.Open) { con.Dispose(); con.Close(); con.ClearPool(); trans.Dispose(); } } return(Issaved); }