public object saveTtalkTopupStockEntry(RobiTopupStockEntry ttalkTopupStockEntry) { try { return(_FundTransferRepository.saveTtalkTopupStockEntry(ttalkTopupStockEntry)); } catch (Exception) { throw; } }
public object saveAirtelTopupStockEntry(RobiTopupStockEntry robiTopupStockEntry) { try { return(_FundTransferRepository.saveAirtelTopupStockEntry(robiTopupStockEntry)); } catch (Exception) { throw; } }
public object saveTtalkTopupStockEntry(RobiTopupStockEntry ttalkTopupStockEntry) { string successOrErrorMsg = null; try { using (var connection = this.GetConnection()) { // string newID = ""; var parameter = new OracleDynamicParameters(); parameter.Add("V_TYPE", OracleDbType.Varchar2, ParameterDirection.Input, "A2G"); parameter.Add("V_DR_AC_GL", OracleDbType.Varchar2, ParameterDirection.Input, "01513907020"); parameter.Add("V_CR_AC_GL", OracleDbType.Varchar2, ParameterDirection.Input, "A40000000218"); parameter.Add("V_AMT", OracleDbType.Double, ParameterDirection.Input, ttalkTopupStockEntry.TransactionAmt); parameter.Add("V_HOTKEY", OracleDbType.Varchar2, ParameterDirection.Input, ttalkTopupStockEntry.Hotkey); parameter.Add("V_FLAG", OracleDbType.Double, ParameterDirection.Output); parameter.Add("V_ENTRY_USER", OracleDbType.Varchar2, ParameterDirection.Input, ttalkTopupStockEntry.EntryUser); parameter.Add("V_PARTICULAR", OracleDbType.Varchar2, ParameterDirection.Input); SqlMapper.Query <string>(connection, mainDbUser.DbUser + "PROC_BASIC_TRANSACTION_V2", param: parameter, commandType: CommandType.StoredProcedure).FirstOrDefault(); //string newID = parameter.<string>("V_FLAG"); string transactionNo = parameter.oracleParameters[5].Value != null ? parameter.oracleParameters[5].Value.ToString() : null; if (transactionNo != null) { //parameter.oracleParameters[1].Value = robiTopupStockEntry.FromSysCoaCode; parameter.oracleParameters[1].Value = "01513907020"; parameter.oracleParameters[2].Value = "L40000000220"; parameter.oracleParameters[3].Value = ttalkTopupStockEntry.RowThreeFour; parameter.Add("P_TRANS_NO", OracleDbType.Varchar2, ParameterDirection.Input, transactionNo); parameter.Add("V_TRANS_SL_NO", OracleDbType.Int32, ParameterDirection.Input, 3); SqlMapper.Query <dynamic>(connection, mainDbUser.DbUser + "PROC_BASIC_TRANSACTION_V2", param: parameter, commandType: CommandType.StoredProcedure); transactionNo = parameter.oracleParameters[5].Value != null ? parameter.oracleParameters[5].Value.ToString() : null; if (transactionNo != null) { parameter.oracleParameters[0].Value = "G2G"; parameter.oracleParameters[1].Value = "A40000000137"; parameter.oracleParameters[2].Value = "L40000000220"; parameter.oracleParameters[3].Value = ttalkTopupStockEntry.RowFiveSix; parameter.oracleParameters[8].Value = transactionNo; parameter.oracleParameters[9].Value = 5; SqlMapper.Query <dynamic>(connection, mainDbUser.DbUser + "PROC_BASIC_TRANSACTION_V2", param: parameter, commandType: CommandType.StoredProcedure); } } connection.Close(); string flag = parameter.oracleParameters[5].Value != null ? parameter.oracleParameters[5].Value.ToString() : null; if (flag == "0") { successOrErrorMsg = "Failed"; } else { //successOrErrorMsg = "1"; successOrErrorMsg = transactionNo; } return(successOrErrorMsg); } } catch (Exception e) { throw; } }