private async Task <UserLogin> GetUserLogin(UserLogin userLogn, IDbConnection db)
{
try
{
var dataProcesser = new DataProcesser(db);
return(await dataProcesser.FindUserLogin(userLogn));
}
catch (SqlException ex)
{
throw ex;
}
}
private async Task AddPortalUserRecord(PortalUser portalUser, IDbConnection db)
{
var dataProcesser = new DataProcesser(db);
try
{
await dataProcesser.AddPortalUserRecord(portalUser);
}
catch (SqlException ex)
{
throw ex;
}
}
public async Task <IEnumerable <ClientMaster> > GetClientRecords(IDbConnection db)
{
var processer = new DataProcesser(db);
try
{
IAsyncRepository <ClientMaster> clientRepo = new ClientMasterRepositoryAsync(db);
return(await clientRepo.GetAllAsync());
}
catch (SqlException ex)
{
throw ex;
}
}
private async Task AddUserLoginsListToDb(IEnumerable <UserLogin> userlogins)
{
try
{
var prodProcesser = new DataProcesser(_iAgentProdDb);
await prodProcesser.AddListOfUserLogins(userlogins);
lblStatus.Text = "Added all user logins to production";
}
catch (Exception)
{
throw;
}
}
private async Task <IEnumerable <PortalUser> > GetPortalUserRecords(IDbConnection db)
{
var processer = new DataProcesser(db);
var locationId = int.Parse(txtLocationId.Text);
try
{
return(await processer.GetPortalUsersWithLocationd(locationId));
}
catch (Exception)
{
throw;
}
}
private async Task <IEnumerable <PayerWebsiteMappingValue> > GetPayerWebsiteMappingValuesRecords(IDbConnection db)
{
var processer = new DataProcesser(db);
var clientKey = Guid.Parse(txtClientKey.Text);
var clientLocationKey = Guid.Parse(txtClientLocationKey.Text);
try
{
return(await processer.GetPayerWebsiteMappingValues_With_client_and_LocationKeys(clientKey, clientLocationKey));
}
catch (Exception)
{
throw;
}
}
private async Task <IEnumerable <ClientMaster> > GetClientRecords(IDbConnection db)
{
var processer = new DataProcesser(db);
try
{
IAsyncRepository <ClientMaster> clientRepo = null;
return(await clientRepo.GetAllAsync());
}
catch (SqlException ex)
{
lblStatus.Text = "Error getting clients";
throw ex;
}
}
private async Task <IEnumerable <UserLogin> > FinUserLogins()
{
try
{
var clientKey = Guid.Parse(txtClientKey.Text);
var clientLocationKey = Guid.Parse(txtClientLocationKey.Text);
var devProcesser = new DataProcesser(_iAgentDevDb);
var userlogins = await devProcesser.FindUserLogins_With_ClientKey_ClientLocationKey(clientKey, clientLocationKey);
return(userlogins);
}
catch (Exception)
{
throw;
}
}
private async Task <IEnumerable <FacilityMaster> > GetFacility(IDbConnection db)
{
var processer = new DataProcesser(db);
lblStatus.Text = "Getting Facilities";
var clientKey = new Guid(txtClientKey.Text);
var locationKey = new Guid(txtClientLocationKey.Text);
try
{
return(await processer.GetFacility(clientKey, locationKey));
}
catch (SqlException ex)
{
throw ex;
}
}
private async Task <IEnumerable <ClientLocations> > GetClientLocationRecords(IDbConnection db)
{
var processer = new DataProcesser(db);
lblStatus.Text = "Getting Client Location Records";
var clientKey = Guid.Parse(txtClientKey.Text);
if (!clientKey.Equals(null))
{
return(await processer.GetClientLocations_With_ClientKey(clientKey));
}
else
{
lblStatus.Text = "Client key is null. please provide one.";
}
return(null);
}
private async Task GetClientMappingValues(IDbConnection db)
{
try
{
if (txtClientKey.Text != "")
{
var clientKey = Guid.Parse(txtClientKey.Text);
var processer = new DataProcesser(db);
// lblStatus.Text = "Getting Client Mapping Master";
var clientMappingValues = await processer.GetClientMappingValues_With_ClientKey(clientKey);
ClientMappingValuesToGridView(clientMappingValues);
ClientDataToForm(_clientMasterRecords);
// lblStatus.Text = "Getting Client Mapping Master Done...";
}
}
catch (SqlException)
{
}
}
private async Task <IEnumerable <ApcoWebDev> > FindApcoWebDevRecords()
{
_process = new DataProcesser(_ApcoWebDev);
return(await _process.FindApcoRecordsByName(txtApcoSearch.Text));
}