public async Task <IEnumerable <PersonalProfile> > GetPersonalProfiles()
{
return(await _dbConnection.WithConnection(async c =>
{
return await c.QueryAsync <PersonalProfile>(QueryDb.GetPersonalProfile());
}));
}
public async Task <IEnumerable <PersonalEmail> > GetPersonalEmail(string profileIds)
{
using (var db = new OdbcConnection(_connectionStrings.DPSOdbc))
{
await db.OpenAsync();
var data = await db.QueryAsync <PersonalEmail>(QueryDb.GetPersonalEmail(profileIds));
return(data);
}
}
public async Task <IEnumerable <Department> > GetDepartment()
{
using (var db = new OdbcConnection(_connectionStrings.DPSOdbc))
{
await db.OpenAsync();
var data = await db.QueryAsync <Department>(QueryDb.GetDepartment());
return(data);
}
}
public async Task <IEnumerable <Hospital> > GetHospital()
{
using (var db = new OdbcConnection(_connectionStrings.DPSOdbc))
{
await db.OpenAsync();
var data = await db.QueryAsync <Hospital>(QueryDb.GetHospital());
return(data);
}
}
public async Task <JobWork> GetJobWorkByProfileId(int profileId)
{
using (var db = new OdbcConnection(_connectionStrings.DPSOdbc))
{
await db.OpenAsync();
var data = await db.QueryFirstOrDefaultAsync <JobWork>(QueryDb.GetJobWorkByProfileId(), new { PROFILE_ID = profileId });
return(data);
}
}
public async Task <IEnumerable <JobWork> > GetJobWork(string profileIds)
{
using (var db = new OdbcConnection(_connectionStrings.DPSOdbc))
{
await db.OpenAsync();
var data = await db.QueryAsync <JobWork>(QueryDb.GetJobWork(profileIds));
return(data);
}
}