public List <PaymentsDTO> GetPaymentVoucherDetailsReportDataById(string paymentId, string Connectionstring) { Paymentsdetailslist = new List <PaymentsDTO>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(Connectionstring, CommandType.Text, "SELECT contactname,accountname,SUM(ledgeramount)ledgeramount FROM (select contactname,case when chracctype ='2' then accountname else parentaccountname end accountname,(coalesce(ledgeramount,0) ) ledgeramount from tbltranspaymentvoucherdetails tr join tblmstaccounts tac on tac.accountid=tr.debitaccountid where paymentid='" + paymentId + "')X GROUP BY contactname,accountname ORDER BY contactname")) { while (dr.Read()) { objPaymentsDTO = new PaymentsDTO { ppartyname = Convert.ToString(dr["contactname"]), pamount = Convert.ToDecimal(dr["ledgeramount"]), pledgername = Convert.ToString(dr["accountname"]) }; Paymentsdetailslist.Add(objPaymentsDTO); } } } catch (Exception ex) { throw ex; } return(Paymentsdetailslist); }
public ActionResult UpdatePayments(PaymentsDTO payment) { int cnt = posMasters.UpdatePayments(payment); //List<PaymentsDTO> lstPayments = posMasters.showPayments(); return(new JsonResult { Data = cnt, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult DeletePayments(PaymentsDTO payment) { bool isSaved = posMasters.DeletePayments(payment); List <PaymentsDTO> lstPayments = posMasters.showPayments(); return(new JsonResult { Data = lstPayments, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult SavePayments(PaymentsDTO payment) { payment.statusid = 1; payment.createdby = Convert.ToInt64(Session["UserId"]); int Count = posMasters.SavePayments(payment); // List<PaymentsDTO> lstPayments = posMasters.showPayments(); return(new JsonResult { Data = Count, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public PaymentsDTO GetPaymentById(int paymentId) { PaymentsDTO payments = (from p in svmContext.tblpayment join q in svmContext.tblstudent on p.StudentId equals q.StudentId where p.IsDeleted == false && p.PaymentId == paymentId select new PaymentsDTO { StudentNo = q.StudentNo, FirstName = q.FirstName, MiddleName = q.MiddleName, LastName = q.LastName }).FirstOrDefault(); return(payments); }
public BankInformationDTO SaveOpeningJV(BankInformationDTO lstBankInformation) { string refjvnumber = ""; List <PaymentsDTO> _Paymentslist = new List <PaymentsDTO>(); string JvDate = NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select transactionopeningdate from tblmstcompany where statusid=" + Convert.ToInt32(Status.Active) + ";").ToString(); objJournalVoucherDTO.pjvdate = JvDate; objJournalVoucherDTO.pnarration = "OPENING BALANCE OF BANK ACCOUNT"; objJournalVoucherDTO.pmodoftransaction = "AUTO"; if (lstBankInformation.pOpeningBalanceType.ToUpper() == "C") { objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ptranstype = "C"; objPaymentsDTO.psubledgerid = BankAccountId; objPaymentsDTO.pamount = lstBankInformation.pOpeningBalance; _Paymentslist.Add(objPaymentsDTO); objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ptranstype = "D"; objPaymentsDTO.psubledgerid = OpeningBalanceAccountID; objPaymentsDTO.pamount = lstBankInformation.pOpeningBalance; _Paymentslist.Add(objPaymentsDTO); } else if (lstBankInformation.pOpeningBalanceType.ToUpper() == "D") { objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ptranstype = "D"; objPaymentsDTO.psubledgerid = BankAccountId; objPaymentsDTO.pamount = lstBankInformation.pOpeningBalance; _Paymentslist.Add(objPaymentsDTO); objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ptranstype = "C"; objPaymentsDTO.psubledgerid = OpeningBalanceAccountID; objPaymentsDTO.pamount = lstBankInformation.pOpeningBalance; _Paymentslist.Add(objPaymentsDTO); } objJournalVoucherDTO.pJournalVoucherlist = _Paymentslist; if (objJournalVoucherDTO.pJournalVoucherlist.Count > 0) { objJournalVoucher.SaveJournalVoucher(objJournalVoucherDTO, trans, out refjvnumber); } strSave.Append("UPDATE tblmstbank SET openingjvno='" + refjvnumber + "' WHERE recordid=" + lstBankInformation.pRecordid + ";"); return(lstBankInformation); }
public List <PaymentsDTO> GetPays(string pStrFolio) { SAPbobsCOM.Recordset lObjRecordset = null; List <PaymentsDTO> lLstPaymentsDTO = new List <PaymentsDTO>(); try { Dictionary <string, string> lLstStrParameters = new Dictionary <string, string>(); lLstStrParameters.Add("Folio", pStrFolio); string lStrQuery = this.GetSQL("GetPay").Inject(lLstStrParameters); //this.UIAPIRawForm.DataSources.DataTables.Item("RESULT").ExecuteQuery(lStrQuery); lObjRecordset = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { PaymentsDTO lObjPaymentDTO = new PaymentsDTO(); lObjPaymentDTO.DocEntry = lObjRecordset.Fields.Item("DocEntry").Value.ToString(); lObjPaymentDTO.DocNum = lObjRecordset.Fields.Item("DocNum").Value.ToString(); lObjPaymentDTO.DocDate = Convert.ToDateTime(lObjRecordset.Fields.Item("DocDate").Value.ToString()); lObjPaymentDTO.DocTotal = Convert.ToDouble(lObjRecordset.Fields.Item("DocTotal").Value.ToString()); lLstPaymentsDTO.Add(lObjPaymentDTO); lObjRecordset.MoveNext(); } } } catch (Exception ex) { UIApplication.ShowError(string.Format("GetPayments: {0}", ex.Message)); LogService.WriteError("PaymentDAO (GetPayments): " + ex.Message); LogService.WriteError(ex); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lLstPaymentsDTO); }
public bool CreatePayment(PaymentsDTO request) { return(_PaymentsRepo.CreatePayment(request.PaymentRequestId, request.ParentId, request.Amount)); }
public bool CreateGroupPaymentRequest(PaymentsDTO request) { return(_PaymentsRepo.CreateGroupPaymentRequest(request.ClientId, request.GroupId, request.Amount, request.DueDate, request.PaymentRequestTypeId)); }
public List <FinancialDTO> GetAllFinancialsForParent(PaymentsDTO request) { return(_PaymentsRepo.GetAllFinancialsForParent(request.ParentId)); }
/// <summary> /// 修改用户支付方式 /// </summary> /// <param name="paymentsDTO">支付方式实体</param> /// <returns></returns> public ResultDTO UpdatePaymentExt(PaymentsVM paymentsVM) { if (paymentsVM == null || paymentsVM.PaymentIds == null || !paymentsVM.PaymentIds.Any()) { return new ResultDTO { ResultCode = 1, Message = "支付方式不能为空" } } ; if (paymentsVM.AppScoreSetting == null) { paymentsVM.AppScoreSetting = new AppScoreSettingDTO(); } //app是否有积分功能项 var isMyIntegral = BACBP.CheckMyIntegral(paymentsVM.AppId); if (isMyIntegral && paymentsVM.AppScoreSetting.IsCashForScore && CustomConfig.ScoreCostList.All(c => c != paymentsVM.AppScoreSetting.ScoreCost)) { return(new ResultDTO { ResultCode = 2, Message = "积分设置不合法" }); } Payments p = new Payments(); List <Payments> payments = Payments.ObjectSet().Where(n => n.AppId == paymentsVM.AppId).ToList(); ContextSession contextSession = ContextFactory.CurrentThreadContext; try { foreach (Payments item in payments) { item.EntityState = System.Data.EntityState.Deleted; contextSession.Delete(item); } if (paymentsVM.PaymentIds != null && paymentsVM.PaymentIds.Count() > 0) { foreach (var item in paymentsVM.PaymentIds) { Guid payId; if (!Guid.TryParse(item, out payId)) { continue; } string name = AllPayment.ObjectSet().Where(n => n.Id == payId).Select(n => n.PaymentName).FirstOrDefault(); DateTime dt = DateTime.Now; PaymentsDTO paymentsDTO = new PaymentsDTO(); paymentsDTO.Id = Guid.NewGuid(); paymentsDTO.Name = name; paymentsDTO.AppId = paymentsVM.AppId; paymentsDTO.Code = dt.ToFileTime().ToString(); paymentsDTO.SubTime = DateTime.Now; paymentsDTO.SubId = paymentsVM.AppId; paymentsDTO.PaymentId = new Guid(item); paymentsDTO.IsOnuse = paymentsVM.IsOnuse; paymentsDTO.PaymentName = name; if (name == "支付宝") { paymentsDTO.AliPayPartnerId = paymentsVM.AliPayPartnerId; paymentsDTO.AliPayPrivateKey = paymentsVM.AliPayPrivateKey; paymentsDTO.AliPayPublicKey = paymentsVM.AliPayPublicKey; paymentsDTO.AliPaySeller = paymentsVM.AliPaySeller; paymentsDTO.AliPayVerifyCode = paymentsVM.AliPayVerifyCode; } paymentsDTO.EntityState = System.Data.EntityState.Added; Payments payment = new Payments().FromEntityData(paymentsDTO); contextSession.SaveObject(payment); } } //保存积分抵现设置 if (isMyIntegral) { var appExt = AppExtension.ObjectSet().FirstOrDefault(c => c.Id == paymentsVM.AppId); if (appExt != null) { appExt.IsCashForScore = paymentsVM.AppScoreSetting.IsCashForScore; appExt.ModifiedOn = DateTime.Now; appExt.EntityState = EntityState.Modified; } else { appExt = AppExtension.CreateAppExtension(); appExt.Id = paymentsVM.AppId; appExt.IsCashForScore = paymentsVM.AppScoreSetting.IsCashForScore; contextSession.SaveObject(appExt); } if (paymentsVM.AppScoreSetting.IsCashForScore) { //差异判断,设置不变,不重新保存 var lastScoreSetting = ScoreSetting.ObjectSet().Where(c => c.AppId == paymentsVM.AppId).OrderByDescending(c => c.SubTime).FirstOrDefault(); if (lastScoreSetting == null || lastScoreSetting.ScoreCost != paymentsVM.AppScoreSetting.ScoreCost) { ScoreSetting scoreSetting = ScoreSetting.CreateScoreSetting(); scoreSetting.ScoreCost = paymentsVM.AppScoreSetting.ScoreCost; scoreSetting.AppId = paymentsVM.AppId; contextSession.SaveObject(scoreSetting); } } } contextSession.SaveChange(); //删除缓存 Jinher.JAP.Cache.GlobalCacheWrapper.Remove("G_PaymentInfo", paymentsVM.AppId.ToString(), "BTPCache"); Jinher.JAP.Cache.GlobalCacheWrapper.Remove("G_AliPayInfo", paymentsVM.AppId.ToString(), "BTPCache"); } catch (Exception ex) { LogHelper.Error(string.Format("修改用户支付方式服务异常。paymentsVM:{0}", JsonHelper.JsonSerializer(paymentsVM)), ex); return(new ResultDTO { ResultCode = 1, Message = "Error" }); } return(new ResultDTO { ResultCode = 0, Message = "Success" }); }
public bool CallsaveGeneralReceipt(GeneralreceiptDTO GeneralreceiptDTO, NpgsqlTransaction trans, out string pGeneralReceiptId) { StringBuilder sbGeneralReceipt = new StringBuilder(); bool Savedstatus = false; long Debitaccountid = 0; string Maxreceiptid = string.Empty; try { // Generate Next Receipt Id if (string.IsNullOrEmpty(GeneralreceiptDTO.preceiptid)) { GeneralreceiptDTO.preceiptid = NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "SELECT FN_GENERATENEXTID('GENERAL VOUCHER','" + ManageQuote(GeneralreceiptDTO.pmodofreceipt).Trim().ToUpper() + "','" + FormatDate(GeneralreceiptDTO.preceiptdate) + "')").ToString(); } pGeneralReceiptId = GeneralreceiptDTO.preceiptid; if (string.IsNullOrEmpty(GeneralreceiptDTO.preceiptdate)) { GeneralreceiptDTO.preceiptdate = "null"; } else { //GeneralreceiptDTO.preceiptdate = "'" + FormatDate(GeneralreceiptDTO.preceiptdate) + "'"; // Not Formats date here due to dependency in JV Save GeneralreceiptDTO.preceiptdate = GeneralreceiptDTO.preceiptdate; } if (string.IsNullOrEmpty(GeneralreceiptDTO.pchequedate)) { GeneralreceiptDTO.pchequedate = "null"; } else { GeneralreceiptDTO.pchequedate = "'" + FormatDate(GeneralreceiptDTO.pchequedate) + "'"; } GeneralreceiptDTO.ptotalreceivedamount = Convert.ToString(GeneralreceiptDTO.ptotalreceivedamount) == string.Empty ? 0 : GeneralreceiptDTO.ptotalreceivedamount < 0 ? 0 : GeneralreceiptDTO.ptotalreceivedamount; if (GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() == "CASH") { Debitaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='CASH ON HAND' and statusid=" + Convert.ToInt32(Status.Active) + ";")); } else if (GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() == "BANK" || GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() == "WALLET") { Debitaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='UNCLEARED CHEQUES A/C' and statusid=" + Convert.ToInt32(Status.Active) + ";")); } if (string.IsNullOrEmpty(GeneralreceiptDTO.ptypeofpayment)) { GeneralreceiptDTO.ptypeofpayment = GeneralreceiptDTO.ptranstype; } long GeneralReceiptRecordid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "INSERT INTO tbltransgeneralreceipt(receiptid, receiptdate, totalreceivedamount,narration, debitaccountid,contactid,statusid,createdby,createddate,istdsapplicable, modeofreceipt,tdssection, pannumber, tdscalculationtype,tdspercentage, tdsamount,contactname,contactreftype,contactrefid,filename,filepath,fileformat) VALUES ('" + ManageQuote(GeneralreceiptDTO.preceiptid) + "', '" + FormatDate(GeneralreceiptDTO.preceiptdate) + "', " + GeneralreceiptDTO.ptotalreceivedamount + ", '" + ManageQuote(GeneralreceiptDTO.pnarration) + "', " + Debitaccountid + ", " + GeneralreceiptDTO.ppartyid + ", " + Convert.ToInt32(Status.Active) + ", " + GeneralreceiptDTO.pCreatedby + ", current_timestamp, " + GeneralreceiptDTO.pistdsapplicable + ", '" + ManageQuote(GeneralreceiptDTO.pmodofreceipt) + "', '" + ManageQuote(GeneralreceiptDTO.pTdsSection) + "', '" + ManageQuote(GeneralreceiptDTO.ppartypannumber) + "', '" + ManageQuote(GeneralreceiptDTO.ptdscalculationtype) + "'," + GeneralreceiptDTO.pTdsPercentage + ", " + GeneralreceiptDTO.ptdsamount + ",'" + ManageQuote(GeneralreceiptDTO.ppartyname) + "','" + ManageQuote(GeneralreceiptDTO.ppartyreftype) + "','" + ManageQuote(GeneralreceiptDTO.ppartyreferenceid) + "','" + ManageQuote(GeneralreceiptDTO.pFilename) + "','" + ManageQuote(GeneralreceiptDTO.pFilepath) + "','" + ManageQuote(GeneralreceiptDTO.pFileformat) + "') returning recordid;")); if (GeneralreceiptDTO.preceiptslist != null && GeneralreceiptDTO.preceiptslist.Count > 0) { for (int i = 0; i < GeneralreceiptDTO.preceiptslist.Count; i++) { if (GeneralreceiptDTO.pistdsapplicable && GeneralreceiptDTO.ptdsamount > 0) { if (GeneralreceiptDTO.ptdscalculationtype == "INCLUDE") { GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual = Math.Round((GeneralreceiptDTO.preceiptslist[i].pamount * GeneralreceiptDTO.pTdsPercentage) / (100 + GeneralreceiptDTO.pTdsPercentage)); GeneralreceiptDTO.preceiptslist[i].pamount = GeneralreceiptDTO.preceiptslist[i].pamount - GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual; } else if (GeneralreceiptDTO.ptdscalculationtype == "EXCLUDE") { GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual = Math.Round((GeneralreceiptDTO.preceiptslist[i].pamount * GeneralreceiptDTO.pTdsPercentage) / 100); } } else { GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual = 0; } if (!string.IsNullOrEmpty(GeneralreceiptDTO.preceiptslist[i].pState) && GeneralreceiptDTO.preceiptslist[i].pState.Contains('-')) { string[] Stateandgst = GeneralreceiptDTO.preceiptslist[i].pState.Split('-'); GeneralreceiptDTO.preceiptslist[i].pState = Stateandgst[0].Trim(); GeneralreceiptDTO.preceiptslist[i].pgstno = Stateandgst[1].Trim(); } sbGeneralReceipt.AppendLine("INSERT INTO tbltransgeneralreceiptdetails( detailsid, receiptid, creditaccountid, ledgeramount,gsttype, gstcalculationtype, gstpercentage, igstamount, cgstamount, sgstamount, utgstamount,gstnumber,stateid,statename,isgstapplicable,tdssection,tdspercentage,tdsamount) VALUES (" + GeneralReceiptRecordid + ", '" + ManageQuote(GeneralreceiptDTO.preceiptid) + "', " + GeneralreceiptDTO.preceiptslist[i].psubledgerid + ", " + GeneralreceiptDTO.preceiptslist[i].pamount + ", '" + ManageQuote(GeneralreceiptDTO.preceiptslist[i].pgsttype) + "', '" + ManageQuote(GeneralreceiptDTO.preceiptslist[i].pgstcalculationtype) + "', " + GeneralreceiptDTO.preceiptslist[i].pgstpercentage + ", " + GeneralreceiptDTO.preceiptslist[i].pigstamount + ", " + GeneralreceiptDTO.preceiptslist[i].pcgstamount + ", " + GeneralreceiptDTO.preceiptslist[i].psgstamount + ", " + GeneralreceiptDTO.preceiptslist[i].putgstamount + ",'" + ManageQuote(GeneralreceiptDTO.preceiptslist[i].pgstno) + "'," + GeneralreceiptDTO.preceiptslist[i].pStateId + ",'" + ManageQuote(GeneralreceiptDTO.preceiptslist[i].pState) + "'," + GeneralreceiptDTO.preceiptslist[i].IsGstapplicable + ",'" + ManageQuote(GeneralreceiptDTO.pTdsSection) + "'," + GeneralreceiptDTO.pTdsPercentage + "," + GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual + ");"); } } string particulars = ""; if (GeneralreceiptDTO.preceiptslist.Count > 0) { particulars = GeneralreceiptDTO.preceiptslist[0].pledgername.ToUpper() + "(" + GeneralreceiptDTO.ppartyreferenceid + "_" + GeneralreceiptDTO.ppartyname.ToUpper() + ")"; } if (GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() != "CASH" && !string.IsNullOrEmpty(GeneralreceiptDTO.pmodofreceipt)) { sbGeneralReceipt.AppendLine("INSERT INTO tbltransreceiptreference( receiptid,bankname,branchname,transtype,typeofpayment,referencenumber,particulars,depositeddate,totalreceivedamount,depositstatus, clearstatus,statusid, createdby, createddate,cardnumber,cleardate,upiid,upiname,chequedate) VALUES ('" + ManageQuote(GeneralreceiptDTO.preceiptid) + "', '" + ManageQuote(GeneralreceiptDTO.pbankname).Trim().ToUpper() + "', '" + ManageQuote(GeneralreceiptDTO.pbranchname).Trim().ToUpper() + "', '" + ManageQuote(GeneralreceiptDTO.ptranstype).Trim().ToUpper() + "', '" + ManageQuote(GeneralreceiptDTO.ptypeofpayment).Trim().ToUpper() + "', '" + ManageQuote(GeneralreceiptDTO.pChequenumber).Trim().ToUpper() + "', '" + ManageQuote(particulars).Trim().ToUpper() + "', " + GeneralreceiptDTO.pchequedate + ", " + GeneralreceiptDTO.ptotalreceivedamount + ",'N', 'N', " + Convert.ToInt32(Status.Active) + "," + GeneralreceiptDTO.pCreatedby + ",current_timestamp,'" + ManageQuote(GeneralreceiptDTO.pCardNumber) + "'," + GeneralreceiptDTO.pchequedate + ",'" + ManageQuote(GeneralreceiptDTO.pUpiid) + "','" + ManageQuote(GeneralreceiptDTO.pUpiname).Trim().ToUpper() + "'," + GeneralreceiptDTO.pchequedate + ");"); } if (GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() == "CASH") { // JV Insert for Main Cash if (GeneralreceiptDTO.pistdsapplicable && GeneralreceiptDTO.ptdsamount > 0) { if (GeneralreceiptDTO.preceiptslist != null) { for (int i = 0; i < GeneralreceiptDTO.preceiptslist.Count; i++) { if (GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual > 0) { objJournalVoucherDTO = new JournalVoucherDTO(); List <PaymentsDTO> _Paymentslist = new List <PaymentsDTO>(); objJournalVoucherDTO.pjvdate = GeneralreceiptDTO.preceiptdate; objJournalVoucherDTO.pnarration = "BEING JV PASSED TOWARDS TDS AMOUNT"; objJournalVoucherDTO.pmodoftransaction = "AUTO"; objJournalVoucherDTO.pCreatedby = GeneralreceiptDTO.pCreatedby; objPaymentsDTO = new PaymentsDTO { ppartyid = GeneralreceiptDTO.ppartyid, ppartyname = GeneralreceiptDTO.ppartyname, ppartyreferenceid = GeneralreceiptDTO.ppartyreferenceid, ppartyreftype = GeneralreceiptDTO.ppartyreftype, ptranstype = "D", psubledgerid = GeneralreceiptDTO.preceiptslist[i].psubledgerid, pamount = GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual }; _Paymentslist.Add(objPaymentsDTO); objPaymentsDTO = new PaymentsDTO { ptranstype = "C", ppartyid = GeneralreceiptDTO.ppartyid, ppartyname = GeneralreceiptDTO.ppartyname, ppartyreferenceid = GeneralreceiptDTO.ppartyreferenceid, ppartyreftype = GeneralreceiptDTO.ppartyreftype }; long creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='CURRENT ASSETS' and statusid=" + Convert.ToInt32(Status.Active) + ";")); creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('TDS-" + GeneralreceiptDTO.pTdsSection + " RECEIVABLE'," + creditaccountid + ",'2'," + GeneralreceiptDTO.pCreatedby + ")")); creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + GeneralreceiptDTO.ppartyreferenceid + "_" + GeneralreceiptDTO.ppartyname.ToUpper() + "'," + creditaccountid + ",'3'," + GeneralreceiptDTO.pCreatedby + ")")); objPaymentsDTO.psubledgerid = creditaccountid; objPaymentsDTO.pamount = GeneralreceiptDTO.preceiptslist[i].ptdsamountindividual; _Paymentslist.Add(objPaymentsDTO); objJournalVoucherDTO.pJournalVoucherlist = _Paymentslist; string refjvnumber = ""; SaveJournalVoucher(objJournalVoucherDTO, trans, out refjvnumber); sbGeneralReceipt.AppendLine("update tbltransgeneralreceiptdetails set tdsrefjvnumber='" + refjvnumber + "',tdsaccountid=" + creditaccountid + " where receiptid='" + ManageQuote(GeneralreceiptDTO.preceiptid) + "' and creditaccountid=" + GeneralreceiptDTO.preceiptslist[i].psubledgerid + ";"); } } } } } else if (GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() == "BANK" || GeneralreceiptDTO.pmodofreceipt.Trim().ToUpper() == "WALLET") { if (!string.IsNullOrEmpty(GeneralreceiptDTO.ptranstype) && !string.IsNullOrEmpty(GeneralreceiptDTO.ptypeofpayment)) { sbGeneralReceipt.Append(SaveGeneralReceiptTransactions(trans, GeneralreceiptDTO)); } } if (!string.IsNullOrEmpty(GeneralreceiptDTO.preceiptid)) { sbGeneralReceipt.AppendLine("SELECT fntotaltransactions('" + GeneralreceiptDTO.preceiptid + "','GENERAL RECEIPT');"); // sbGeneralReceipt.AppendLine("select accountsupdate();"); } if (Convert.ToString(sbGeneralReceipt) != string.Empty) { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbGeneralReceipt.ToString()); Savedstatus = true; } } catch (Exception ex) { trans.Rollback(); throw ex; } return(Savedstatus); }
public string SaveGeneralReceiptTransactions_chequesclear(NpgsqlTransaction trans, GeneralreceiptDTO modelGeneralReceipt) { StringBuilder Sbbankonlinetrans = new StringBuilder(); try { long Bankaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select bankaccountid from tblmstbank where recordid=" + modelGeneralReceipt.pdepositbankid + " and statusid=" + Convert.ToInt32(Status.Active) + " ;")); Sbbankonlinetrans.AppendLine("update tbltransreceiptreference set depositstatus='P',clearstatus='Y',cleardate=" + modelGeneralReceipt.pchequedate + ", depositmodifiedby=" + modelGeneralReceipt.pCreatedby + ",depositmodifieddate=current_timestamp,clearedmodifiedby=" + modelGeneralReceipt.pCreatedby + ",clearedmodifieddate=current_timestamp where receiptid='" + ManageQuote(modelGeneralReceipt.preceiptid) + "';"); // Gen cheques Clear Transaction Id Generation if (modelGeneralReceipt.preceiptid.StartsWith("CHQ")) { string Genchequescleared_transactionno = NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "SELECT FN_GENERATENEXTID('CHEQUES IN BANK','','" + FormatDate(modelGeneralReceipt.preceiptdate) + "')").ToString(); long Genchequestransid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "insert into tbltransgenchequecleared(transactionno, transactiondate, receiptid, referencenumber, contactid, contactname, contactrefid, contactreftype, totalreceivedamount, tdssection, pannumber, tdscalculationtype, tdspercentage, tdsamount, tdsaccountid, statusid, createdby, createddate ) select '" + Genchequescleared_transactionno + "', " + modelGeneralReceipt.pchequedate + ", receiptid, '" + ManageQuote(modelGeneralReceipt.pChequenumber) + "', contactid, contactname, contactrefid, contactreftype, totalreceivedamount, tdssection, pannumber, tdscalculationtype, tdspercentage, tdsamount, tdsaccountid, " + Convert.ToInt32(Status.Active) + ", " + modelGeneralReceipt.pCreatedby + ", current_timestamp from tbltransgeneralreceipt where receiptid='" + ManageQuote(modelGeneralReceipt.preceiptid) + "' returning recordid;")); Sbbankonlinetrans.AppendLine("insert into tbltransgenchequecleareddetails( detailsid, transactionno, creditaccountid, ledgeramount, isgstapplicable, gsttype, gstcalculationtype, gstpercentage, gstnumber, stateid, statename, cgstaccountid, sgstaccountid, igstaccountid, utgstaccountid, igstamount, cgstamount, sgstamount, utgstamount,tdsaccountid, tdssection, tdspercentage, tdsamount) select " + Genchequestransid + ", '" + Genchequescleared_transactionno + "', creditaccountid, ledgeramount, isgstapplicable, gsttype, gstcalculationtype, gstpercentage, gstnumber, stateid, statename, cgstaccountid, sgstaccountid, igstaccountid, utgstaccountid, igstamount, cgstamount, sgstamount, utgstamount, tdsaccountid, tdssection, tdspercentage, tdsamount from tbltransgeneralreceiptdetails where receiptid='" + ManageQuote(modelGeneralReceipt.preceiptid) + "' ;"); if (!string.IsNullOrEmpty(Genchequescleared_transactionno)) { Sbbankonlinetrans.AppendLine("SELECT fntotaltransactions('" + Genchequescleared_transactionno + "','CHEQUESINBANK');"); } // JV Insert if (modelGeneralReceipt.pistdsapplicable && modelGeneralReceipt.ptdsamount > 0) { if (modelGeneralReceipt.preceiptslist != null) { for (int i = 0; i < modelGeneralReceipt.preceiptslist.Count; i++) { if (modelGeneralReceipt.preceiptslist[i].ptdsamountindividual > 0) { objJournalVoucherDTO = new JournalVoucherDTO(); List <PaymentsDTO> _Paymentslist = new List <PaymentsDTO>(); objJournalVoucherDTO.pjvdate = modelGeneralReceipt.preceiptdate; objJournalVoucherDTO.pCreatedby = modelGeneralReceipt.pCreatedby; objJournalVoucherDTO.pnarration = "BE JV PASSED TOWARDS TDS AMOUNT"; objJournalVoucherDTO.pmodoftransaction = "AUTO"; objPaymentsDTO = new PaymentsDTO { ppartyid = modelGeneralReceipt.ppartyid, ppartyname = modelGeneralReceipt.ppartyname, ppartyreferenceid = modelGeneralReceipt.ppartyreferenceid, ppartyreftype = modelGeneralReceipt.ppartyreftype, ptranstype = "D", psubledgerid = modelGeneralReceipt.preceiptslist[i].psubledgerid, pamount = modelGeneralReceipt.preceiptslist[i].ptdsamountindividual }; _Paymentslist.Add(objPaymentsDTO); objPaymentsDTO = new PaymentsDTO { ptranstype = "C", ppartyid = modelGeneralReceipt.ppartyid, ppartyname = modelGeneralReceipt.ppartyname, ppartyreferenceid = modelGeneralReceipt.ppartyreferenceid, ppartyreftype = modelGeneralReceipt.ppartyreftype }; long creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='OTHER CURRENT LIABILITIES' and statusid=" + Convert.ToInt32(Status.Active) + ";")); creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('TDS-" + modelGeneralReceipt.preceiptslist[i].ptdssection + " PAYABLE'," + creditaccountid + ",'2'," + modelGeneralReceipt.pCreatedby + ")")); creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + modelGeneralReceipt.ppartyreferenceid + "_" + modelGeneralReceipt.ppartyname + "'," + creditaccountid + ",'3'," + modelGeneralReceipt.pCreatedby + ")")); objPaymentsDTO.psubledgerid = creditaccountid; objPaymentsDTO.pamount = modelGeneralReceipt.preceiptslist[i].ptdsamountindividual; _Paymentslist.Add(objPaymentsDTO); objJournalVoucherDTO.pJournalVoucherlist = _Paymentslist; string refjvnumber = ""; SaveJournalVoucher(objJournalVoucherDTO, trans, out refjvnumber); Sbbankonlinetrans.AppendLine("update tbltransgeneralreceiptdetails set tdsrefjvnumber='" + refjvnumber + "',tdsaccountid=" + creditaccountid + " where receiptid='" + ManageQuote(modelGeneralReceipt.preceiptid) + "'" + "and creditaccountid=" + modelGeneralReceipt.preceiptslist[i].psubledgerid + ";"); Sbbankonlinetrans.AppendLine("update tbltransgenchequecleareddetails set tdsaccountid=" + creditaccountid + " where transactionno='" + ManageQuote(Genchequescleared_transactionno) + "' and creditaccountid=" + modelGeneralReceipt.preceiptslist[i].psubledgerid + ";"); } } } } } return(Convert.ToString(Sbbankonlinetrans)); } catch (Exception ex) { throw ex; } }
private void FrmPaymentMaintenance_Load(object sender, EventArgs e) { cbTransferee.Enabled = false; //eager load discounts lstDiscount = _assessmentService.GetDiscount(); var lstScholarshipRegular = lstDiscount.Where(x => x.DiscountTypeId == 6).ToList(); var lstScholarshipTransferee = lstDiscount.Where(x => x.DiscountTypeId == 5).ToList(); var lstEarlyBird = lstDiscount.Where(x => x.DiscountTypeId == 3).ToList(); //siblingDiscountType = lstSibling[0].DiscountTypeId; //referralDiscountType = lstReferral[0].DiscountTypeId; // combobox mode of payment PaymentsDTO payments = _paymentService.GetPaymentById(Global.selectedId); cmbModeOfPayment.DataSource = _paymentService.GetModeOfPayment(); cmbModeOfPayment.ValueMember = "ModeOfPaymentId"; cmbModeOfPayment.DisplayMember = "ModeOfPaymentDesc"; cmbModeOfPayment.SelectedIndex = 0; lblTransactionDate.Text = DateTime.Now.ToShortDateString(); //combobox payment term (first/second/third/fourth grading) //load the payments grid List <PaymentsDTO> lstPayments = _paymentService.GetPaymentsByStudentId(Global.selectedStudent); AssessmentDTO assessmentDTO = _assessmentService.GetAssessmentsDTO(Global.selectedStudent); var studPaymentBindingList = new BindingList <PaymentsDTO>(lstPayments); var studPaymentBindingSource = new BindingSource(studPaymentBindingList, null); //################### singit the textboxex ###################### var lstAssessment = _assessmentService.GetAssessment(Global.selectedStudent); txtMiscAmountDue.Text = lstAssessment.DeferredMisc.ToString(); txtTuitionAmountDue.Text = lstAssessment.PaymentPerDue.ToString(); txtTotalAmount.Text = (Convert.ToDouble(txtMiscAmountDue.Text) + Convert.ToDouble(txtMiscAmountDue.Text)).ToString("#.##"); //determine due dates lstDueDates = _dueDatesService.GetDueDates(lstAssessment.PaymentTerm); //get high and low for dates dateLow = lstDueDates.Where(x => x.DueDate <= DateTime.Now). OrderBy(x => x.DueDate).LastOrDefault().DueDate; dateHigh = lstDueDates.Where(x => x.DueDate >= DateTime.Now). OrderBy(x => x.DueDate).LastOrDefault().DueDate; if (lstPayments.Count >= 1) { // cbTransferee.Checked = assessmentDTO.isTransferree; //this is not downpayment } else //if no payment given yet, { cbDownpayment.Checked = true; penalizedFee = DateTime.Now > lstDueDates[0].DueDate ? Convert.ToDouble(txtTuitionAmountDue.Text) + ((Convert.ToDouble(txtTuitionAmountDue.Text) / 100) * 3.5) : 0; txtPenalty.Text = ((Convert.ToDouble(txtTuitionAmountDue.Text) / 100) * 3.5).ToString("#.##"); cbTransferee.Checked = false; } //payment term annual or downpayment and not late for anything (no penalty) if ((lstAssessment.PaymentTerm == 1 || cbDownpayment.Checked == true) && penalizedFee == 0) { //early bird discount TuitionDTO earlyBirdVal = lstDiscount.Where(x => x.DiscountTypeId == 3 && Convert.ToDateTime(x.DiscountParam) >= DateTime.Now). OrderBy(x => x.DiscountVal).LastOrDefault(); txtEarlyBird.Text = (Convert.ToDouble(earlyBirdVal.DiscountVal) * (lstAssessment.OriginalAmount) / 100).ToString("#.##"); lblEarlyBird.Visible = true; lblEarlyBird.Text = "Early Bird for " + Convert.ToDateTime(earlyBirdVal.DiscountParam).ToShortDateString() + " ," + (earlyBirdVal.DiscountVal) + "%"; txtTotalAmount.Text = (Convert.ToDouble(txtPenalty.Text) + Convert.ToDouble(txtTotalAmount.Text) - Convert.ToDouble(txtEarlyBird.Text)).ToString("#.##"); } else { lblEarlyBird.Visible = false; txtTotalAmount.Text = (Convert.ToDouble(txtPenalty.Text) + Convert.ToDouble(txtTotalAmount.Text) + Convert.ToDouble(txtMiscAmountDue.Text)).ToString("#.##"); } //txtTotalAmountBal.Text = (lstAssessment.FullAmount - (Convert.ToDouble(txtAmount.Text))).ToString("#.##"); txtTotalRemainingBal.Text = (lstAssessment.FullAmount).ToString("#.##"); PaymentsDTO lastPayment = lstPayments.LastOrDefault(); //txtRemainingMiscBal.Text =Convert.ToDouble(txtMiscAmountDue.Text) - lastPayment. //####################/till here ####################### pbStudent.Image = Image.FromFile(lstAssessment.path); dgvStudentPayments.AutoGenerateColumns = false; dgvStudentPayments.ColumnCount = 6; dgvStudentPayments.Columns[0].Name = "colAmount"; dgvStudentPayments.Columns[0].HeaderText = "Amount"; dgvStudentPayments.Columns[0].DataPropertyName = "Amount"; //dgvStudentPayments.Columns[1].Name = "colBank"; //dgvStudentPayments.Columns[1].HeaderText = "Bank"; //dgvStudentPayments.Columns[1].DataPropertyName = "BankName"; dgvStudentPayments.Columns[1].Name = "colModeOfPayment"; dgvStudentPayments.Columns[1].HeaderText = "Mode Of Payment"; dgvStudentPayments.Columns[1].DataPropertyName = "ModeOfPayment"; dgvStudentPayments.Columns[2].Name = "colTransactionDate"; dgvStudentPayments.Columns[2].HeaderText = "Transaction Date"; dgvStudentPayments.Columns[2].DataPropertyName = "TransactionDate"; dgvStudentPayments.Columns[3].Name = "colRemaniningBalance"; dgvStudentPayments.Columns[3].HeaderText = "Remaining Balance"; dgvStudentPayments.Columns[3].DataPropertyName = "Balance"; dgvStudentPayments.Columns[4].Name = "colOriginalBalance"; dgvStudentPayments.Columns[4].HeaderText = "Original Balance"; dgvStudentPayments.Columns[4].DataPropertyName = "OriginalBalance"; dgvStudentPayments.DataSource = studPaymentBindingSource; //fill the textboxes txtStudentName.Text = assessmentDTO.FirstName + " " + assessmentDTO.MiddleName.ToString() + " " + assessmentDTO.LastName.ToString(); txtStudentNo.Text = assessmentDTO.StudentNo; //txtBalance.Text = lstPayments[lstPayments.Count - 1].Balance.ToString(); //load payment term //cmbPaymentTerm.DataSource = _paymentService.GetDateParameters(); //cmbPaymentTerm.ValueMember = "DateParameterId"; //cmbPaymentTerm.DisplayMember = "DatesDescription"; //cmbPaymentTerm.SelectedIndex = -1; }
public bool SavePaymentVoucher_ALL(PaymentVoucherDTO _PaymentVoucherDTO, NpgsqlTransaction trans, string TransType, out string _PaymentId) { bool IsSaved = false; StringBuilder sbQuery = new StringBuilder(); try { if (string.IsNullOrEmpty(_PaymentVoucherDTO.ppaymentid)) { _PaymentVoucherDTO.ppaymentid = Convert.ToString(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "SELECT FN_GENERATENEXTID('PAYMENT VOUCHER','CASH','" + FormatDate(_PaymentVoucherDTO.ppaymentdate) + "')")); } long creditaccountid = 0; long tdsaccountid = 0; string query = ""; long detailsid = 0; if (_PaymentVoucherDTO.pmodofPayment == "CASH") { if (TransType == "SAVE") { creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='CASH ON HAND' and statusid=" + Convert.ToInt32(Status.Active) + ";")); } if (TransType == "CANCEL") { creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='CHEQUE ON HAND' and statusid=" + Convert.ToInt32(Status.Active) + ";")); } } else { creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select bankaccountid from tblmstbank where recordid = " + _PaymentVoucherDTO.pbankid)); } if (string.IsNullOrEmpty(_PaymentVoucherDTO.ptypeofoperation)) { _PaymentVoucherDTO.ptypeofoperation = "CREATE"; } if (_PaymentVoucherDTO.ptypeofoperation.ToUpper() == "CREATE") { query = "insert into tbltranspaymentvoucher( paymentid, paymentdate, modeofpayment, totalpaidamount, narration, creditaccountid, statusid, createdby, createddate,filename,filepath,fileformat)values('" + _PaymentVoucherDTO.ppaymentid + "', '" + FormatDate(_PaymentVoucherDTO.ppaymentdate) + "', '" + ManageQuote(_PaymentVoucherDTO.pmodofPayment) + "', " + _PaymentVoucherDTO.ptotalpaidamount + ", '" + ManageQuote(_PaymentVoucherDTO.pnarration) + "', " + creditaccountid + ", " + Convert.ToInt32(Status.Active) + ", " + _PaymentVoucherDTO.pCreatedby + ", current_timestamp,'" + ManageQuote(_PaymentVoucherDTO.pFilename) + "','" + ManageQuote(_PaymentVoucherDTO.pFilepath) + "','" + ManageQuote(_PaymentVoucherDTO.pFileformat) + "') returning recordid"; detailsid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, query)); } if (_PaymentVoucherDTO.ppaymentslist != null) { for (int i = 0; i < _PaymentVoucherDTO.ppaymentslist.Count; i++) { if (string.IsNullOrEmpty(_PaymentVoucherDTO.ppaymentslist[i].ptypeofoperation)) { _PaymentVoucherDTO.ppaymentslist[i].ptypeofoperation = "CREATE"; } if (_PaymentVoucherDTO.ppaymentslist[i].ptypeofoperation.ToUpper() == "CREATE") { if (!string.IsNullOrEmpty(_PaymentVoucherDTO.ppaymentslist[i].pState)) { if (_PaymentVoucherDTO.ppaymentslist[i].pState.Contains('-')) { string[] details = _PaymentVoucherDTO.ppaymentslist[i].pState.Split('-'); _PaymentVoucherDTO.ppaymentslist[i].pState = details[0].Trim(); _PaymentVoucherDTO.ppaymentslist[i].pgstno = details[1].Trim(); } } if (_PaymentVoucherDTO.ppaymentslist[i].ptdsamount > 0) { objJournalVoucherDTO = new JournalVoucherDTO(); List <PaymentsDTO> _Paymentslist = new List <PaymentsDTO>(); objJournalVoucherDTO.pjvdate = _PaymentVoucherDTO.ppaymentdate; objJournalVoucherDTO.pnarration = "BEING JV PASSED TOWARDS TDS AMOUNT"; objJournalVoucherDTO.pmodoftransaction = "AUTO"; objJournalVoucherDTO.pCreatedby = _PaymentVoucherDTO.pCreatedby; objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ppartyid = _PaymentVoucherDTO.ppaymentslist[i].ppartyid; objPaymentsDTO.ppartyname = _PaymentVoucherDTO.ppaymentslist[i].ppartyname; objPaymentsDTO.ppartyreferenceid = _PaymentVoucherDTO.ppaymentslist[i].ppartyreferenceid; objPaymentsDTO.ppartyreftype = _PaymentVoucherDTO.ppaymentslist[i].ppartyreftype; objPaymentsDTO.ptranstype = "C"; objPaymentsDTO.psubledgerid = _PaymentVoucherDTO.ppaymentslist[i].psubledgerid; objPaymentsDTO.pamount = _PaymentVoucherDTO.ppaymentslist[i].ptdsamount; _Paymentslist.Add(objPaymentsDTO); objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ptranstype = "D"; objPaymentsDTO.ppartyid = _PaymentVoucherDTO.ppaymentslist[i].ppartyid; objPaymentsDTO.ppartyname = _PaymentVoucherDTO.ppaymentslist[i].ppartyname; objPaymentsDTO.ppartyreferenceid = _PaymentVoucherDTO.ppaymentslist[i].ppartyreferenceid; objPaymentsDTO.ppartyreftype = _PaymentVoucherDTO.ppaymentslist[i].ppartyreftype; creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='OTHER CURRENT LIABILITIES' and statusid=" + Convert.ToInt32(Status.Active) + ";")); creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('TDS-" + _PaymentVoucherDTO.ppaymentslist[i].pTdsSection + " PAYABLE'," + creditaccountid + ",'2'," + _PaymentVoucherDTO.pCreatedby + ")")); creditaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + _PaymentVoucherDTO.ppaymentslist[0].ppartyreferenceid + "_" + _PaymentVoucherDTO.ppaymentslist[0].ppartyname.ToUpper() + "'," + creditaccountid + ",'3'," + _PaymentVoucherDTO.pCreatedby + ")")); objPaymentsDTO.psubledgerid = creditaccountid; objPaymentsDTO.pamount = _PaymentVoucherDTO.ppaymentslist[i].ptdsamount; _Paymentslist.Add(objPaymentsDTO); objJournalVoucherDTO.pJournalVoucherlist = _Paymentslist; string refjvnumber = ""; //objJournalVoucherDTO.pStatusid = Convert.ToInt32(Status.Active); SaveJournalVoucher(objJournalVoucherDTO, trans, out refjvnumber); _PaymentVoucherDTO.ppaymentslist[i].ptdsrefjvnumber = refjvnumber; tdsaccountid = creditaccountid; } sbQuery.Append("insert into tbltranspaymentvoucherdetails( detailsid, paymentid, contactid,contactname,contactrefid,contactreftype, debitaccountid, ledgeramount, isgstapplicable,gsttype,gstcalculationtype, gstpercentage, igstamount, cgstamount, sgstamount, utgstamount, tdssection, tdscalculationtype, tdspercentage, tdsamount, istdsapplicable,pannumber,gstnumber,stateid,statename,tdsrefjvnumber,tdsaccountid)values (" + detailsid + ", '" + _PaymentVoucherDTO.ppaymentid + "'," + _PaymentVoucherDTO.ppaymentslist[i].ppartyid + ", '" + _PaymentVoucherDTO.ppaymentslist[i].ppartyname + "', '" + _PaymentVoucherDTO.ppaymentslist[i].ppartyreferenceid + "', '" + _PaymentVoucherDTO.ppaymentslist[i].ppartyreftype + "', " + _PaymentVoucherDTO.ppaymentslist[i].psubledgerid + ", " + _PaymentVoucherDTO.ppaymentslist[i].pamount + ", '" + _PaymentVoucherDTO.ppaymentslist[i].pisgstapplicable + "', '" + _PaymentVoucherDTO.ppaymentslist[i].pgsttype + "', '" + _PaymentVoucherDTO.ppaymentslist[i].pgstcalculationtype + "', " + _PaymentVoucherDTO.ppaymentslist[i].pgstpercentage + ", " + _PaymentVoucherDTO.ppaymentslist[i].pigstamount + ", " + _PaymentVoucherDTO.ppaymentslist[i].pcgstamount + ", " + _PaymentVoucherDTO.ppaymentslist[i].psgstamount + ", " + _PaymentVoucherDTO.ppaymentslist[i].putgstamount + ", '" + _PaymentVoucherDTO.ppaymentslist[i].pTdsSection + "', '" + _PaymentVoucherDTO.ppaymentslist[i].ptdscalculationtype + "', " + _PaymentVoucherDTO.ppaymentslist[i].pTdsPercentage + ", " + _PaymentVoucherDTO.ppaymentslist[i].ptdsamount + ", " + _PaymentVoucherDTO.ppaymentslist[i].pistdsapplicable + ", '" + _PaymentVoucherDTO.ppaymentslist[i].ppartypannumber + "','" + ManageQuote(_PaymentVoucherDTO.ppaymentslist[i].pgstno) + "'," + _PaymentVoucherDTO.ppaymentslist[i].pStateId + ",'" + ManageQuote(_PaymentVoucherDTO.ppaymentslist[i].pState) + "','" + ManageQuote(_PaymentVoucherDTO.ppaymentslist[i].ptdsrefjvnumber) + "'," + tdsaccountid + ");"); } } } if (_PaymentVoucherDTO.pmodofPayment != "CASH") { string particulars = ""; if (_PaymentVoucherDTO.ppaymentslist.Count > 0) { if (!string.IsNullOrEmpty(_PaymentVoucherDTO.ppaymentslist[0].pledgername)) { particulars = _PaymentVoucherDTO.ppaymentslist[0].pledgername.ToUpper() + "(" + _PaymentVoucherDTO.ppaymentslist[0].ppartyreferenceid + "_" + _PaymentVoucherDTO.ppaymentslist[0].ppartyname.ToUpper() + ")"; } else { particulars = ""; } } if (_PaymentVoucherDTO.ppaymentslist.Count > 1) { particulars = particulars + "AND OTHER"; } if (string.IsNullOrEmpty(_PaymentVoucherDTO.ptypeofpayment)) { _PaymentVoucherDTO.ptypeofpayment = _PaymentVoucherDTO.ptranstype; } if (_PaymentVoucherDTO.pbankname.Contains('-')) { _PaymentVoucherDTO.pbankname = _PaymentVoucherDTO.pbankname.Split('-')[0].Trim(); } sbQuery.Append("insert into tbltranspaymentreference( paymentid, bankname, branchname, transtype, typeofpayment, bankid, chequenumber,cardnumber , upiid , upiname, paymentdate, paidamount, clearstatus, particulars, statusid, createdby, createddate ) values('" + _PaymentVoucherDTO.ppaymentid + "', '" + _PaymentVoucherDTO.pbankname + "', '" + _PaymentVoucherDTO.pbranchname + "', '" + _PaymentVoucherDTO.ptranstype + "', '" + _PaymentVoucherDTO.ptypeofpayment + "', " + _PaymentVoucherDTO.pbankid + ", '" + _PaymentVoucherDTO.pChequenumber + "', '" + _PaymentVoucherDTO.pCardNumber + "', '" + _PaymentVoucherDTO.pUpiid + "', '" + _PaymentVoucherDTO.pUpiname + "', '" + FormatDate(_PaymentVoucherDTO.ppaymentdate) + "', " + _PaymentVoucherDTO.ptotalpaidamount + ", 'N', '" + particulars + "', " + Convert.ToInt32(Status.Active) + ", " + _PaymentVoucherDTO.pCreatedby + ", current_timestamp);"); if (_PaymentVoucherDTO.ptypeofpayment == "CHEQUE") { sbQuery.Append("update tblmstcheques set statusid =(SELECT statusid from tblmststatus where upper(statusname) ='USED-CHEQUES') where bankid =" + _PaymentVoucherDTO.pbankid + " and chequenumber=" + _PaymentVoucherDTO.pChequenumber + ";"); } } if (!string.IsNullOrEmpty(sbQuery.ToString())) { sbQuery.Append("select fntotaltransactions('" + _PaymentVoucherDTO.ppaymentid + "','PAYMENT VOUCHER');"); //+"select accountsupdate();" NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbQuery.ToString()); IsSaved = true; } } catch (Exception ex) { throw ex; } _PaymentId = _PaymentVoucherDTO.ppaymentid; return(IsSaved); }
public bool Pay(PaymentsDTO request) { return(_PaymentsRepo.Pay(request.ClientId, request.ParentId, request.PaymentRequestId)); }
public bool CreateStudentPaymentRequest(PaymentsDTO request) { return(_PaymentsRepo.CreateStudentPaymentRequest(request.ClientId, request.PaymentRequestTypeId, request.StudentId, request.Amount, request.Details, request.DueDate)); }
public bool SaveJournalVoucher_All(JournalVoucherDTO _JournalVoucherDTO, string ConnectionString, out string jvnumber) { long accountid = 0; bool isSaved = false; string refjvnumber = ""; StringBuilder sbinsert = new StringBuilder(); objJournalVoucherDTO = new JournalVoucherDTO(); List <PaymentsDTO> _Paymentslist = new List <PaymentsDTO>(); try { con = new NpgsqlConnection(ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } trans = con.BeginTransaction(); if (_JournalVoucherDTO.pJournalVoucherlist != null) { objJournalVoucherDTO.pjvdate = _JournalVoucherDTO.pjvdate; objJournalVoucherDTO.pnarration = _JournalVoucherDTO.pnarration.ToUpper(); objJournalVoucherDTO.pmodoftransaction = "MANUAL"; objJournalVoucherDTO.pCreatedby = _JournalVoucherDTO.pCreatedby; for (int i = 0; i < _JournalVoucherDTO.pJournalVoucherlist.Count; i++) { objPaymentsDTO = new PaymentsDTO(); objPaymentsDTO.ppartyid = _JournalVoucherDTO.pJournalVoucherlist[i].ppartyid; objPaymentsDTO.ppartyname = _JournalVoucherDTO.pJournalVoucherlist[i].ppartyname; objPaymentsDTO.ppartyreferenceid = _JournalVoucherDTO.pJournalVoucherlist[i].ppartyreferenceid; objPaymentsDTO.ppartyreftype = _JournalVoucherDTO.pJournalVoucherlist[i].ppartyreftype; if (_JournalVoucherDTO.pJournalVoucherlist[i].ptranstype.ToUpper() == "CREDIT") { if (_JournalVoucherDTO.pJournalVoucherlist[i].ptdsamount > 0) { accountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='OTHER CURRENT LIABILITIES' and statusid=" + Convert.ToInt32(Status.Active) + ";")); accountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('TDS-" + _JournalVoucherDTO.pJournalVoucherlist[i].pTdsSection + " PAYABLE'," + accountid + ",'2'," + objJournalVoucherDTO.pCreatedby + ")")); accountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + _JournalVoucherDTO.pJournalVoucherlist[i].ppartyreferenceid + "_" + _JournalVoucherDTO.pJournalVoucherlist[i].ppartyname + "'," + accountid + ",'3'," + objJournalVoucherDTO.pCreatedby + ")")); } objPaymentsDTO.ptranstype = "C"; } if (_JournalVoucherDTO.pJournalVoucherlist[i].ptranstype.ToUpper() == "DEBIT") { if (_JournalVoucherDTO.pJournalVoucherlist[i].ptdsamount > 0) { accountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where upper(accountname)='OTHER CURRENT ASSETS' and statusid=" + Convert.ToInt32(Status.Active) + ";")); accountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('TDS-" + _JournalVoucherDTO.pJournalVoucherlist[i].pTdsSection + " RECEIVABLE'," + accountid + ",'2'," + objJournalVoucherDTO.pCreatedby + ")")); accountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + _JournalVoucherDTO.pJournalVoucherlist[i].ppartyreferenceid + "_" + _JournalVoucherDTO.pJournalVoucherlist[i].ppartyname + "'," + accountid + ",'3'," + objJournalVoucherDTO.pCreatedby + ")")); } objPaymentsDTO.ptranstype = "D"; } objPaymentsDTO.psubledgerid = _JournalVoucherDTO.pJournalVoucherlist[i].psubledgerid; objPaymentsDTO.pamount = _JournalVoucherDTO.pJournalVoucherlist[i].pamount; objPaymentsDTO.pgstcalculationtype = _JournalVoucherDTO.pJournalVoucherlist[i].pgstcalculationtype; objPaymentsDTO.pTdsSection = _JournalVoucherDTO.pJournalVoucherlist[i].pTdsSection; objPaymentsDTO.ptdscalculationtype = _JournalVoucherDTO.pJournalVoucherlist[i].ptdscalculationtype; objPaymentsDTO.pTdsPercentage = _JournalVoucherDTO.pJournalVoucherlist[i].pTdsPercentage; objPaymentsDTO.ptdsamount = _JournalVoucherDTO.pJournalVoucherlist[i].ptdsamount; objPaymentsDTO.pgstpercentage = _JournalVoucherDTO.pJournalVoucherlist[i].pgstpercentage; objPaymentsDTO.pigstamount = _JournalVoucherDTO.pJournalVoucherlist[i].pigstamount; objPaymentsDTO.pcgstamount = _JournalVoucherDTO.pJournalVoucherlist[i].pcgstamount; objPaymentsDTO.psgstamount = _JournalVoucherDTO.pJournalVoucherlist[i].psgstamount; objPaymentsDTO.putgstamount = _JournalVoucherDTO.pJournalVoucherlist[i].putgstamount; objPaymentsDTO.pistdsapplicable = _JournalVoucherDTO.pJournalVoucherlist[i].pistdsapplicable; objPaymentsDTO.pgstnumber = _JournalVoucherDTO.pJournalVoucherlist[i].pgstnumber; objPaymentsDTO.pStateId = _JournalVoucherDTO.pJournalVoucherlist[i].pStateId; objPaymentsDTO.pState = _JournalVoucherDTO.pJournalVoucherlist[i].pState; objPaymentsDTO.pgstno = _JournalVoucherDTO.pJournalVoucherlist[i].pgstno; objPaymentsDTO.pgsttype = _JournalVoucherDTO.pJournalVoucherlist[i].pgsttype; objPaymentsDTO.ptdsaccountId = accountid; _Paymentslist.Add(objPaymentsDTO); } objJournalVoucherDTO.pJournalVoucherlist = _Paymentslist; SaveJournalVoucher(objJournalVoucherDTO, trans, out refjvnumber); trans.Commit(); isSaved = true; } } catch (Exception ex) { trans.Rollback(); throw ex; } finally { if (con.State == ConnectionState.Open) { con.Dispose(); con.Close(); con.ClearPool(); trans.Dispose(); } } jvnumber = refjvnumber; return(isSaved); }
public FinancialDTO PaymentDetails(PaymentsDTO request) { return(_PaymentsRepo.PaymentDetails(request.ClientId, request.PaymentRequestId)); }
public bool SendBackToReview(PaymentsDTO request) { return(_PaymentsRepo.SendBackToReview(request.ClientId, request.ParentId, request.PaymentRequestId)); }
public bool ApprovePayment(PaymentsDTO request) { return(_PaymentsRepo.ApprovePayment(request.ClientId, request.ParentId, request.PaymentRequestId)); }