public Approval ConvertDTOToEntity(ApprovalDTO dto) => new Approval( dto.Id, dto.Description, dto.IsApproved, _doctorConverter.ConvertDTOToEntity(dto.Doctor), ConvertDTOToEntity(dto.Proposition) );
public IActionResult Put([FromBody] ApprovalDTO approvalDTO) { if (!ModelState.IsValid) { NotifyModelStateErrors(); return(Response()); } _approvalAppService.Update(approvalDTO); return(Response(approvalDTO)); }
public IActionResult Saveapprovedapplications(ApprovalDTO ApprovalList) { bool isSaved; try { isSaved = ObjApproval.Saveapprovedapplications(ApprovalList, Con); } catch (Exception ex) { throw new FinstaAppException(ex.ToString()); } return(Ok(isSaved)); }
public List <ApprovalDTO> Getapprovedapplications(string Applicationid, string ConnectionString) { ApprovalDTO objApprovedetails = new ApprovalDTO(); lstApprovedetails = new List <ApprovalDTO>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select * from tbltransapprovedapplications WHERE VCHAPPLICATIONID='" + ManageQuote(Applicationid) + "'")) { while (dr.Read()) { objApprovedetails.pApplicationid = Convert.ToInt64(dr["Applicationid"]); objApprovedetails.pVchapplicationid = dr["Vchapplicationid"].ToString(); objApprovedetails.pApproveddate = Convert.ToDateTime(dr["Approveddate"]); objApprovedetails.pApprovedby = Convert.ToInt64(dr["Approvedby"]); objApprovedetails.pAmountrequested = Convert.ToDecimal(dr["Amountrequested"]); objApprovedetails.pApprovedloanamount = Convert.ToDecimal(dr["Approvedloanamount"]); objApprovedetails.pLoanpayin = dr["Loanpayin"].ToString(); objApprovedetails.pInteresttype = dr["Interesttype"].ToString(); objApprovedetails.pRateofinterest = Convert.ToDecimal(dr["Rateofinterest"]); objApprovedetails.pTenureofloan = Convert.ToDecimal(dr["Tenureofloan"]); objApprovedetails.pTenuretype = dr["Tenuretype"].ToString(); objApprovedetails.pVchaccintrest = Convert.ToDecimal(dr["Vchaccintrest"]); objApprovedetails.pLoaninstalmentpaymentmode = dr["Loaninstalmentpaymentmode"].ToString(); objApprovedetails.pOldInstallmentstartdate = Convert.ToDateTime(dr["OldInstallmentstartdate"]); objApprovedetails.pInstallmentamount = Convert.ToDecimal(dr["Vchaccintrest"]); objApprovedetails.pInstallmentstartdate = Convert.ToDateTime(dr["Installmentstartdate"]); objApprovedetails.pHolidayperiodpayin = dr["Holidayperiodpayin"].ToString(); objApprovedetails.pHolidayperiodvalue = Convert.ToDecimal(dr["Holidayperiodvalue"]); objApprovedetails.pMoratoriumperiodpayin = dr["Moratoriumperiodpayin"].ToString(); objApprovedetails.pMoratoriumperiodvalue = Convert.ToDecimal(dr["Moratoriumperiodvalue"]); objApprovedetails.pRemarks = dr["Remarks"].ToString(); objApprovedetails.pDisbursementpayinmode = dr["Disbursementpayinmode"].ToString(); objApprovedetails.pGraceperiod = Convert.ToDecimal(dr["Graceperiod"]); objApprovedetails.lstStagewisepayments = GetApprovelsStagewise(Applicationid, ConnectionString); objApprovedetails.lstApprovedloancharges = GetApprovelscharges(Applicationid, ConnectionString); lstApprovedetails.Add(objApprovedetails); } } } catch (Exception ex) { throw ex; } return(lstApprovedetails); }
private void Saveapprovalpaymentstages(ApprovalDTO ApprovalList, string Connectionstring, StringBuilder sbinsert) { try { if (ApprovalList.lstStagewisepayments != null) { for (int i = 0; i < ApprovalList.lstStagewisepayments.Count; i++) { if (ApprovalList.lstStagewisepayments[i].ptypeofoperation == "CREATE") { sbinsert.Append("insert into tbltransapprovalpaymentstages(applicationid,vchapplicationid,stageno,stagename,paymentreleasetype,paymentreleasepercentage,paymentreleaseamount,statusid,createdby,createddate)values(" + ApprovalList.pApplicationid + ",'" + ApprovalList.pVchapplicationid + "','" + ManageQuote(ApprovalList.lstStagewisepayments[i].pStageno) + "','" + ManageQuote(ApprovalList.lstStagewisepayments[i].pStagename) + "','" + ManageQuote(ApprovalList.lstStagewisepayments[i].pPaymentreleasetype) + "'," + ApprovalList.lstStagewisepayments[i].pPaymentreleasepercentage + "," + ApprovalList.lstStagewisepayments[i].pPaymentreleaseamount + ",1," + ApprovalList.pCreatedby + ",current_timestamp);"); } if (ApprovalList.lstStagewisepayments[i].ptypeofoperation == "UPDATE") { } } } } catch (Exception ex) { throw ex; } }
private void SaveApprovelcharges(ApprovalDTO ApprovalList, string Connectionstring, StringBuilder sbinsert) { try { if (ApprovalList.lstApprovedloancharges != null) { for (int i = 0; i < ApprovalList.lstApprovedloancharges.Count; i++) { if (ApprovalList.lstApprovedloancharges[i].ptypeofoperation == "CREATE") { sbinsert.Append(" insert into tbltransapprovedloancharges(applicationid, vchapplicationid, chargestype, chargename, chargereceivableamount, chargewaiveoffamount, chargepaymentmode, statusid, createdby, createddate,gsttype,gstcalculationtype,gstpercentage,gstamount,totalchargeamount,igstamount,cgstamount,sgstamount,utgstamount,chargeamount)values(" + ApprovalList.pApplicationid + ",'" + ApprovalList.pVchapplicationid + "','" + ManageQuote(ApprovalList.lstApprovedloancharges[i].pChargestype) + "','" + ManageQuote(ApprovalList.lstApprovedloancharges[i].pChargename) + "'," + ApprovalList.lstApprovedloancharges[i].pChargereceivableamount + "," + ApprovalList.lstApprovedloancharges[i].pChargewaiveoffamount + ",'" + ManageQuote(ApprovalList.lstApprovedloancharges[i].pChargepaymentmode) + "',1," + ApprovalList.pCreatedby + ",current_timestamp,'" + ManageQuote(ApprovalList.lstApprovedloancharges[i].pGsttype) + "','" + ManageQuote(ApprovalList.lstApprovedloancharges[i].pGstcaltype) + "'," + ApprovalList.lstApprovedloancharges[i].pGstpercentage + "," + ApprovalList.lstApprovedloancharges[i].pTotalgstamount + "," + ApprovalList.lstApprovedloancharges[i].pTotalchargeamount + "," + ApprovalList.lstApprovedloancharges[i].pIgstamount + "," + ApprovalList.lstApprovedloancharges[i].pCgstamount + "," + ApprovalList.lstApprovedloancharges[i].pSgstamount + "," + ApprovalList.lstApprovedloancharges[i].pUtgstamount + "," + ApprovalList.lstApprovedloancharges[i].pActualchargeamount + ");"); } if (ApprovalList.lstApprovedloancharges[i].ptypeofoperation == "UPDATE") { //sbinsert.Append("update tbltransapprovedloancharges"); } } } } catch (Exception ex) { throw ex; } }
public UserBackendDTO AddRequsetsTasksCountToSynchResponse(List <RequestEntity> userbackendrequestslist, List <ApprovalEntity> userbackendapprovalslist, UserBackendEntity userbackend, SynchRequestDTO query, UserBackendDTO userbackenddto) { string callerMethodName = string.Empty; try { //Get Caller Method name from CallerInformation class callerMethodName = CallerInformation.TrackCallerMethodName(); List <ApprovalRequestDTO> approvalrequestlist = new List <ApprovalRequestDTO>(); InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: Loop through all requests in backend"); //loop through each request in the userbackend foreach (RequestEntity request in userbackendrequestslist) { ApprovalRequestDTO approvalrequest = new ApprovalRequestDTO(); RequestDTO requestdto = new RequestDTO(); //get approval associated to request ApprovalEntity approval = userbackendapprovalslist.Find(x => x.RequestId == request.ID); if (approval != null) { ApprovalDTO approvaldto = new ApprovalDTO(); approvaldto = DataProvider.ResponseObjectMapper <ApprovalDTO, ApprovalEntity>(approval); approvalrequest.approval = approvaldto; userbackenddto.approvalsCount.Count = userbackenddto.approvalsCount.Count + 1; //if request is updated if (Rules.IsRequestUpdated(request, userbackend.DefaultUpdateFrequency)) { InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: check request update, response: true"); //get request synch entity RequestSynchEntity requestsynch = GetRequestSynch(request); //check if requests which have changed since the last synch need to send in response or all requests. if (Rules.IsTargetRequest(query, request, approval, requestsynch)) { InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: Target request, response: true"); requestdto = DataProvider.ResponseObjectMapper <RequestDTO, RequestEntity>(request); approvalrequest.request = requestdto; InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: add request header to response, response: success"); //code here to populate extended depth //code here to update request synch time stamp AddUpdateRequestSynch(request, requestsynch, query.userId); InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: Update request synch timestamp, response: success"); //requestsfulfilled = true; } } else { InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: check request update, response: false"); //check if request update is in progress in service layer then send the latency in response if (Rules.IsRequestUpdateInProgress(request)) { InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: update in-progress, response: true"); approvalrequest.retryAfter = request.ExpectedLatency; InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: Add expected request latancy to resposne as retry time, response: Success"); } else { InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: update in-progress, response: false"); TriggerRequestUpdate(request, query.userId); InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: trigger a Request update, response: success"); approvalrequest.retryAfter = Convert.ToInt32(Rules.RequestRetryTime(userbackend)); InsightLogger.TrackEvent("SyncAPIController :: endpoint - api/synch/users/{userID}/backends, action: Add request retrytime to response, response: success"); } //requestsunfulfilled = true; } //add approval request to list which will be added to corresponding backend approvalrequestlist.Add(approvalrequest); } } userbackenddto.requests = approvalrequestlist; return(userbackenddto); } catch (DataAccessException DALexception) { throw DALexception; } catch (Exception exception) { InsightLogger.Exception(exception.Message, exception, callerMethodName); //LoggerHelper.WriteToLog(exception + " - Error in BL while adding all approvals count to response : " //+ exception.ToString(), CoreConstants.Priority.High, CoreConstants.Category.Error); throw new BusinessLogicException(); } }
public bool Saveapprovedapplications(ApprovalDTO ApprovalList, string Connectionstring) { StringBuilder sbinsert = new StringBuilder(); string Approvestatus = string.Empty; bool IsSaved = false; try { con = new NpgsqlConnection(Connectionstring); if (con.State != ConnectionState.Open) { con.Open(); } trans = con.BeginTransaction(); //Approvestatus = NPGSqlHelper.ExecuteScalar(Connectionstring, CommandType.Text, "select approvedpersonstatus from tblmstapprovalpersons t1 join tblmstusers t2 on contactrefid=contactreferenceid where userid=" + ApprovalList.pCreatedby + ";").ToString(); Approvestatus = NPGSqlHelper.ExecuteScalar(Connectionstring, CommandType.Text, "select approvedpersonstatus from tblmstapprovalpersons;").ToString(); if (Approvestatus == "Approved") { if (ApprovalList.papprovestatus == "Approve") { if (ApprovalList.lstStagewisepayments.Count > 0 && ApprovalList.pDisbursementpayinmode.ToUpper() == "SINGLE PAYMENT") { ApprovalList.pDisbursementpayinmode = "Stage Payment"; } sbinsert.Append("insert into tbltransapprovedapplications(applicationid,vchapplicationid,approveddate,approvedby,amountrequested,approvedloanamount,loanpayin,interesttype,rateofinterest,tenureofloan,tenuretype,vchaccintrest,loaninstalmentpaymentmode,Installmentamount,holidayperiodpayin,holidayperiodvalue,moratoriumperiodpayin,moratoriumperiodvalue,remarks,disbursementpayinmode,graceperiod,statusid, createdby, createddate,loantypeid,loantype,loanid,loanname,partprinciplepaidinterval)values(" + ApprovalList.pApplicationid + ",'" + ApprovalList.pVchapplicationid + "','" + FormatDate(ApprovalList.pApproveddate.ToString()) + "'," + ApprovalList.pApprovedby + "," + ApprovalList.pAmountrequested + "," + ApprovalList.pApprovedloanamount + ",'" + ManageQuote(ApprovalList.pLoanpayin) + "','" + ManageQuote(ApprovalList.pInteresttype) + "'," + ApprovalList.pRateofinterest + "," + ApprovalList.pTenureofloan + ",'" + ManageQuote(ApprovalList.pTenuretype) + "'," + ApprovalList.pVchaccintrest + ",'" + ManageQuote(ApprovalList.pLoaninstalmentpaymentmode) + "'," + ApprovalList.pInstallmentamount + ",'" + ManageQuote(ApprovalList.pHolidayperiodpayin) + "'," + ApprovalList.pHolidayperiodvalue + ",'" + ManageQuote(ApprovalList.pMoratoriumperiodpayin) + "'," + ApprovalList.pMoratoriumperiodvalue + ",'" + ManageQuote(ApprovalList.pRemarks) + "','" + ManageQuote(ApprovalList.pDisbursementpayinmode) + "'," + ApprovalList.pGraceperiod + ",1," + ApprovalList.pCreatedby + ",current_timestamp," + ApprovalList.pLoantypeid + ",'" + ManageQuote(ApprovalList.pLoantype) + "'," + ApprovalList.pLoanid + ",'" + ManageQuote(ApprovalList.pLoanname) + "'," + ApprovalList.pInterevels + ");"); Saveacceptedorrejectedapplications(ApprovalList, Connectionstring, sbinsert); Saveapprovalpaymentstages(ApprovalList, Connectionstring, sbinsert); SaveApprovelcharges(ApprovalList, Connectionstring, sbinsert); sbinsert.Append("update tabapplication set loanstatus='Loan Approved',loanstatusid=" + Convert.ToInt32(Status.Loan_Approved) + ",approvaldate='" + FormatDate(ApprovalList.pApproveddate.ToString()) + "' where vchapplicationid='" + ApprovalList.pVchapplicationid + "'"); } if (ApprovalList.papprovestatus == "Reject") { Saveacceptedorrejectedapplications(ApprovalList, Connectionstring, sbinsert); sbinsert.Append("update tabapplication set loanstatus='Loan Rejected',loanstatusid=" + Convert.ToInt32(Status.Loan_Rejected) + ",approvaldate='" + FormatDate(ApprovalList.pApproveddate.ToString()) + "' where vchapplicationid='" + ApprovalList.pVchapplicationid + "'"); } } if (Approvestatus == "Accepted") { Saveacceptedorrejectedapplications(ApprovalList, Connectionstring, sbinsert); sbinsert.Append("update tabapplication set loanstatus='Loan Accepted',loanstatusid=11,approvaldate='" + FormatDate(ApprovalList.pApproveddate.ToString()) + "' where vchapplicationid='" + ApprovalList.pVchapplicationid + "'"); } if (!string.IsNullOrEmpty(sbinsert.ToString())) { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbinsert.ToString()); } 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(); } } return(IsSaved); }
private void Saveacceptedorrejectedapplications(ApprovalDTO ApprovalList, string Connectionstring, StringBuilder sbinsert) { sbinsert.Append("insert into tbltransacceptedorrejectedapplications(applicationid,vchapplicationid,approveddate,approvedby,amountrequested,approvedloanamount,loanpayin,interesttype,rateofinterest,tenureofloan,tenuretype,vchaccintrest,loaninstalmentpaymentmode,oldInstallmentstartdate,Installmentamount,Installmentstartdate,holidayperiodpayin,holidayperiodvalue,moratoriumperiodpayin,moratoriumperiodvalue,remarks,disbursementpayinmode,graceperiod,statusid, createdby, createddate)values(" + ApprovalList.pApplicationid + ",'" + ApprovalList.pVchapplicationid + "','" + FormatDate(ApprovalList.pApproveddate.ToString()) + "'," + ApprovalList.pApprovedby + "," + ApprovalList.pAmountrequested + "," + ApprovalList.pApprovedloanamount + ",'" + ManageQuote(ApprovalList.pLoanpayin) + "','" + ManageQuote(ApprovalList.pInteresttype) + "'," + ApprovalList.pRateofinterest + "," + ApprovalList.pTenureofloan + ",'" + ManageQuote(ApprovalList.pTenuretype) + "'," + ApprovalList.pVchaccintrest + ",'" + ManageQuote(ApprovalList.pLoaninstalmentpaymentmode) + "','" + FormatDate(ApprovalList.pOldInstallmentstartdate.ToString()) + "'," + ApprovalList.pInstallmentamount + ",'" + FormatDate(ApprovalList.pInstallmentstartdate.ToString()) + "','" + ManageQuote(ApprovalList.pHolidayperiodpayin) + "'," + ApprovalList.pHolidayperiodvalue + ",'" + ManageQuote(ApprovalList.pMoratoriumperiodpayin) + "'," + ApprovalList.pMoratoriumperiodvalue + ",'" + ManageQuote(ApprovalList.pRemarks) + "','" + ManageQuote(ApprovalList.pDisbursementpayinmode) + "'," + ApprovalList.pGraceperiod + ",1," + ApprovalList.pCreatedby + ",current_timestamp);"); }