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