public async Task GetAllPortalUsers_Test()
{
IAsyncRepository <PortalUser> portalsRepo = new PortalUsersAsyncRepository(_iAgentDevDb);
var portalUsers = await portalsRepo.GetAllAsync();
foreach (var portalUser in portalUsers)
{
Console.WriteLine(portalUser.PortalUser_Id);
}
}
public async void Get_Portal_Users_ByLocationId_Test()
{
int locationId = 153;
IAsyncRepository <PortalUser> portalRepo = new PortalUsersAsyncRepository(Database);
var portalUsers = await portalRepo.FindWithIdAsync(locationId);
foreach (var item in portalUsers)
{
Console.WriteLine(item.Username.DecryptStringBase64() + " Password: "******" Portal Id: " + item.Portal_Id);
}
}
public async Task AddPortalUserRecord(PortalUser portalUser)
{
IAsyncRepository <PortalUser> portalUserRepo = new PortalUsersAsyncRepository(_db);
try
{
await portalUserRepo.AddAsync(portalUser);
}
catch (SqlException ex)
{
throw ex;
}
}
//public async Task<IEnumerable<FacilityDetail>> GetFacilityDetails(Guid facilityKey)
//{
// IAsyncRepository<FacilityDetail> facilityDetialsRepo = new FacilityDetialsAsyncRepository(_db);
// try
// {
// return await facilityDetialsRepo.FindWithGuidAsync(facilityKey);
// }
// catch (Exception)
// {
// throw;
// }
//}
public async Task <IEnumerable <PortalUser> > GetPortalUsersWithLocationd(int id)
{
IAsyncRepository <PortalUser> portalUsersRepo = new PortalUsersAsyncRepository(_db);
try
{
return(await portalUsersRepo.FindWithIdAsync(id));
}
catch (Exception)
{
throw;
}
}
public async Task UpdatePortalUserRecord(IDbConnection db)
{
try
{
var portalUser = BuildPortalUserRecord();
IAsyncRepository <PortalUser> portalUsersRepo = new PortalUsersAsyncRepository(db);
await portalUsersRepo.UpdateAsync(portalUser);
}
catch (SqlException ex)
{
lblStatus.Text = "Error updating Portal Users.";
throw ex;
}
}
private async Task GetPortalUserIds(IDbConnection db)
{
try
{
lblStatus.Text = "Getting Portal User Id's";
IAsyncRepository <PortalUser> portalUsersRepo = new PortalUsersAsyncRepository(db);
_portalUsers = await portalUsersRepo.GetAllAsync();
PortalUserIdsToDropDownList(_portalUsers);
PortalUserDataToForm(_portalUsers);
lblStatus.Text = "Getting Portal User Id's complete";
}
catch (SqlException)
{
throw;
}
}
private async Task GetPortalUsers(IDbConnection db)
{
try
{
IAsyncRepository <PortalUser> portalUserRepo = new PortalUsersAsyncRepository(db);
lblStatus.Text = "Getting Portal Users";
var portalUsers = await portalUserRepo.FindWithIdAsync(LocationId);
var decryptedPortalUsers = DecryptBase64PortalUsers(portalUsers);
PortalUsersToDataGridView(decryptedPortalUsers);
lblStatus.Text = "Done";
}
catch (SqlException)
{
throw;
}
}
public async Task Find_PortalUser_Test()
{
var portalUser = new PortalUser()
{
PortalUser_Id = 881,
Portal_Id = 63,
Username = "******",
Password = "******"
};
IAsyncRepository <PortalUser> portalUserRepo = new PortalUsersAsyncRepository(Database);
var updatedPortalUser = await portalUserRepo.Find(portalUser);
foreach (var item in updatedPortalUser)
{
Console.WriteLine(item.PortalUser_Id + " " + item.Username.DecryptStringBase64() + " " + item.Password.DecryptStringBase64());
}
}
