public object AproveOrRejectBranchCashout(TblPortalCashout tblPortalCashout, string evnt) { try { return(_FundTransferRepository.AproveOrRejectBranchCashout(tblPortalCashout, evnt)); } catch (Exception) { throw; } }
public object AproveOrRejectBranchCashout(TblPortalCashout tblPortalCashout, string evnt) { string successOrErrorMsg = null; try { using (var connection = this.GetConnection()) { string query = "Select Status from " + mainDbUser.DbUser + "Tbl_Portal_Cashout where Trans_no =" + "'" + tblPortalCashout.TransNo + "'"; string staus = connection.QueryFirstOrDefault <string>(query); if (staus == null) { var parameter = new OracleDynamicParameters(); parameter.Add("V_TRANS_NO", OracleDbType.Double, ParameterDirection.InputOutput, Convert.ToDouble(tblPortalCashout.TransNo)); parameter.Add("V_FR_PHONE", OracleDbType.Varchar2, ParameterDirection.Input, tblPortalCashout.Mphone); parameter.Add("V_BALANCE_TYPE", OracleDbType.Varchar2, ParameterDirection.Input, tblPortalCashout.BalanceType); parameter.Add("V_MSG_AMT", OracleDbType.Double, ParameterDirection.Input, tblPortalCashout.Amount); 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_TO_CATID", OracleDbType.Varchar2, ParameterDirection.Input, "BP"); parameter.Add("V_REF_PHONE", OracleDbType.Varchar2, ParameterDirection.Input, tblPortalCashout.BranchCode); parameter.Add("V_GATEWAY", OracleDbType.Varchar2, ParameterDirection.Input, tblPortalCashout.Gateway); parameter.Add("CheckBy", OracleDbType.Varchar2, ParameterDirection.Input, tblPortalCashout.CheckBy); if (evnt == "register") { //var result = SqlMapper.Query<dynamic>(connection, "SP_Branch_Cashout_Approve", param: parameter, commandType: CommandType.StoredProcedure); SqlMapper.Query(connection, mainDbUser.DbUser + "SP_Branch_Cashout_Approve", param: parameter, commandType: CommandType.StoredProcedure); } else { var result = SqlMapper.Query <dynamic>(connection, mainDbUser.DbUser + "SP_Branch_Cashout_Reject", param: parameter, commandType: CommandType.StoredProcedure); } connection.Close(); string flag = parameter.oracleParameters[5].Value != null ? parameter.oracleParameters[5].Value.ToString() : null; if (flag == "0") { successOrErrorMsg = parameter.oracleParameters[6].Value != null ? parameter.oracleParameters[6].Value.ToString() : null; } else { successOrErrorMsg = flag; } } else { successOrErrorMsg = "Failed"; } return(successOrErrorMsg); } } catch (Exception e) { throw; } }