public bool Savegenaralreceipt(SaveEmireceiptsDTO SaveEmireceiptslist, 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 = SaveEmireceiptslist.pConid;
Objgeneralreceipt.ppartyreftype = "APPLICANT";
Objgeneralreceipt.ppartyreferenceid = SaveEmireceiptslist.pContactid;
Objgeneralreceipt.ppartyname = SaveEmireceiptslist.pApplicantname;
Objgeneralreceipt.preceiptdate = SaveEmireceiptslist.pReceiptdate.ToString();
Objgeneralreceipt.pmodofreceipt = SaveEmireceiptslist.pModeofreceipt;
Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(SaveEmireceiptslist.pTotalreceived);
Objgeneralreceipt.pnarration = SaveEmireceiptslist.pNarration;
Objgeneralreceipt.pbankname = SaveEmireceiptslist.pBank;
Objgeneralreceipt.pBankId = SaveEmireceiptslist.pBankid;
Objgeneralreceipt.pdepositbankid = SaveEmireceiptslist.pDeposibankid;
Objgeneralreceipt.pbranchname = SaveEmireceiptslist.pBranch;
Objgeneralreceipt.ptranstype = SaveEmireceiptslist.pTranstype;
Objgeneralreceipt.ptypeofpayment = SaveEmireceiptslist.pTypeofpaymentonline;
Objgeneralreceipt.pChequenumber = SaveEmireceiptslist.pChequeno;
Objgeneralreceipt.pchequedate = SaveEmireceiptslist.pTransdate;
Objgeneralreceipt.pCardNumber = SaveEmireceiptslist.pVchcardnumber;
Objgeneralreceipt.pUpiid = SaveEmireceiptslist.pUpiid;
Objgeneralreceipt.pCreatedby = SaveEmireceiptslist.pCreatedby;
List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>();
ReceiptsDTO objpreceipts = new ReceiptsDTO();
objpreceipts.psubledgerid = SaveEmireceiptslist.pSubledgerid;
objpreceipts.pledgername = "SUNDRY DEBITORS" + "_" + SaveEmireceiptslist.pLoanname;
objpreceipts.ptdsamountindividual = Convert.ToDecimal(SaveEmireceiptslist.pTotalreceived);
objpreceipts.pamount = Convert.ToDecimal(SaveEmireceiptslist.pTotalreceived);
preceiptslist.Add(objpreceipts);
Objgeneralreceipt.preceiptslist = preceiptslist;
if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsSaved);
}
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);
}
public bool SaveSharegenaralreceipt(ShareReceiptDTO ObjShareReceiptDTO, 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 = ObjShareReceiptDTO.pConid;
Objgeneralreceipt.ppartyreferenceid = ObjShareReceiptDTO.pContactid;
Objgeneralreceipt.ppartyreftype = "Saving Account Receipt";
Objgeneralreceipt.ppartyname = ObjShareReceiptDTO.pMembername;
Objgeneralreceipt.preceiptdate = ObjShareReceiptDTO.pReceiptdate.ToString();
Objgeneralreceipt.pmodofreceipt = ObjShareReceiptDTO.pModeofreceipt;
Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(ObjShareReceiptDTO.pReceivedamount);
Objgeneralreceipt.pnarration = ObjShareReceiptDTO.pNarration;
Objgeneralreceipt.pbankname = ObjShareReceiptDTO.pBank;
Objgeneralreceipt.pBankId = ObjShareReceiptDTO.pBankid;
Objgeneralreceipt.pdepositbankid = ObjShareReceiptDTO.pdepositbankid;
Objgeneralreceipt.pbranchname = ObjShareReceiptDTO.pBranch;
Objgeneralreceipt.ptranstype = ObjShareReceiptDTO.pTranstype;
Objgeneralreceipt.ptypeofpayment = ObjShareReceiptDTO.ptypeofpayment;
Objgeneralreceipt.pChequenumber = ObjShareReceiptDTO.pChequenumber;
if (ObjShareReceiptDTO.ptypeofpayment == "Debit Card")
{
Objgeneralreceipt.pchequedate = ObjShareReceiptDTO.pReceiptdate.ToString();
}
else if (ObjShareReceiptDTO.ptypeofpayment == "Credit Card")
{
Objgeneralreceipt.pchequedate = ObjShareReceiptDTO.pReceiptdate.ToString();
}
else
{
Objgeneralreceipt.pchequedate = ObjShareReceiptDTO.pchequedate;
}
Objgeneralreceipt.pCardNumber = ObjShareReceiptDTO.pCardnumber;
Objgeneralreceipt.pUpiid = ObjShareReceiptDTO.pUpiid;
Objgeneralreceipt.pCreatedby = ObjShareReceiptDTO.pCreatedby;
string membername = ObjShareReceiptDTO.pMembername;
string membercode = ObjShareReceiptDTO.pMembercode;
string membernamecode = membercode + "_" + membername;
List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>();
ReceiptsDTO objpreceipts = new ReceiptsDTO();
objpreceipts.psubledgerid = ObjShareReceiptDTO.pSubledgerid;
objpreceipts.pledgername = membername;
objpreceipts.ptdsamountindividual = Convert.ToDecimal(ObjShareReceiptDTO.pReceivedamount);
objpreceipts.pamount = Convert.ToDecimal(ObjShareReceiptDTO.pReceivedamount);
preceiptslist.Add(objpreceipts);
Objgeneralreceipt.preceiptslist = preceiptslist;
if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsSaved);
}
public bool Savegenaralreceipt(MemberReceiptDTO ObjMemberReceiptDTO, 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 = ObjMemberReceiptDTO.pConid;
Objgeneralreceipt.ppartyreferenceid = ObjMemberReceiptDTO.pContactid;
Objgeneralreceipt.ppartyreftype = "Member Receipt";
Objgeneralreceipt.ppartyname = ObjMemberReceiptDTO.pMembername;
Objgeneralreceipt.preceiptdate = ObjMemberReceiptDTO.pReceiptdate.ToString();
Objgeneralreceipt.pmodofreceipt = ObjMemberReceiptDTO.pModeofreceipt;
Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(ObjMemberReceiptDTO.pReceivedamount);
Objgeneralreceipt.pnarration = ObjMemberReceiptDTO.pNarration;
Objgeneralreceipt.pbankname = ObjMemberReceiptDTO.pBank;
Objgeneralreceipt.pBankId = ObjMemberReceiptDTO.pBankid;
Objgeneralreceipt.pdepositbankid = ObjMemberReceiptDTO.pdepositbankid;
Objgeneralreceipt.pbranchname = ObjMemberReceiptDTO.pBranch;
Objgeneralreceipt.ptranstype = ObjMemberReceiptDTO.pTranstype;
Objgeneralreceipt.ptypeofpayment = ObjMemberReceiptDTO.ptypeofpayment;
Objgeneralreceipt.pChequenumber = ObjMemberReceiptDTO.pChequenumber;
if (ObjMemberReceiptDTO.ptypeofpayment == "Debit Card")
{
Objgeneralreceipt.pchequedate = ObjMemberReceiptDTO.pReceiptdate.ToString();
}
else if (ObjMemberReceiptDTO.ptypeofpayment == "Credit Card")
{
Objgeneralreceipt.pchequedate = ObjMemberReceiptDTO.pReceiptdate.ToString();
}
else
{
Objgeneralreceipt.pchequedate = ObjMemberReceiptDTO.pchequedate;
}
Objgeneralreceipt.pCardNumber = ObjMemberReceiptDTO.pCardnumber;
Objgeneralreceipt.pUpiid = ObjMemberReceiptDTO.pUpiid;
Objgeneralreceipt.pCreatedby = ObjMemberReceiptDTO.pCreatedby;
string membername = ObjMemberReceiptDTO.pMembername;
string membercode = ObjMemberReceiptDTO.pMembercode;
string membernamecode = membercode + "_" + membername;
List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>();
ReceiptsDTO objpreceipts = new ReceiptsDTO();
Int64 membershipaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where accountname in('MEMBERSHIP FEE') AND chracctype='2' and statusid=" + Convert.ToInt32(Status.Active) + ";"));
int subledgerid = Convert.ToInt32(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + membernamecode + "', " + membershipaccountid + ", '3'," + ObjMemberReceiptDTO.pCreatedby + ")"));
objpreceipts.psubledgerid = subledgerid;
objpreceipts.pledgername = membernamecode;
objpreceipts.ptdsamountindividual = Convert.ToDecimal(ObjMemberReceiptDTO.pReceivedamount);
objpreceipts.pamount = Convert.ToDecimal(ObjMemberReceiptDTO.pReceivedamount);
preceiptslist.Add(objpreceipts);
Objgeneralreceipt.preceiptslist = preceiptslist;
if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsSaved);
}
