public void AddNewRace(RaceCreateViewModel model)
{
using (var unit = new UnitOfWork())
{
var race = new Race
{
DateTimeOfRace = DateTime.Parse(model.DateTimeOfRace),
NumberRaceInDay = Convert.ToInt32(model.NumberRaceInDay)
};
unit.Race.Save(race);
foreach (var viewModel in model.Participants)
{
var racer = unit.Racer.Get(viewModel.RacerId);
var participant = new Participant
{
Race = race,
Racer = racer,
NumberInRace = viewModel.NumberInRace,
PlaceInRace = viewModel.PlaceInRace
};
unit.Participant.Save(participant);
}
}
}
public Role GetUserRole(string username)
{
using (var unit = new UnitOfWork())
{
var user = unit.User.GetUserByUsername(username);
return user.Role;
}
}
public IList<Horse> GetListHorses()
{
using (var unit = new UnitOfWork())
{
var horses = unit.Horse.GetAllHorses();
return horses;
}
}
public void DeleteHorse(int id)
{
using (var unit = new UnitOfWork())
{
var horse = unit.Horse.Get(id);
unit.Horse.Delete(horse);
}
}
public bool IsUserInRole(string username, string roleName)
{
using (var unit = new UnitOfWork())
{
var user = unit.User.GetUserByUsername(username);
var isUserInRole = user.Role.Name.ToUpperInvariant() == roleName.ToUpperInvariant();
return isUserInRole;
}
}
public void EditHorse(HorseViewModel model)
{
using (var unit = new UnitOfWork())
{
var horse = unit.Horse.Get(model.HorseId);
horse.Nickname = model.Nickname;
horse.DateBirth = DateTime.Parse(model.DateBirth);
unit.Horse.Save(horse);
}
}
public IList<RacerViewModel> GetListRacers()
{
var list = new List<RacerViewModel>();
using (var unit = new UnitOfWork())
{
var racers = unit.Racer.LoadRacers(new RacerFilter { WithHorse = true });
list.AddRange(racers.Select(getRacerViewModel));
return list;
}
}
public void AddNewHorse(HorseViewModel model)
{
using (var unit = new UnitOfWork())
{
var horse = new Horse
{
Nickname = model.Nickname,
DateBirth = DateTime.Parse(model.DateBirth)
};
unit.Horse.Save(horse);
}
}
public void EditJockey(JockeyViewModel model)
{
using (var unit = new UnitOfWork())
{
var jockey = unit.Jockey.Get(model.JockeyId);
jockey.Alias = model.Alias;
jockey.DateBirth = DateTime.Parse(model.DateBirth);
jockey.FirstName = model.FirstName;
jockey.LastName = model.LastName;
jockey.MiddleName = model.LastName;
unit.Jockey.Save(jockey);
}
}
public void ChangePassword(int userId, string password)
{
using (var unit = new UnitOfWork())
{
var user = unit.User.Get(userId);
var salt = _cryptoProvider.CreateSalt();
user.Password = new Credentials
{
Salt = salt,
PasswordHash = _cryptoProvider.CreateCryptoPassword(password, salt)
};
unit.User.SaveUser(user);
}
}
public HorseViewModel GetHorseDetails(int id)
{
using (var unit = new UnitOfWork())
{
var horse = unit.Horse.Get(id);
var model = new HorseViewModel
{
HorseId = horse.Id,
DateBirth = _generalService.GetDateTimeStringForDatepicker(horse.DateBirth),
Nickname = horse.Nickname
};
return model;
}
}
public void AddNewJockey(JockeyViewModel model)
{
using (var unit = new UnitOfWork())
{
var jockey = new Jockey
{
Alias = model.Alias,
DateBirth = DateTime.Parse(model.DateBirth),
FirstName = model.FirstName,
LastName = model.LastName,
MiddleName = model.MiddleName
};
unit.Jockey.Save(jockey);
}
}
public void AddNewRacer(RacerCreateViewModel model)
{
using (var unit = new UnitOfWork())
{
var horse = unit.Horse.Get(model.SelectedHorseId);
var jockey = unit.Jockey.Get(model.SelectedJockeyId);
var racer = new Racer
{
Horse = horse,
Jockey = jockey,
DateTimeStart = model.StartDateTime
};
unit.Racer.Save(racer);
}
}
public RacerCreateViewModel GetRacerCreateViewModel()
{
var model = new RacerCreateViewModel();
using (var unit = new UnitOfWork())
{
var horses = unit.Horse.GetAllHorses();
var jockeys = unit.Jockey.GetAllJockeys();
var listHorses = getHorsesListForDropdown(horses);
var listJockeys = getJockeysListForDropdown(jockeys);
model.ListHorsesForDropDown = listHorses;
model.ListJockeysForDropDown = listJockeys;
}
return model;
}
public List<HorseParticipationViewModel> SelectHorseParticipation()
{
var model = new List<HorseParticipationViewModel>();
using (var unit = new UnitOfWork())
{
var allHorses = unit.Horse.GetAllHorses();
var participants = unit.Participant.LoadParticipants(new ParticipantFilter {WithHorse = true});
model.AddRange(allHorses.Select(horse => new HorseParticipationViewModel
{
HorseId = horse.Id,
HorseNickname = horse.Nickname,
RaceQuantity = participants.Count(x => x.Racer.HorseId == horse.Id)
}));
}
return model;
}
public JockeyViewModel GetJockeyDetails(int id)
{
using (var unit = new UnitOfWork())
{
var jockey = unit.Jockey.Get(id);
var model = new JockeyViewModel
{
JockeyId = jockey.Id,
Alias = jockey.Alias,
DateBirth = _generalService.GetDateTimeStringForDatepicker(jockey.DateBirth),
FirstName = jockey.FirstName,
LastName = jockey.LastName,
MiddleName = jockey.MiddleName
};
return model;
}
}
public RacerDetailsViewModel GetRacerDetails(int id)
{
using (var unit = new UnitOfWork())
{
var racer = unit.Racer.Get(id);
var model = new RacerDetailsViewModel
{
RacerId = racer.Id,
HorseNickname = racer.Horse.Nickname,
JockeyAlias = racer.Jockey.Alias,
JokeyFullName = racer.Jockey.FullName,
RacerDateTimeEnd = racer.DateTimeEnd.HasValue ? ((DateTime)racer.DateTimeEnd).ToShortDateString() : "-",
RacerDateTimeStart = racer.DateTimeStart.ToShortDateString()
};
return model;
}
}
public IEnumerable<JockeyViewModel> GetListJokeys()
{
using (var unit = new UnitOfWork())
{
var jockeys = unit.Jockey.GetAllJockeys();
var jockeysList = jockeys.Select(
jockey => new JockeyViewModel
{
Alias = jockey.Alias,
DateBirth = _generalService.GetDateTimeStringForDatepicker(jockey.DateBirth),
FirstName = jockey.FirstName,
JockeyId = jockey.Id,
LastName = jockey.LastName,
MiddleName = jockey.MiddleName
});
return jockeysList;
}
}
public RacerEditViewModel GetRacerEditModel(int id)
{
using (var unit = new UnitOfWork())
{
var racer = unit.Racer.Get(id);
var horses = unit.Horse.GetAllHorses();
var jockeys = unit.Jockey.GetAllJockeys();
var model = new RacerEditViewModel
{
RacerId = racer.Id,
StartDateTime = racer.DateTimeStart,
ListHorsesForDropDown = getHorsesListForDropdown(horses),
ListJockeysForDropDown = getJockeysListForDropdown(jockeys),
SelectedHorseId = racer.Horse.Id,
SelectedJockeyId = racer.Jockey.Id,
EndDateTime = racer.DateTimeEnd
};
return model;
}
}
public RaceCreateViewModel GetRaceCreateViewModel(DateTime dateTime, string numberInDay = null)
{
using (var unit = new UnitOfWork())
{
var model = new RaceCreateViewModel();
var participants = unit.Racer.LoadRacers(
new RacerFilter
{
WithHorse = true,
WithJockey = true
});
model.ListParticipantsForDropdown = getPartisipantsListForDropdown(participants);
model.DateTimeOfRace = dateTime.ToString("MM-dd-yyyy");
if (!string.IsNullOrWhiteSpace(numberInDay))
{
model.NumberRaceInDay = numberInDay;
}
return model;
}
}
public IEnumerable<RaceViewModel> GetListRaces()
{
using (var unit = new UnitOfWork())
{
var model = new List<RaceViewModel>();
var allRaces = unit.Race.GetAllRaces();
foreach (var race in allRaces)
{
var participants = getParticipantsViewModelsList(unit, race.Id);
model.Add(
new RaceViewModel
{
RaceId = race.Id,
RaceDateTime = _generalService.GetDateTimeStringForDatepicker(race.DateTimeOfRace),
RaceNumberInDay = race.NumberRaceInDay.ToString(CultureInfo.InvariantCulture),
Participants = participants
});
}
return model;
}
}
public List<ParticipantViewModel> GetParticipantsForRace(DateTime raceDate, int raceNumber)
{
using (var unit = new UnitOfWork())
{
var race = unit.Race.GetRace(raceDate, raceNumber);
if (race == null)
{
return null;
}
var list = getParticipantsViewModelsList(unit, race.Id);
return list;
}
}
public void DeleteJockey(int id)
{
using (var unit = new UnitOfWork())
{
var jockey = unit.Jockey.Get(id);
unit.Jockey.Delete(jockey);
}
}
public List<WinnerJockeyForYearViewModel> GetWinnerJokeysForYear(int year)
{
using (var unit = new UnitOfWork())
{
var participants = unit.Participant.GetWinnersForYear(year);
var model = participants.Select(participant => new WinnerJockeyForYearViewModel
{
JockeyId = participant.Racer.JockeyId,
JockeyAlias = participant.Racer.Jockey.Alias,
QuantityWinnerRaces = unit.Participant.GetCountWinnerRaces(participant.Id),
JockeyFullName = participant.Racer.Jockey.FullName
}).OrderByDescending(x => x.JockeyFullName).ToList();
return model;
}
}
public RaceDetailsViewModel GetRaceDetailsViewModel(int id)
{
using (var unit = new UnitOfWork())
{
var race = unit.Race.Get(id);
var model = getRaceDetailsViewModelWithoutParticipants(race);
model.Participants = new List<ParticipantViewModel>();
var participants = unit.Participant.LoadParticipants(new ParticipantFilter { RaceId = race.Id, WithRacerHorceAndJockey = true });
foreach (var participant in participants)
{
model.Participants.Add(new ParticipantViewModel
{
HorseId = participant.Racer.Horse.Id,
HorseNickname = participant.Racer.Horse.Nickname,
ParticipantId = participant.Id,
RacerId = participant.Racer.Id,
JockeyId = participant.Racer.Jockey.Id,
JockeyAlias = participant.Racer.Jockey.Alias,
NumberInRace = participant.NumberInRace,
PlaceInRace = participant.PlaceInRace
});
}
return model;
}
}
public void EditRace(RaceDetailsViewModel model)
{
using (var unit = new UnitOfWork())
{
var loadParticipants = unit.Participant.LoadParticipants(new ParticipantFilter { RaceId = model.RaceId });
foreach (var participantViewModel in model.Participants)
{
var viewModel = participantViewModel;
foreach (var participant in loadParticipants.Where(participant => viewModel.ParticipantId == participant.Id))
{
participant.NumberInRace = participantViewModel.NumberInRace;
participant.PlaceInRace = participantViewModel.PlaceInRace;
unit.Participant.Save(participant);
break;
}
}
}
}
public void DeleteRace(int id)
{
using (var unit = new UnitOfWork())
{
var race = unit.Race.Get(id);
var loadParticipants = unit.Participant.LoadParticipants(new ParticipantFilter { RaceId = race.Id });
foreach (var participant in loadParticipants)
{
unit.Participant.Delete(participant);
}
unit.Race.Delete(race);
}
}
public List<WinnersViewModel> SelectWinners(int quantityParticipants)
{
using (var unit = new UnitOfWork())
{
var participants = unit.Participant.LoadParticipants(new ParticipantFilter { WithHorse = true, WithJockey = true });
var models = new List<WinnersViewModel>();
foreach (var participant in participants)
{
var countWinnerRaces = unit.Participant.GetCountWinnerRaces(participant.Id);
if (countWinnerRaces > 0)
{
models.Add(new WinnersViewModel
{
HorseNickname = participant.Racer.Horse.Nickname,
JockeyAlias = participant.Racer.Jockey.Alias,
CountWinnerRaces = countWinnerRaces
});
}
}
var list = models.OrderByDescending(x => x.CountWinnerRaces).Take(quantityParticipants).ToList();
return list;
}
}
public List<RaceDetailsViewModel> GetRaces(DateTime date)
{
using (var unit = new UnitOfWork())
{
var races = unit.Race.GetRacesListForMonth(date);
return races.Select(getRaceDetailsViewModelWithoutParticipants).ToList();
}
}
private List<ParticipantViewModel> getParticipantsViewModelsList(UnitOfWork unit, int id)
{
var loadParticipants = unit.Participant.LoadParticipants(
new ParticipantFilter
{
RaceId = id,
WithJockey = true,
WithHorse = true
});
return loadParticipants.Select(participant =>
new ParticipantViewModel
{
HorseId = participant.Racer.HorseId,
HorseNickname = participant.Racer.Horse.Nickname,
JockeyId = participant.Racer.JockeyId,
JockeyAlias = participant.Racer.Jockey.Alias,
ParticipantId = participant.Id,
NumberInRace = participant.NumberInRace,
PlaceInRace = participant.PlaceInRace
}).ToList();
}