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