public async Task <IActionResult> ListData(SubscriberSearchModel model) { var data = await _emailSubcriberService.SearchEmailSubcriber(model); ViewBag.lstCountSub = data.ResponseData.Data.Count(); return(PartialView("_EmailSubcriberListTable", data.GetDataResponse())); }
public IActionResult Export(string DateFrom, string DateTo) { SubscriberSearchModel model = new SubscriberSearchModel(); string fileName = string.Empty; if (string.IsNullOrEmpty(DateFrom) && string.IsNullOrEmpty(DateTo)) { return(Content("")); } model.CreatedDateFrom = DateTime.Parse(DateFrom); model.CreatedDateTo = DateTime.Parse(DateTo); var res = _emailSubcriberService.GetLstSubcriToExport(model).Result; if (res != null && res.Count() > 0) { fileName = ExportEmailSubToExcel(res); } if (!string.IsNullOrEmpty(fileName)) { return(Json(new { fileName = fileName })); } else { return(Json(new { fileName = fileName, errorMessage = "No data to export" })); } }
public IPagedList <SubscriberViewModel> SearchSubscriber(SubscriberSearchModel searchModel) { var query = (from p in _dbCMSContext.Subscribers.AsNoTracking() where (p.Email.Contains(searchModel.Email) || string.IsNullOrEmpty(searchModel.Email)) || (p.IsActivated == searchModel.IsActivated || searchModel.IsActivated == null) || (p.CreatedDate >= searchModel.CreatedDateFrom || searchModel.CreatedDateFrom == null) || (p.CreatedDate <= searchModel.CreatedDateTo || searchModel.CreatedDateTo == null) select _mapper.Map <Subscribers, SubscriberViewModel>(p)).ToList(); throw new NotImplementedException(); }
public async Task <List <SubscriberViewModel> > GetLstSubcriToExport(SubscriberSearchModel searchModel) { var req = new BaseRequest <SubscriberSearchModel>(searchModel); var res = await _aPIExcute.PostData <List <SubscriberViewModel>, SubscriberSearchModel>($"{_baseAdminAPIUrl}{_adminPortalApiUrl.PostAPI.GetListSubToExport}", APIHelpers.HttpMethodEnum.POST, req, Token); if (!res.IsSuccessStatusCode) { return(null); } return(res.ResponseData); }
public List <SubscriberViewModel> GetListSubToExport(SubscriberSearchModel searchModel) { var query = _dbCMSContext.Subscribers.AsNoTracking(); if (searchModel.CreatedDateFrom.HasValue) { query = query.Where(x => x.CreatedDate >= searchModel.CreatedDateFrom); } if (searchModel.CreatedDateTo.HasValue) { query = query.Where(x => x.CreatedDate <= searchModel.CreatedDateTo); } query = query.OrderByDescending(x => x.CreatedDate); return(_mapper.ProjectTo <SubscriberViewModel>(query).ToList()); }
public IActionResult GetLstToExport([FromBody] SubscriberSearchModel model) { try { var res = _subscriberService.GetListSubToExport(model); if (res != null) { return(OkBaseResponse(res)); } return(ErrorBaseResponse(System.Net.HttpStatusCode.NotFound)); } catch (Exception ex) { return(ErrorBaseResponse(ex)); } }
public IActionResult SearchPost([FromQuery] SubscriberSearchModel model) { try { var res = _subscriberService.SearchSubscriber(model); if (res != null) { return(OkBaseResponse(res)); } return(ErrorBaseResponse(System.Net.HttpStatusCode.NotFound)); } catch (Exception ex) { return(ErrorBaseResponse(ex)); } }
public IActionResult SearchPost([FromQuery] SubscriberSearchModel model) { try { var res = _subscriberService.SearchSubscriber(model); if (res != null) { return(Ok(res)); } return(NoContent()); } catch (Exception ex) { return(BadRequest(ex.StackTrace.ToString())); } }
public IPagedList <SubscriberViewModel> SearchSubscriber(SubscriberSearchModel searchModel) { var query = _dbCMSContext.Subscribers.AsNoTracking(); if (!string.IsNullOrEmpty(searchModel.Email)) { query = query.Where(x => x.Email.Contains(searchModel.Email)); } if (searchModel.IsActivated.HasValue) { query = query.Where(x => x.IsActivated == searchModel.IsActivated); } if (searchModel.CreatedDateFrom.HasValue) { query = query.Where(x => x.CreatedDate >= searchModel.CreatedDateFrom); } if (searchModel.CreatedDateTo.HasValue) { query = query.Where(x => x.CreatedDate <= searchModel.CreatedDateTo); } query = query.OrderByDescending(x => x.CreatedDate); return(new PagedList <SubscriberViewModel>(_mapper.ProjectTo <SubscriberViewModel>(query), searchModel.PageIndex, searchModel.PageSize)); }
public IActionResult List() { var model = new SubscriberSearchModel(); return(View(model)); }
public async Task <BaseResponse <PagedListClient <SubscriberViewModel> > > SearchEmailSubcriber(SubscriberSearchModel searchModel) { try { var requestParams = ConvertToUrlParameter(searchModel); string urlRequest = $"{_baseAdminAPIUrl}{_adminPortalApiUrl.PostAPI.SearchEmailSubcriber}{requestParams}"; var res = await _aPIExcute.GetData <PagedListClient <SubscriberViewModel> >(urlRequest, null, Token); return(res); } catch (Exception ex) { return(BaseResponse <PagedListClient <SubscriberViewModel> > .InternalServerError(message : ex.Message, fullMsg : ex.StackTrace)); } }