public async Task <List <PackageModel> > GetLatestPackageAsync(string packageName)
{
try
{
var result = new List <PackageModel>();
var sql = "SELECT PACKAGE_NAME, VERSION, APK_URL, CREATION_DATE" +
"FROM IFSAPP.UPDATE_MANAGER_TAB " +
"WHERE PACKAGE_NAME='" + packageName + "' " +
"ORDER BY CREATION_DATE";
var dt = await _oracleProvider.QueryAsync(_userData, sql);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
result.Add(new PackageModel()
{
PackageName = row["PACKAGE_NAME"].ToString(),
Version = row["VERSION"].ToString(),
Url = row["APK_URL"].ToString(),
CreationDate = DateTime.Parse(row["CREATION_DATE"].ToString())
});
}
}
return(result);
}
catch (Exception ex)
{
throw ExceptionHelper.Throw(ex, typeof(UpdateManagerRepository).Name, "GetLatestPackageAsync");
}
}
public async Task <bool> AuthenticateAsync(LoginModel loginModel)
{
try
{
var userData = new UserData()
{
Username = loginModel.Username,
EncryptedPassword = PasswordHelper.Encrypt(loginModel.Password)
};
var dt = await _oracleProvider.QueryAsync(userData, "SELECT 1 FROM DUAL");
return(true);
}
catch (Exception ex)
{
throw ExceptionHelper.Throw(ex, ClassName, "AuthenticateAsync");
}
}