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()));
}
}
