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; } }