Posts

Showing posts from April, 2022

.net core interview April 2022

  Middleware - https://code-maze.com/global-error-handling-aspnetcore/

Aws Log Report

 [AllowAnonymous]         [HttpPost]         [Route("GetAwsLogs")]         public async Task<DbFetchListResponse<ResultFieldDto>> GetAwsLog(GetAwsLogRequest oRequest)         {             DbFetchListResponse<ResultFieldDto> retu = DbFetchListResponse<ResultFieldDto>.GetFailureInstance(-1, "Initialization Ready");             string resultJson = string.Empty;             try             {                 TabAwsLogRequest oTabAwsLogRequest = await this._IAwsLogService.GetAwsLogRequestById(oRequest.AwsLogRequestId);                 if (oTabAwsLogRequest != null)                 {                   ...

SQL Queries Log

  1500587 81 8056512886 Jackpot SELECT TOP (1000) [Id]       ,[PlayerId]       ,[Token]       ,[UpdatedDate]   FROM [BBPlatform].[dbo].[BB_JP_Wallet] where  PlayerId =  1500587 update BB_JP_Wallet set Token = 2  where  PlayerId =  1500587 --------------------

Paging in .net core api

   public async Task<Tuple<List<GetCustomerResponse>, int>> GetCustomerWithPaginations(GetCustomerRequest oRequest)         {             int totalCount = 0;             int skipData = (oRequest.PageIndex - 1) * oRequest.PageSize;             List<GetCustomerResponse> customerResponse = new List<GetCustomerResponse>();             if (oRequest.FromBalance != null || oRequest.ToBalance != null || oRequest.FromFreeBet != null || oRequest.ToFreeBet != null)             {                 // get balance                 IQueryable<GetCustomerResponse> data_balance = umpContext.Deposits                     .Join(umpContext.FreebetsDeposits, bal => bal...