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));
}
