public async Task <IEnumerable <CompanySessionsList> > GetAttendeeList(CompanySessionsRequest usersRequest, HttpContext context)
{
try
{
IEnumerable <CompanySessionsList> sessionLists = new List <CompanySessionsList>();
using (IDbConnection con = new SqlConnection(_connectionString))
{
sessionLists = await con.QueryAsync <CompanySessionsList>("dbo.SSP_getSessionAttendeeList", new
{
SessionId = usersRequest.SessionId
}, commandType : CommandType.StoredProcedure);
}
foreach (var item in sessionLists)
{
if (item.ProfilePhoto != null)
{
item.ProfilePhoto = context.Request.Scheme + "://" + context.Request.Host + context.Request.PathBase + "\\images\\" + item.ProfilePhoto;
}
}
return(sessionLists);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> GetAttendeeList([FromBody] CompanySessionsRequest request)
{
JsonResponse <IEnumerable <CompanySessionsList> > objResult = new JsonResponse <IEnumerable <CompanySessionsList> >();
try
{
HttpContext context = HttpContext;
IEnumerable <CompanySessionsList> sessionLists = await this._superAdminService.GetAttendeeList(request, context);
if (sessionLists.Count() > 0 && sessionLists != null)
{
objResult.Data = sessionLists;
objResult.Status = StaticResource.SuccessStatusCode;
objResult.Message = StaticResource.SuccessMessage;
return(new OkObjectResult(objResult));
}
else
{
objResult.Data = null;
objResult.Status = StaticResource.NotFoundStatusCode;
objResult.Message = StaticResource.NotFoundMessage;
return(new OkObjectResult(objResult));
}
}
catch (Exception ex)
{
HttpContext.RiseError(ex);
objResult.Data = null;
objResult.Status = StaticResource.FailStatusCode;
objResult.Message = "Exception occured";
}
return(new OkObjectResult(objResult));
}
public async Task <bool> CancelSessionByPractitioner(SessionBookingRequest model, HttpContext httpContext)
{
try
{
CompanySessionsRequest usersRequest = new CompanySessionsRequest();
usersRequest.SessionId = model.SessionId;
usersRequest.UserId = model.UserId;
IEnumerable <CompanySessionsList> result = await this._superAdminRepo.GetAttendeeList(usersRequest, httpContext);
if (result != null)
{
foreach (var item in result)
{
var sendEmail = await commonEmailsService.CancelSessionByPractitioner(item, httpContext);
}
// return await this.practitionerRepo.CancelSessionByPractitioner(SessionId, httpContext);
}
await this.practitionerRepo.UpdateSessionStatus(usersRequest);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IEnumerable <CompanySessionsList> > GetAttendeeList(CompanySessionsRequest usersRequest, HttpContext context)
{
try
{
return(await this._superAdminRepo.GetAttendeeList(usersRequest, context));
}
catch (Exception ex)
{
throw ex;
}
}
//public async Task<SesionCounts> GetAllSessionCountPractitioner(int practitionerID)
//{
// try
// {
// return await this.practitionerRepo.GetAllSessionCountPractitioner(practitionerID);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public async Task <bool> SessionStartByPractitioner(SessionBookingRequest model, HttpContext httpContext)
{
try
{
CompanySessionsRequest usersRequest = new CompanySessionsRequest();
usersRequest.SessionId = model.SessionId;
usersRequest.UserId = model.UserId;
await this.practitionerRepo.SessionStartByPractitioner(usersRequest);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IEnumerable <CompanySessionsList> > GetAllSessionsList(CompanySessionsRequest usersRequest, HttpContext context)
{
try
{
if (usersRequest.StartDate == null)
{
usersRequest.StartDate = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-dd");
usersRequest.EndDate = DateTime.Now.AddYears(1).ToUniversalTime().ToString("yyyy-MM-dd");
}
IEnumerable <CompanySessionsList> sessionLists = new List <CompanySessionsList>();
using (IDbConnection con = new SqlConnection(_connectionString))
{
sessionLists = await con.QueryAsync <CompanySessionsList>("dbo.SSP_getAllSessionListForAdmin", new
{
SessionTitle = usersRequest.SessionTitle,
SessionType = usersRequest.SessionType,
PractitionerName = usersRequest.PractitionerName,
OffSet = usersRequest.OffSet,
Limit = usersRequest.Limit,
StartDate = usersRequest.StartDate,
EndDate = usersRequest.EndDate,
IsAccepted = usersRequest.IsAccepted
}, commandType : CommandType.StoredProcedure);
}
foreach (var item in sessionLists)
{
if (item.ProfilePhoto != null)
{
item.ProfilePhoto = context.Request.Scheme + "://" + context.Request.Host + context.Request.PathBase + "//images//" + item.ProfilePhoto;
}
}
return(sessionLists);
}
catch (Exception ex)
{
throw ex;
}
}
