public ATM_IMPS_VAS_ResponseModel IMPS_Reversal(ATM_IMPS_VAS_RequestModel model)
{
var ResponseModel = new ATM_IMPS_VAS_ResponseModel();
//IMPS Trans(in,out and intra)
//Transaction_type : IMPS,VM
//ProcessingCodeType : 41-intra, 42-outward, 43-inward
if (model.TransactionType == "45" || model.TransactionType == "32" || model.TransactionType == "48" || model.TransactionType == "34")
{
ResponseModel = DBobject.IMPS_Reversal(model);
return(ResponseModel);
}
////P2A IMPS Trans(in,out and intra)
////Transaction_type : 48-IMPS, 34-VM
////ProcessingCodeType : 41-intra, 42-outward, 43-inward
//else if ((model.TransactionType == "48" || model.TransactionType == "34") && (model.ProcesingCode == "41" || model.ProcesingCode == "42" || model.ProcesingCode == "43"))
//{
// ResponseModel = DBobject.P2A_IMPS_Reversal(model);
// return ResponseModel;
//}
////P2U IMPS Trans(in,out and intra)
////Transaction_type : -IMPS, -VM
////ProcessingCodeType : -intra, -outward, -inward
//else if (model.TransactionType == "" && model.ProcesingCode == "")
//{
// ResponseModel = DBobject.P2U_IMPS_Reversal(model);
// return ResponseModel;
//}
////VAS Trans(in,out and intra)
////Transaction_type : 94
////ProcessingCodeType : 94
//else if (model.TransactionType == "94" && model.ProcesingCode == "94")
//{
// ResponseModel = DBobject.VAS_Reversal(model);
// return ResponseModel;
//}
//NEFT Trans(in,out and intra)
//Transaction_type : 88
//ProcessingCodeType : 88
else if (model.TransactionType == "88" && model.ProcesingCode == "88")
{
ResponseModel = DBobject.NEFT_Reversal(model);
return(ResponseModel);
}
//RTGS Trans(in,out and intra)
//Transaction_type : 89
//ProcessingCodeType : 89
else if (model.TransactionType == "89" && model.ProcesingCode == "89")
{
ResponseModel = DBobject.RTGS_Reversal(model);
return(ResponseModel);
}
return(ResponseModel);
}
public ATM_IMPS_VAS_ResponseModel AcquirerCashWithdrawal(ATM_IMPS_VAS_RequestModel model)
{
var WithdrawalResponse = new ATM_IMPS_VAS_ResponseModel();
try
{
var sql_string = "select sf_process_atm_acquirer_withdrawals('" + model.ProcesingCode + "','" + model.AtmCardNumber + "','" + model.PAN + "','" + model.Date + "','" + model.Amount + "','" + model.AccountType + "','" + model.TrackerID + "','" + model.AtmDetails + "') response_code";
WithdrawalResponse.ResponseCode = mFields_obj.ResponseCode(Convert.ToString(db_select_operation(sql_string, "response_code")));
}
catch (Exception ex)
{
WithdrawalResponse.ResponseCode = "transaction rejected";
}
return(WithdrawalResponse);
}
public ATM_IMPS_VAS_ResponseModel CashWithdrwalReverse(ATM_IMPS_VAS_RequestModel model)
{
var ReversalResponse = new ATM_IMPS_VAS_ResponseModel();
try
{
sql_string = "select sf_process_ATMs_PoS_ecommerce_reversal('" + model.ProcesingCode + "','" + model.AtmCardNumber + "','" + model.PAN + "','" + model.Date + "','" + model.STAN + "','" + model.Amount + "' ,'" + model.OriginalData + "','" + model.TrackerID + "','" + model.AtmDetails + "') response_code";
ReversalResponse.ResponseCode = mFields_obj.ResponseCode(Convert.ToString(db_select_operation(sql_string, "response_code")));
}
catch (Exception ex)
{
ReversalResponse.ResponseCode = mFields_obj.ResponseCode("transaction rejected");
}
return(ReversalResponse);
}
public ATM_IMPS_VAS_ResponseModel Statement_IMPS(ATM_IMPS_VAS_RequestModel model)
{
ATM_IMPS_VAS_ResponseModel ResponseModel = new ATM_IMPS_VAS_ResponseModel();
try
{
DataTable dt = new DataTable();
string sql_string = "select sf_get_IMPS_statement('" + model.PAN + "','" + model.Date + "','" + model.FromDateStmt + "','" + model.ToDateStmt + "','" + model.FromAcNo + "','" + model.TrackerID + "') stmt_data";
return_value = Convert.ToString(db_select_operation(sql_string, "stmt_data")).Split('*');
ResponseModel.ResponseCode = mFields_obj.ResponseCode(return_value[0]);
}
catch (Exception ex)
{
return(null);
}
return(ResponseModel);
}
public ATM_IMPS_VAS_ResponseModel RTGS_Reversal(ATM_IMPS_VAS_RequestModel model)
{
ATM_IMPS_VAS_ResponseModel ResponseModel = new ATM_IMPS_VAS_ResponseModel();
try
{
string sql_string = "select sf_process_imps_rtgs_transfer('" + model.TrackerID + "','" + model.PAN + "','" + model.ProcesingCode + "','" + model.TransactionType + "','" + model.Amount + "','" + model.Date + "','" + model.STAN + "','" + model.AIIC + "','" + model.RRN + "','" + model.TerminalID + "*" + model.TerminalNameLocation + "','" + model.FromAcNo + "','" + model.ToAcNo + "','" + model.IMPSdata + "','" + model.OriginalData + "') rtgs_data";
return_value = Convert.ToString(db_select_operation(sql_string, "rtgs_data")).Split('*');
ResponseModel.AdditionalAmount = return_value[0];
ResponseModel.ResponseCode = mFields_obj.ResponseCode(return_value[1]);
ResponseModel.CustomerNameMobile = return_value[2];
}
catch (Exception ex)
{
return(null);
}
return(ResponseModel);
}
public ATM_IMPS_VAS_ResponseModel AcquirerCashWithdrwalReverse(ATM_IMPS_VAS_RequestModel model)
{
var ReversalResponse = new ATM_IMPS_VAS_ResponseModel();
try
{
var originalMti = model.OriginalData.Substring(0, 4);
var originalStan = model.OriginalData.Substring(4, 6);
var originalDate = model.OriginalData.Substring(10, 10);
var originalAiic = model.OriginalData.Substring(20, 6);
sql_string = "select sf_process_atm_acquirer_withdrawals_reversal('" + model.ProcesingCode + "','" + model.AtmCardNumber + "','" + model.PAN + "','" + model.Date + "','" + model.STAN + "','" + model.Amount + "' ,'" + originalMti + "','" + originalStan + "','" + originalAiic + "','" + originalDate + "','" + model.TrackerID + "','" + model.AtmDetails + "') response_code";
ReversalResponse.ResponseCode = mFields_obj.ResponseCode(Convert.ToString(db_select_operation(sql_string, "response_code")));
}
catch (Exception)
{
ReversalResponse.ResponseCode = "transaction rejected";
}
return(ReversalResponse);
}
public ATM_IMPS_VAS_ResponseModel ChequeRequest_IMPS(ATM_IMPS_VAS_RequestModel model)
{
ATM_IMPS_VAS_ResponseModel ResponseModel = new ATM_IMPS_VAS_ResponseModel();
try
{
string sql_string = "select sf_get_IMPS_cheque_request('" + model.PAN + "','" + model.Date + "','" + model.FromAcNo + "','" + model.TrackerID + "') stmt_data";
return_value = Convert.ToString(db_select_operation(sql_string, "stmt_data")).Split('*');
ResponseModel.MimiStatement = mFields_obj.ResponseCode(return_value[0]);
ResponseModel.ResponseCode = mFields_obj.ResponseCode(return_value[1]);
}
catch (Exception ex)
{
return(null);
}
if (ResponseModel.MimiStatement == "" || ResponseModel.MimiStatement == "0")
{
ResponseModel.MimiStatement = null;
}
return(ResponseModel);
}
public ATM_IMPS_VAS_ResponseModel BalanceInquiry_IMPS(ATM_IMPS_VAS_RequestModel model)
{
ATM_IMPS_VAS_ResponseModel ResponseModel = new ATM_IMPS_VAS_ResponseModel();
try
{
string sql_string = "select sf_get_IMPS_balance_enquiry('" + model.PAN + "','" + model.Date + "','" + model.FromAcNo + "','" + model.TrackerID + "','" + model.ProcesingCode + "','" + model.TransactionType + "') balance_data";
return_value = Convert.ToString(db_select_operation(sql_string, "balance_data")).Split('*');
ResponseModel.AdditionalAmount = return_value[0];
ResponseModel.ResponseCode = mFields_obj.ResponseCode(return_value[1]);
}
catch (Exception ex)
{
return(null);
}
if (ResponseModel.AdditionalAmount == "" || ResponseModel.AdditionalAmount == "0")
{
ResponseModel.AdditionalAmount = null;
}
return(ResponseModel);
}
public ATM_IMPS_VAS_ResponseModel BalanceInquiry(ATM_IMPS_VAS_RequestModel model)
{
var BalanceData = new ATM_IMPS_VAS_ResponseModel();
try
{
sql_string = "select sf_get_atm_balance_enquiry('" + model.AtmCardNumber + "','" + model.PAN + "','" + model.Date + "','" + model.AccountType + "','" + model.TrackerID + "','" + model.Fee + "','" + model.ProcesingCode + "') additional_amounts";
return_value = Convert.ToString(db_select_operation(sql_string, "additional_amounts")).Split('*');
BalanceData.AdditionalAmount = return_value[0];
BalanceData.ResponseCode = mFields_obj.ResponseCode(return_value[1]);
}
catch (Exception)
{
BalanceData.ResponseCode = "error_occured";
}
if (BalanceData.AdditionalAmount == "" || BalanceData.AdditionalAmount == "0")
{
BalanceData.AdditionalAmount = null;
}
return(BalanceData);
}
public ATM_IMPS_VAS_ResponseModel Ministatement(ATM_IMPS_VAS_RequestModel model)
{
var MinistatementData = new ATM_IMPS_VAS_ResponseModel();
try
{
sql_string = "select sf_get_atm_mini_statement('" + model.AtmCardNumber + "','" + model.PAN + "','" + model.Date + "','" + model.AccountType + "','" + model.TrackerID + "') return_value";
return_value = Convert.ToString(db_select_operation(sql_string, "return_value")).Split('*');
MinistatementData.MimiStatement = return_value[0];
MinistatementData.ResponseCode = mFields_obj.ResponseCode(return_value[1]);
}
catch (Exception)
{
MinistatementData.MimiStatement = null;
return(MinistatementData);
}
if (MinistatementData.MimiStatement == "" || MinistatementData.MimiStatement == "0")
{
MinistatementData.MimiStatement = null;
}
return(MinistatementData);
}
public ATM_IMPS_VAS_ResponseModel IMPS(ATM_IMPS_VAS_RequestModel model)
{
var ResponseModel = new ATM_IMPS_VAS_ResponseModel();
////IMPS Trans(in,out and intra)
////Transaction_type : -IMPS
////ProcessingCodeType : -intra, -outward, -inward
if (model.TransactionType == "45" || model.TransactionType == "48" || model.TransactionType == "94")
{
ResponseModel = DBobject.IMPS_Trans(model);
return(ResponseModel);
}
////IMPS Trans VM(in,out and intra)
////Transaction_type : -VM
////ProcessingCodeType : inward
if (model.TransactionType == "32" || model.TransactionType == "34")
{
ResponseModel = DBobject.IMPS_Trans_VM(model);
return(ResponseModel);
}
//NEFT Trans(in, out and intra)
//Transaction_type : 88
//ProcessingCodeType : 88
else if (model.TransactionType == "88" && model.ProcesingCode == "88")
{
ResponseModel = DBobject.NEFT(model);
return(ResponseModel);
}
//RTGS Trans(in,out and intra)
//Transaction_type : 89
//ProcessingCodeType : 89
else if (model.TransactionType == "89" && model.ProcesingCode == "89")
{
ResponseModel = DBobject.RTGS(model);
return(ResponseModel);
}
return(ResponseModel);
}
public ATM_IMPS_VAS_ResponseModel Ministatement_IMPS(ATM_IMPS_VAS_RequestModel model)
{
ATM_IMPS_VAS_ResponseModel ResponseModel = new ATM_IMPS_VAS_ResponseModel();
try
{
DataTable dt = new DataTable();
string sql_string = "select sf_get_IMPS_mini_statement('" + model.PAN + "','" + model.Date + "','" + model.FromAcNo + "','" + model.TrackerID + "') statement_data";
return_value = Convert.ToString(db_select_operation(sql_string, "statement_data")).Split('*');
ResponseModel.MimiStatement = return_value[0];
ResponseModel.AdditionalAmount = return_value[1];
ResponseModel.ResponseCode = mFields_obj.ResponseCode(return_value[2]);
}
catch (Exception ex)
{
return(null);
}
if (ResponseModel.MimiStatement == "" || ResponseModel.MimiStatement == "0")
{
ResponseModel.MimiStatement = null;
}
return(ResponseModel);
}