public object saveCommiConvert(BranchCashIn branchCashIn) { try { return(_FundTransferRepository.saveCommiConvert(branchCashIn)); } catch (Exception) { throw; } }
public object saveCommiConvert(BranchCashIn branchCashIn) { try { using (var connection = this.GetConnection()) { var parameter = new OracleDynamicParameters(); parameter.Add("V_TRANS_NO", OracleDbType.Double, ParameterDirection.InputOutput, Convert.ToDouble(branchCashIn.TransNo)); parameter.Add("V_TO_PHONE", OracleDbType.Varchar2, ParameterDirection.Input, branchCashIn.Mphone); parameter.Add("V_MSG_AMT", OracleDbType.Double, ParameterDirection.Input, branchCashIn.CashInAmount); 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, "BP"); parameter.Add("V_REF_PHONE", OracleDbType.Varchar2, ParameterDirection.Input, branchCashIn.BranchCode); parameter.Add("CheckedUser", OracleDbType.Varchar2, ParameterDirection.Input, branchCashIn.CheckedUser); SqlMapper.Query <dynamic>(connection, mainDbUser.DbUser + "SP_Insert_Portal_CashIn", 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; } }