Exemple #1
0
        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());
        }
Exemple #2
0
 public async Task <DataTable> GetRaceEntry(RaceFilter raceFilter)
 {
     try
     {
         return(await this._race.GetRaceEntry(raceFilter));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemple #3
0
 public async Task <DataSet> GetRaceDetails(RaceFilter raceFilter)
 {
     try
     {
         return(await this._race.GetRaceDetails(raceFilter));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemple #4
0
 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));
     }
 }
Exemple #5
0
        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);
            }
        }
Exemple #6
0
        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));
        }