public object AproveOrRejectDisburseAmountPosting(string evnt, [FromBody] FundTransfer fundTransferModel) { string checkedUser = fundTransferModel.CheckUser; //fundTransferModel = _fundTransferService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "TransNo", new FundTransfer()); //fundTransferModel.CheckUser = checkedUser; TblDisburseAmtDtlMake objTblDisburseAmtDtlMake = new TblDisburseAmtDtlMake(); objTblDisburseAmtDtlMake = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "Tranno", new TblDisburseAmtDtlMake()); try { if (evnt == "register") { //fundTransferModel.Status = "A"; objTblDisburseAmtDtlMake.Status = "C"; objTblDisburseAmtDtlMake.CheckerId = checkedUser; objTblDisburseAmtDtlMake.CheckTime = System.DateTime.Now; var successOrErrorMsg = _disbursementService.DataInsertToTransMSTandDTL(objTblDisburseAmtDtlMake); if (successOrErrorMsg.ToString() == "1") { //Insert into audit trial audit and detail TblDisburseAmtDtlMake prevModel = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "Tranno", new TblDisburseAmtDtlMake()); prevModel.Status = "M";//insert for only audit trail _auditTrailService.InsertUpdatedModelToAuditTrail(objTblDisburseAmtDtlMake, prevModel, objTblDisburseAmtDtlMake.CheckerId, 10, 4, "Disburse Amount Posting", objTblDisburseAmtDtlMake.CompanyId.ToString(), "Approved Successfully!"); } return(successOrErrorMsg); } else if (evnt == "reject") { objTblDisburseAmtDtlMake.Status = "R"; objTblDisburseAmtDtlMake.CheckerId = checkedUser; objTblDisburseAmtDtlMake.CheckTime = System.DateTime.Now; _disburseAmtDtlMakeService.UpdateByStringField(objTblDisburseAmtDtlMake, "Tranno"); //Insert into audit trial audit and detail TblDisburseAmtDtlMake prevModel = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(fundTransferModel.TransNo, "Tranno", new TblDisburseAmtDtlMake()); prevModel.Status = "M";//insert for only audit trail _auditTrailService.InsertUpdatedModelToAuditTrail(objTblDisburseAmtDtlMake, prevModel, objTblDisburseAmtDtlMake.CheckerId, 10, 4, "Disburse Amount Posting", objTblDisburseAmtDtlMake.CompanyId.ToString(), "Rejected Successfully!"); return(true); } else { return(true); } } catch (Exception ex) { return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString())); } }
public object DataInsertToTransMSTandDTL(TblDisburseAmtDtlMake objTblDisburseAmtDtlMake) { try { return(_DisbursementRepository.DataInsertToTransMSTandDTL(objTblDisburseAmtDtlMake)); } catch (Exception ex) { throw; } }
public object saveCompanyLimit([FromBody] TblDisburseAmtDtlMake tblDisburseAmtDtlMake) { try { tblDisburseAmtDtlMake.Tranno = long.Parse(_distributorDepositService.GetTransactionNo()); tblDisburseAmtDtlMake.EntryDate = System.DateTime.Now; tblDisburseAmtDtlMake.MakeTime = System.DateTime.Now; tblDisburseAmtDtlMake.GlCode = "2020212"; tblDisburseAmtDtlMake.Status = "M"; _disburseAmtDtlMakeService.Add(tblDisburseAmtDtlMake); //Insert into audit trial audit and detail _auditTrailService.InsertModelToAuditTrail(tblDisburseAmtDtlMake, tblDisburseAmtDtlMake.MakerId, 10, 3, "Company Disbursement Limit", tblDisburseAmtDtlMake.CompanyId.ToString(), "Saved Successfully!"); } catch (Exception ex) { return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString())); } return(true); }
public object DataInsertToTransMSTandDTL(TblDisburseAmtDtlMake objTblDisburseAmtDtlMake) { try { using (var connection = this.GetConnection()) { var parameter = new OracleDynamicParameters(); parameter.Add("V_TRANS_NO", OracleDbType.Double, ParameterDirection.InputOutput, Convert.ToDouble(objTblDisburseAmtDtlMake.Tranno)); parameter.Add("V_TO_PHONE", OracleDbType.Varchar2, ParameterDirection.Input, objTblDisburseAmtDtlMake.AccNo); parameter.Add("V_MSG_AMT", OracleDbType.Double, ParameterDirection.Input, objTblDisburseAmtDtlMake.AmountCr); parameter.Add("MSGID", OracleDbType.Varchar2, ParameterDirection.Input, "999999999"); parameter.Add("V_FLAG", OracleDbType.Double, ParameterDirection.Output); parameter.Add("OUTMSG", OracleDbType.Varchar2, ParameterDirection.Output, null, 32767); parameter.Add("V_FROM_CATID", OracleDbType.Varchar2, ParameterDirection.Input, "S"); parameter.Add("V_REF_PHONE", OracleDbType.Varchar2, ParameterDirection.Input, objTblDisburseAmtDtlMake.BrCode); parameter.Add("CheckedUser", OracleDbType.Varchar2, ParameterDirection.Input, objTblDisburseAmtDtlMake.CheckerId); SqlMapper.Query <dynamic>(connection, mainDbUser.DbUser + "SP_Disburse_Amount_Posting", param: parameter, commandType: CommandType.StoredProcedure); connection.Close(); string flag = parameter.oracleParameters[4].Value != null ? parameter.oracleParameters[4].Value.ToString() : null; string successOrErrorMsg = null; if (flag == "0") { successOrErrorMsg = parameter.oracleParameters[5].Value != null ? parameter.oracleParameters[5].Value.ToString() : null; } else { successOrErrorMsg = flag; } return(successOrErrorMsg); } } catch (Exception e) { throw; } }
public object GetTransactionDetailsByTransactionNo(string transNo) { try { List <VMTransactionDetails> VMTransactionDetaillist = new List <VMTransactionDetails>(); if (string.IsNullOrEmpty(transNo)) { for (int i = 0; i < 6; i++) { VMTransactionDetails objVMTransactionDetails = new VMTransactionDetails(); objVMTransactionDetails.ACNo = ""; objVMTransactionDetails.GLCode = ""; objVMTransactionDetails.GLName = ""; objVMTransactionDetails.DebitAmount = 0; objVMTransactionDetails.CreditAmount = 0; VMTransactionDetaillist.Add(objVMTransactionDetails); } } else { TblDisburseAmtDtlMake objTblDisburseAmtDtlMake = new TblDisburseAmtDtlMake(); objTblDisburseAmtDtlMake = _disburseAmtDtlMakeService.SingleOrDefaultByCustomField(transNo, "Tranno", new TblDisburseAmtDtlMake()); for (int i = 0; i < 6; i++) { VMTransactionDetails objVMTransactionDetails = new VMTransactionDetails(); if (i == 0) { objVMTransactionDetails.DisburseAC = objTblDisburseAmtDtlMake.AccNo; objVMTransactionDetails.Company = _disbursementService.GetCompnayNameById(objTblDisburseAmtDtlMake.CompanyId).ToString(); objVMTransactionDetails.ACNo = ""; objVMTransactionDetails.GLCode = "1010101"; objVMTransactionDetails.GLName = "CASH IN HAND-LOCAL CURRENCY"; objVMTransactionDetails.DebitAmount = objTblDisburseAmtDtlMake.AmountCr; objVMTransactionDetails.CreditAmount = 0; } else if (i == 1) { objVMTransactionDetails.ACNo = ""; objVMTransactionDetails.GLCode = "2020212"; objVMTransactionDetails.GLName = "ENTERPRISE DEPOSIT"; objVMTransactionDetails.DebitAmount = 0; objVMTransactionDetails.CreditAmount = objTblDisburseAmtDtlMake.AmountCr; } else { objVMTransactionDetails.ACNo = ""; objVMTransactionDetails.GLCode = ""; objVMTransactionDetails.GLName = ""; objVMTransactionDetails.DebitAmount = 0; objVMTransactionDetails.CreditAmount = 0; } VMTransactionDetaillist.Add(objVMTransactionDetails); } } double totalDebitAmt = 0; double totalCreditAmt = 0; foreach (var item in VMTransactionDetaillist) { totalDebitAmt += item.DebitAmount; totalCreditAmt += item.CreditAmount; } VMTransactionDetails obj = new VMTransactionDetails(); obj.GLCode = ""; obj.GLName = "Total :"; obj.DebitAmount = totalDebitAmt; obj.CreditAmount = totalCreditAmt; string totalAmt = totalDebitAmt.ToString("N2"); NumericWordConversion numericWordConversion = new NumericWordConversion(); obj.InWords = numericWordConversion.InWords(Convert.ToDecimal(totalAmt)); VMTransactionDetaillist.Add(obj); return(VMTransactionDetaillist); } catch (Exception ex) { return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString())); } }