public BaseResponse EditRetailer(RetailerMgtRequest retailerMgtRequest)
{
BaseResponse resp = new BaseResponse();
resp = _IRetailerMgtRepository.EditRetailer(retailerMgtRequest);
return(resp);
}
public BaseResponse AddRetailer(RetailerMgtRequest retailerMgtRequest)
{
retailerMgtRequest.pRetailerCNIC = retailerMgtRequest.pRetailerCNIC.Insert(5, "-").Insert(13, "-");
///////
BaseResponse response = new BaseResponse();
bool isSuccess = true;
string code = "00";
string message = string.Empty;
OracleConnection connection = null;
OracleCommand cmd = null;
try
{
// using (cmd = new NpgsqlCommand("CALL PRC_RETAILER_LOGIN_INFO_SAVE(@PRETAILERCNIC,@PRETAILERID,@PRETAILERREGION,@PFSRETAILERID,@PFUNDAMOPOS,@PEAgreementState,@PBVMT_Agent_Sent,@PBVMT_Agent_Receive,@PWIFI_FALLBACK,@PSMS_FALLBACK,@PUPSELL,@pDAP,@PIRCASHWITHDRAWL,@PIRBVSVERIFICATION,@PIRPULLFUND,@P4GUPSELLCHECK,@PDAPACCUPSELL,@PRETAILER_CREATE,@PRSO_TYPE,@PRETAILER_CREATE_TYPE,@PREPEAT_RECHARGE,@PEASY_BAZAR,@PRETAILER_REGISTRATION,@POTP,@PCOMPLIANCE_PASSWORD,@P789_SIM_REPLACEMENT,@PACCESSRIGHTS,@PCREATEDBY)", connection = new NpgsqlConnection(_Configuration.GetConnectionString("DefaultConnection")))
// using (connection = new OracleConnection("data source=10.0.1.192:1521/demoaksa; User ID=MBPU_STG; Password=mbpu321;"))
using (connection = new OracleConnection(_connectionString))
{
using (cmd = new OracleCommand("PKG_RETAILER_MANAGMENT.PRC_RETAILER_LOGIN_INFO_SAVE", connection))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRETAILERCNIC", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRetailerCNIC
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRETAILERID", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRetailerID
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRETAILERREGION", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRetailerRegion
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PFSRETAILERID", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pFSRetailerID
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PFUNDAMOPOS", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pFundamoPos
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PEAgreementState", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pEAgreementState
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PBVMT_Agent_Sent", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pBVMT_Agent_Sent
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PBVMT_Agent_Receive", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pBVMT_Agent_Receive
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PWIFI_FALLBACK", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pWIFI_FALLBACK == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PSMS_FALLBACK", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pSMS_FALLBACK == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PUPSELL", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pUPSELL == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PDAP", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pDAP == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PIRCASHWITHDRAWL", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pIR_Cash_Withdrawal_Enabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PIRBVSVERIFICATION", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pIR_BVS_Verfication_Enabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PIRPULLFUND", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pIR_Pull_FUND_Enabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "P4GUPSELLCHECK", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.PFourGUPSELLCHECK_Enabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PDAPACCUPSELL", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pDAPACCUPSEL_Enabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRETAILER_CREATE", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRETAILER_CREATE == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRSO_TYPE", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRSO_TYPE == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRETAILER_CREATE_TYPE", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRETAILER_CREATE_TYPE
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PREPEAT_RECHARGE", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pREPEAT_RECHARGE == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PEASY_BAZAR", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pEASY_BAZAR == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRETAILER_REGISTRATION", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pRetailerRegistrationEnabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "POTP", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pOTP_ENABLED == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PCOMPLIANCE_PASSWORD", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pCompliancePasswordEnabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "P789_SIM_REPLACEMENT", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.p789SimReplacementEnabled == "true" ? 1 : 0
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PACCESSRIGHTS", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.pAccessRights
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PCREATEDBY", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerMgtRequest.PCREATEDBY
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PCODE", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Output, Size = 1000
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PDESC", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Output, Size = 1000
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PMSG", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Output, Size = 1000
});
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
if (Convert.ToString(cmd.Parameters["PCODE"].Value) == "00" || Convert.ToString(cmd.Parameters["PCODE"].Value) == "0")
{
cmd.Parameters.Add("PDESC", OracleDbType.Varchar2, 1000).Direction = System.Data.ParameterDirection.Output;
}
else
{
cmd.Parameters.Add("PDESC", OracleDbType.Varchar2, 1000).Direction = System.Data.ParameterDirection.Output;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
try
{
if (connection != null && connection.State != ConnectionState.Closed)
{
connection.Close();
connection.Dispose();
}
if (cmd != null)
{
cmd.Dispose();
}
}
catch { }
}
return(new BaseResponse {
Code = code, IsSuccess = isSuccess, Message = message
});
}
