public List <Race> LoadRaces(RaceFilter filter) { var races = getContext().Races .WhereIf(filter.Id.HasValue, x => x.Id == filter.Id) .WhereIf(filter.DateOfRace.HasValue, x => x.DateTimeOfRace.Date == ((DateTime)filter.DateOfRace).Date) .WhereIf(filter.RaceNumberInDay > 0, x => x.NumberRaceInDay == filter.RaceNumberInDay); return(races.ToList()); }
public async Task <DataTable> GetRaceEntry(RaceFilter raceFilter) { try { return(await this._race.GetRaceEntry(raceFilter)); } catch (Exception ex) { throw ex; } }
public async Task <DataSet> GetRaceDetails(RaceFilter raceFilter) { try { return(await this._race.GetRaceDetails(raceFilter)); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> GetRaceDetails([FromBody] RaceFilter raceFilter) { try { return(Ok(this.Content(JsonConvert.SerializeObject(await _race.GetRaceDetails(raceFilter)), "application/json"))); } catch (Exception ex) { //ExceptionLog exception = await _exceptionService.UpsertException(ex, "GetUserRoles", "",""); return(StatusCode((int)HttpStatusCode.InternalServerError, new CustomMesageError(ex.Message).Message)); } }
public async Task <DataTable> GetRaceEntry(RaceFilter raceFilter) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("RaceDetailsGetbyKeys", raceFilter.ClubName, raceFilter.DbName); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@ClubID", 0); dbconn.sqlComm.Parameters.AddWithValue("@ClubName", raceFilter.ClubName); dbconn.sqlComm.Parameters.AddWithValue("@ReleaseDate", raceFilter.DateRelease); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategory", raceFilter.Category); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroup", raceFilter.Group); dbconn.sqlComm.Parameters.AddWithValue("@Version", 0); dbconn.sqlComm.Parameters.AddWithValue("@Name", raceFilter.FilterName); dbconn.sqlComm.Parameters.AddWithValue("@IsFromWeb", 1); dbconn.sqlComm.Parameters.AddWithValue("@Sender", raceFilter.MobileNumber); dbconn.sqlComm.Parameters.AddWithValue("@Source", raceFilter.Source); dbconn.sqlComm.Parameters.AddWithValue("@UserID", raceFilter.UserID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task <DataTable> .FromResult(dataResult.Tables[1])); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public RaceItems GetRaceItems(int userId, int contextOrganizationId, RaceFilter filter) { var parameters = new { userId, contextOrganizationId, filter.EntityStateIds, filter.Search, filter.Skip, filter.Take }; return(ExecuteMultiResultSetSp <RaceItems>("[race].[spGetRaceItems]", parameters)); }