/// <summary> /// /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <List <Banners> > GetBannerDetails(BannerDetailsRequest request) { try { SqlParameter[] parameters = { new SqlParameter("@LocationName", SqlDbType.VarChar), new SqlParameter("@PageName", SqlDbType.VarChar) }; parameters[0].Value = request.LocationName; parameters[1].Value = request.PageName; _DataHelper = new DataAccessHelper("Admin_GetBannerDetails", parameters, _configuration); DataTable dt = new DataTable(); await _DataHelper.RunAsync(dt); List <Banners> statusList = new List <Banners>(); if (dt != null && dt.Rows.Count > 0) { statusList = (from model in dt.AsEnumerable() select new Banners() { BannerImage = model.Field <string>("BannerImage"), BannerUrl = model.Field <string>("BannerUrl"), UrlType = model.Field <int>("UrlType").ToString(), }).ToList(); } return(statusList); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw ex; } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> BannerDetails([FromHeader(Name = "Grid-General-Token")] string Token, [FromBody] BannerDetailsRequest request) { try { if (!ModelState.IsValid) { return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.DomainValidationError, IsDomainValidationErrors = true })); } TokenValidationHelper tokenValidationHelper = new TokenValidationHelper(); if (!tokenValidationHelper.ValidateGenericToken(Token, _iconfiguration)) { return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed), IsDomainValidationErrors = true })); } BannerDataAccess _bannerAccess = new BannerDataAccess(_iconfiguration); return(Ok(new ServerResponse { HasSucceeded = true, Message = StatusMessages.SuccessMessage, Result = await _bannerAccess.GetBannerDetails(request) })); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }