public string TransactionFundInsertBaseLine([FromBody] Payload payload)
{
try {
var tranDto = new TransactionDTOReq();
var payLoads = payload.xmlData.Split(",").Select(x => x.Trim()).ToArray();
tranDto.SenderBankSwiftCode = payLoads[0];
tranDto.SenderVID = payLoads[1];
tranDto.ReceiverVID = payLoads[2];
tranDto.Amount = payLoads[3];
tranDto.ChannelName = payLoads[4];
tranDto.DeviceID = payLoads[5];
tranDto.MobileNumber = payLoads[6];
tranDto.LatLong = payLoads[7];
tranDto.IPAddress = payLoads[8];
tranDto.IDTPPIN = payLoads[9];
tranDto.EndToEndID = payLoads[10];
tranDto.SendingBankTxId = payLoads[11];
tranDto.SendingBankReference = payLoads[12];
tranDto.MessageID = payLoads[13];
string IdtpRef = "IDTP" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
tranDto.SenderAccNo = "ACC123";
tranDto.ReceiverAccNo = "ACC345";
tranDto.SendingBankRoutingNo = "123456";
tranDto.ReceivingBankRoutingNo = "123456";
tranDto.SenderBankId = 1;
tranDto.ReceiverBankId = 2;
tranDto.PaymentNote = "Payment Note";
tranDto.ReferenceIDTP = IdtpRef;
tranDto.TransactionTypeId = "1";
tranDto.SenderId = 1;
tranDto.ReceiverId = 2;
tranDto.FeeAmount = "0";
tranDto.VATAmount = "0";
tranDto.SendingPSPReference = "";
tranDto.ReceivingBankReference = "";
tranDto.ReceivingPSPReference = "";
DBUtility.TransferFundFinalSp(tranDto);
return("Insert successfull");
}
catch (Exception e) {
return(e.Message);
}
}
public static void TransferFundFinalSp(TransactionDTOReq transactionDTO)
{
try {
string spname = "AddTransaction_V2";
using (SqlConnection connection = new SqlConnection(ConnectionString)) {
connection.Open();
SqlCommand sql_cmnd = new SqlCommand(spname, connection);
sql_cmnd.CommandType = CommandType.StoredProcedure;
#region params
sql_cmnd.Parameters.AddWithValue("@SenderAccNo", SqlDbType.VarChar).Value = transactionDTO.SenderAccNo;
sql_cmnd.Parameters.AddWithValue("@ReceiverAccNo", SqlDbType.VarChar).Value = transactionDTO.ReceiverAccNo;
sql_cmnd.Parameters.AddWithValue("@Amount", SqlDbType.Decimal).Value = Convert.ToDecimal(transactionDTO.Amount);
sql_cmnd.Parameters.AddWithValue("@PaymentNote", SqlDbType.VarChar).Value = transactionDTO.PaymentNote;
sql_cmnd.Parameters.AddWithValue("@EndToEndID", SqlDbType.VarChar).Value = transactionDTO.EndToEndID;
sql_cmnd.Parameters.AddWithValue("@MessageID", SqlDbType.VarChar).Value = transactionDTO.MessageID;
sql_cmnd.Parameters.AddWithValue("@SendingBankRoutingNo", SqlDbType.VarChar).Value = transactionDTO.SendingBankRoutingNo;
sql_cmnd.Parameters.AddWithValue("@ReceivingBankRoutingNo", SqlDbType.VarChar).Value = transactionDTO.ReceivingBankRoutingNo;
sql_cmnd.Parameters.AddWithValue("@ReferenceIDTP", SqlDbType.VarChar).Value = transactionDTO.ReferenceIDTP;
sql_cmnd.Parameters.AddWithValue("@IPAddress", SqlDbType.VarChar).Value = transactionDTO.IPAddress;
sql_cmnd.Parameters.AddWithValue("@LatLong", SqlDbType.VarChar).Value = transactionDTO.LatLong;
sql_cmnd.Parameters.AddWithValue("@MobileNumber", SqlDbType.VarChar).Value = transactionDTO.MobileNumber;
sql_cmnd.Parameters.AddWithValue("@TransactionTypeId", SqlDbType.Int).Value = Convert.ToInt32(transactionDTO.TransactionTypeId);
sql_cmnd.Parameters.AddWithValue("@ReferernceNumber", SqlDbType.VarChar).Value = transactionDTO.IDTPPIN;
sql_cmnd.Parameters.AddWithValue("@senderId", SqlDbType.BigInt).Value = transactionDTO.SenderId;
sql_cmnd.Parameters.AddWithValue("@receiverId", SqlDbType.BigInt).Value = transactionDTO.ReceiverId;
sql_cmnd.Parameters.AddWithValue("@SenderBankId", SqlDbType.Int).Value = transactionDTO.SenderBankId;
sql_cmnd.Parameters.AddWithValue("@ReceiverBankId", SqlDbType.Int).Value = transactionDTO.ReceiverBankId;
sql_cmnd.Parameters.AddWithValue("@FeeAmount", SqlDbType.Decimal).Value = Convert.ToDecimal(transactionDTO.FeeAmount);
sql_cmnd.Parameters.AddWithValue("@VATAmount", SqlDbType.Decimal).Value = Convert.ToDecimal(transactionDTO.VATAmount);
sql_cmnd.Parameters.AddWithValue("@SendingBankReference", SqlDbType.VarChar).Value = transactionDTO.SendingBankReference;
sql_cmnd.Parameters.AddWithValue("@SendingPSPReference", SqlDbType.VarChar).Value = transactionDTO.SendingPSPReference;
sql_cmnd.Parameters.AddWithValue("@ReceivingBankReference", SqlDbType.VarChar).Value = transactionDTO.ReceivingBankReference;
sql_cmnd.Parameters.AddWithValue("@ReceivingPSPReference", SqlDbType.VarChar).Value = transactionDTO.ReceivingPSPReference;
#endregion
sql_cmnd.ExecuteNonQuery();
connection.Close();
}
}
catch (Exception ex) {
throw ex;
}
}
public string TransactionFundInsertOnlyCSV([FromBody] Payload payload)
{
try {
var tranDto = new TransactionDTOReq();
var payLoads = payload.xmlData.Split(",").Select(x => x.Trim()).ToArray();
tranDto.SenderBankSwiftCode = payLoads[0];
tranDto.SenderVID = payLoads[1];
tranDto.ReceiverVID = payLoads[2];
tranDto.Amount = payLoads[3];
tranDto.ChannelName = payLoads[4];
tranDto.DeviceID = payLoads[5];
tranDto.MobileNumber = payLoads[6];
tranDto.LatLong = payLoads[7];
tranDto.IPAddress = payLoads[8];
tranDto.IDTPPIN = payLoads[9];
tranDto.EndToEndID = payLoads[10];
tranDto.SendingBankTxId = payLoads[11];
tranDto.SendingBankReference = payLoads[12];
tranDto.MessageID = payLoads[13];
string IdtpRef = "IDTP" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
User sender, receiver;
bool senderExists = _masterDataCache.UserDictionary.TryGetValue(tranDto.SenderVID, out sender);
bool receiverExists = _masterDataCache.UserDictionary.TryGetValue(tranDto.ReceiverVID, out receiver);
if (!senderExists)
{
throw new Exception("Invalid Sender");
}
if (!receiverExists)
{
throw new Exception("Invalid Receiver");
}
//if(!SecurityService.DecryptAndCheck(tranDto.IDTPPIN, sender.SecretSalt, sender.IDTP_PIN)) throw new Exception("Invalid IDTP PIN");
UserAccountInformationDTO senderAccInfo, receiverAccInfo;
_masterDataCache.FiDictionary.TryGetValue(sender.DefaultFI, out senderAccInfo);
_masterDataCache.FiDictionary.TryGetValue(receiver.DefaultFI, out receiverAccInfo);
if (tranDto.ChannelName == "Mobile" && tranDto.DeviceID != senderAccInfo.DeviceID)
{
throw new Exception("Invalid User Device Id");
}
tranDto.SenderAccNo = senderAccInfo.AccountNumber;
tranDto.ReceiverAccNo = receiverAccInfo.AccountNumber;
tranDto.SendingBankRoutingNo = "123456";
tranDto.ReceivingBankRoutingNo = "123456";
tranDto.SenderBankId = senderAccInfo.FinancialInstitutionId;
tranDto.ReceiverBankId = receiverAccInfo.FinancialInstitutionId;
tranDto.PaymentNote = "Payment Note";
tranDto.ReferenceIDTP = IdtpRef;
tranDto.TransactionTypeId = "1";
tranDto.SenderId = sender.UserId;
tranDto.ReceiverId = receiver.UserId;
tranDto.FeeAmount = "0";
tranDto.VATAmount = "0";
tranDto.SendingPSPReference = "";
tranDto.ReceivingBankReference = "";
tranDto.ReceivingPSPReference = "";
_idtpTransCache.SetTransValue(tranDto);
return("Write in memory successfull");
}
catch (Exception e) {
return(e.Message);
}
}
public static void TransferFundFinalSp(string csvData)
{
try {
string spname = "AddTransaction_V2";
var serviceRequestDTO = new TransactionDTOReq();
var payLoads = csvData.Split(",").Select(x => x.Trim()).ToArray();
serviceRequestDTO.SenderBankSwiftCode = payLoads[0];
serviceRequestDTO.SenderVID = payLoads[1];
serviceRequestDTO.ReceiverVID = payLoads[2];
serviceRequestDTO.Amount = payLoads[3];
serviceRequestDTO.ChannelName = payLoads[4];
serviceRequestDTO.DeviceID = payLoads[5];
serviceRequestDTO.MobileNumber = payLoads[6];
serviceRequestDTO.LatLong = payLoads[7];
serviceRequestDTO.IPAddress = payLoads[8];
serviceRequestDTO.IDTPPIN = payLoads[9];
serviceRequestDTO.EndToEndID = payLoads[10];
serviceRequestDTO.SendingBankTxId = payLoads[11];
serviceRequestDTO.SendingBankReference = payLoads[12];
serviceRequestDTO.MessageID = payLoads[13];
string SenderAccNo = "22245612345678912", ReceiverAccNo = "33345612345678912", SendingBankRoutingNo = "098764123",
ReceivingBankRoutingNo = "987543211";
int senderId = 1, receiverId = 2, SenderBankId = 1, ReceiverBankId = 2;
using (SqlConnection connection = new SqlConnection(ConnectionString)) {
connection.Open();
SqlCommand sql_cmnd = new SqlCommand(spname, connection);
sql_cmnd.CommandType = CommandType.StoredProcedure;
#region params
sql_cmnd.Parameters.AddWithValue("@SenderAccNo", SqlDbType.VarChar).Value = SenderAccNo;
sql_cmnd.Parameters.AddWithValue("@ReceiverAccNo", SqlDbType.VarChar).Value = ReceiverAccNo;
sql_cmnd.Parameters.AddWithValue("@Amount", SqlDbType.Decimal).Value = 1.1;
sql_cmnd.Parameters.AddWithValue("@PaymentNote", SqlDbType.VarChar).Value = "Test";
sql_cmnd.Parameters.AddWithValue("@EndToEndID", SqlDbType.VarChar).Value = "E2Esblasd1231422";
sql_cmnd.Parameters.AddWithValue("@MessageID", SqlDbType.VarChar).Value = "REFSENBsblasd1231422";
sql_cmnd.Parameters.AddWithValue("@SendingBankRoutingNo", SqlDbType.VarChar).Value = SendingBankRoutingNo;
sql_cmnd.Parameters.AddWithValue("@ReceivingBankRoutingNo", SqlDbType.VarChar).Value = ReceivingBankRoutingNo;
sql_cmnd.Parameters.AddWithValue("@ReferenceIDTP", SqlDbType.VarChar).Value = serviceRequestDTO.ReferenceIDTP;
sql_cmnd.Parameters.AddWithValue("@IPAddress", SqlDbType.VarChar).Value = "192.156.98.71";
sql_cmnd.Parameters.AddWithValue("@LatLong", SqlDbType.VarChar).Value = "23.8103° N, 90.4125° E";
sql_cmnd.Parameters.AddWithValue("@MobileNumber", SqlDbType.VarChar).Value = "+8801987456789";
sql_cmnd.Parameters.AddWithValue("@TransactionTypeId", SqlDbType.Int).Value = 1;
sql_cmnd.Parameters.AddWithValue("@ReferernceNumber", SqlDbType.VarChar).Value = "REF12364564675876";
sql_cmnd.Parameters.AddWithValue("@senderId", SqlDbType.BigInt).Value = senderId;
sql_cmnd.Parameters.AddWithValue("@receiverId", SqlDbType.BigInt).Value = receiverId;
sql_cmnd.Parameters.AddWithValue("@SenderBankId", SqlDbType.Int).Value = SenderBankId;
sql_cmnd.Parameters.AddWithValue("@ReceiverBankId", SqlDbType.Int).Value = ReceiverBankId;
sql_cmnd.Parameters.AddWithValue("@FeeAmount", SqlDbType.Decimal).Value = 0;
sql_cmnd.Parameters.AddWithValue("@VATAmount", SqlDbType.Decimal).Value = 0;
sql_cmnd.Parameters.AddWithValue("@SendingBankReference", SqlDbType.VarChar).Value = "SBL1REF";;
sql_cmnd.Parameters.AddWithValue("@SendingPSPReference", SqlDbType.VarChar).Value = "";
sql_cmnd.Parameters.AddWithValue("@ReceivingBankReference", SqlDbType.VarChar).Value = "1234567890";
sql_cmnd.Parameters.AddWithValue("@ReceivingPSPReference", SqlDbType.VarChar).Value = "";
#endregion
sql_cmnd.ExecuteNonQuery();
connection.Close();
}
}
catch (Exception ex) {
throw ex;
}
}
public void SetTransValue(TransactionDTOReq value)
{
_blockingTransCollection.Add(value);
}
