public bool GetLoginUser(sec_UserRepo userrepo)
{
try
{
var param = new DynamicParameters();
string security_Code = "[email protected]";
userrepo.Password = GlobalValue.AES_Encrypt(userrepo.Password, security_Code);
param.Add("P_USER_ID", userrepo.User_Id, DbType.String, ParameterDirection.Input);
param.Add("P_PASSWORD", userrepo.Password, DbType.String, ParameterDirection.Input);
param.Add("VDATA", null, DbType.Int32, ParameterDirection.Output);
db.GetConnection().Execute("LOGIN_PROCEDURES.SEL_LOGIN_USER", param, commandType: CommandType.StoredProcedure);
int paramoption = param.Get <int>("VDATA");
if (paramoption <= 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}