public BaseResponse RetailerPasswardReset(RetailerPasswardReset retailerPasswardReset)
{
BaseResponse resp = new BaseResponse();
resp = _IRetailerMgtRepository.RetailerPasswardReset(retailerPasswardReset);
return(resp);
}
public BaseResponse RetailerPasswardReset(RetailerPasswardReset retailerPasswardReset)
{
BaseResponse response = new BaseResponse();
bool isSuccess = true;
string code = "00";
string message = string.Empty;
OracleConnection connection = null;
OracleCommand cmd = null;
try
{
retailerPasswardReset.pRetailerpasswordHash = _createHashByKey.CreateByKeyHash(retailerPasswardReset.pRetailerPassward, "TP1@#AKSA&*$");
using (connection = new OracleConnection(_connectionString))
{
using (cmd = new OracleCommand("PKG_RETAILER_MANAGMENT.PRC_RETAILER_RESET_PASSWORD", connection))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter {
ParameterName = "PRID", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.Input, Value = retailerPasswardReset.pRID
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "pRETAILER_CNIC", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerPasswardReset.pRetailerCNIC
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "pRETAILER_PASSWARD", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerPasswardReset.pRetailerPassward
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "pRetailerpasswordHash", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerPasswardReset.pRetailerpasswordHash
});
cmd.Parameters.Add(new OracleParameter {
ParameterName = "pUPDATED_BY", OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input, Value = retailerPasswardReset.pUpdatedBy
});
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
});
}
