public async Task <DataTable> GetUserList(int OperatorID)
{
try
{
UserUpdateRespCheck objUserupdate = new UserUpdateRespCheck();
using (SqlCommand dataCmd = new SqlCommand("[User_GetOnlyOnline]", objCommonDB.con))
{
dataCmd.CommandType = CommandType.StoredProcedure;
dataCmd.Parameters.AddWithValue("@OperatorId", OperatorID);
if (objCommonDB.con.State == ConnectionState.Closed)
{
objCommonDB.con.Open();
}
var reader = await objCommonDB.GetDataTableAsync(dataCmd);
return(reader);
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (objCommonDB.con.State == ConnectionState.Open)
{
objCommonDB.con.Close();
}
}
}
/// <summary>
/// Only for Version Check
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public async Task <UserUpdateRespCheck> CheckUpdate(UserUpdateCheck obj)
{
try
{
UserUpdateRespCheck objUserupdate = new UserUpdateRespCheck();
using (SqlCommand dataCmd = new SqlCommand("CheckUpdateExists", objCommonDB.con))
{
dataCmd.CommandType = CommandType.StoredProcedure;
dataCmd.Parameters.AddWithValue("@UserId", obj.UserId);
dataCmd.Parameters.AddWithValue("@Token", obj.Token);
dataCmd.Parameters.AddWithValue("@CurrExeVersion", obj.CurrentVersion);
if (objCommonDB.con.State == ConnectionState.Closed)
{
objCommonDB.con.Open();
}
var reader = await dataCmd.ExecuteReaderAsync();
while (reader.Read())
{
objUserupdate.IsUpdateAvailable = Convert.ToBoolean(reader["IsUpdateAvailable"]);
objUserupdate.IsValidUser = Convert.ToBoolean(reader["IsValidUser"]);
objUserupdate.LatestVersion = Convert.ToInt32(reader["VersionId"]);
//objUserupdate._apiUrl = reader["ApiUrl"].ToString();
//objUserupdate._exes = reader["Exes"].ToString();
//objUserupdate._updateUrl = reader["UpdateUrl"].ToString();
}
return(objUserupdate);
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (objCommonDB.con.State == ConnectionState.Open)
{
objCommonDB.con.Close();
}
}
}
public async Task <ApiResponse> CheckUpdate(UserUpdateCheck obj)
{
LoginRepo loginRepo = new LoginRepo();
ApiResponse apiResponse = new ApiResponse();
try
{
UserUpdateRespCheck objCheckUpdate = await loginRepo.CheckUpdate(obj);
if (objCheckUpdate.IsValidUser)
{
apiResponse = TaskUTL.CheckUpdate(objCheckUpdate.IsValidUser, objCheckUpdate.IsUpdateAvailable, obj.Token, objCheckUpdate);
}
}
catch (Exception ex)
{
apiResponse = TaskUTL.GenerateExceptionResponse(ex, _pageName, true);
}
return(apiResponse);
}
