public void OddsMakingTest()
{
RaceCourse rc = new RaceCourse();
//OddsMakingForBoat now in Boat Class after testing
Assert.AreEqual(4, rc.OddsMakingForBoat(22));
}
public void InsertExistingRaceCoursesIntoDB() //REFACTOR TO ADD RC
{
//Add if file exists? May not need if this only fires once
using (dbConnection)
{
string insertExistingRaceCourseName = "INSERT INTO Racecourses(RaceCourseName) VALUES (@courseName);";
SqliteCommand cmdInsertRaceCourseNames = new SqliteCommand(insertExistingRaceCourseName, dbConnection);
SqliteParameter courseName = new SqliteParameter("@courseName", SqliteType.Text);
cmdInsertRaceCourseNames.Parameters.Add(courseName);
RaceCourse rc = new RaceCourse();
try
{
dbConnection.Open();
foreach (var item in rc.ExistingRaceCourseNames())
{
courseName.Value = item;
cmdInsertRaceCourseNames.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
}
}
public void CurrentConditionTest1()
{
RaceCourse rc = new RaceCourse();
rc.WaterCurrent = 3;
rc.WaterCurrentDirection = 1;
Assert.AreEqual(0.1, rc.WaterCurrentCondition(2));
}
public void NewLegDirectionTest()
{
//boat changes direction whenever it goes into a turn
RaceCourse rc = new RaceCourse();
int newDirection = rc.NewLegDirection(4);
Assert.AreEqual(1, newDirection, "direction should change from 4 to 1");
}
public static RaceCourse BuildCourse(string name, string address = "", int? phoneNumber = null)
{
var course = new RaceCourse()
{
CourseName = name,
CourseAddress = address,
CoursePhone = phoneNumber
};
return course;
}
public void CurrentBoatSpeedTest()
{
RaceCourse rc = new RaceCourse();
List <Boat> rBoats = BoatRace.Program.CreateTheBoats("SpeedBoat", 4);
rBoats[0].EngineHorsepower = rBoats[0].Horsepower(rBoats[0].GetType().Name);
double result = rc.CurrentBoatSpeed(rc, 1, 0, 1, rBoats[0]);
Console.WriteLine(result);
Assert.IsTrue(result > 0);
}
public void RaceCourseTestForZeroWind()
{
RaceCourse rc = new RaceCourse();
rc.Wind = 0;
rc.WindDirection = 1;
rc.StartDirection = 2;
rc.CourseLeg(1, 3, 1);
//Console.WriteLine(rc.StartDirection);
Assert.AreEqual("Wind has no effect on Boat movement.", rc.WindReport);
}
public void RaceSimResultsTest()
{
RaceCourse rc = new RaceCourse();
List <Boat> rBoats = BoatRace.Program.CreateTheBoats("SpeedBoat", 4);
BoatRace.Program.AssignBoatProperties(rBoats);
for (int i = 0; i < rBoats.Count; i++)
{
rBoats[i].Name = "boat" + (i + 1);
rc.RaceSimResults.Add(rBoats[i].Name, 0);
}
rc.RaceSim(rBoats, rc, "Straight", 0, 1000);
}
public void TestRaceCourseListFromExistingDataIsAsExpected()
{
List <string> expectedNames = new List <string> {
"Aintree", "Ascot", "Ayr", "Bangor", "Chester", "Cork",
"Doncaster", "Dundalk", "Fairyhouse", "Goodwood", "Haydock", "Kelso", "Kilbeggan",
"Perth", "Punchestown", "Sandown", "Towcester", "York"
};
RaceCourse rc = new RaceCourse();
List <string> actualNames = rc.ExistingRaceCourseNames();
CollectionAssert.AreEquivalent(expectedNames, actualNames); //order not relevant
CollectionAssert.AreEqual(expectedNames, actualNames); // order must be the same
}
public void CheckWinningsTest()
{
RaceCourse rc = new RaceCourse();
Boat sb = new SailBoat(1, "sloop", "diesel", 30, true);
List <Boat> rBoats = BoatRace.Program.CreateTheBoats("SpeedBoat", 4);
Gambler player = new Gambler();
player.Winnings = 500;
player.Wager = 500;
//OddsToWin moved to Boat Class after testing
sb.OddsToWin = 2;
BoatRace.Program.CheckWinnings(rBoats, rc, 3, player);
Assert.IsTrue(player.Winnings == 1000);
}
public void check18RaceCourseNamesAddedToDB()
{
List <RaceCourse> expectedListRaceCourses = new List <RaceCourse>();
List <string> expectedNames = new List <string> {
"Aintree", "Ascot", "Ayr", "Bangor", "Chester", "Cork",
"Doncaster", "Dundalk", "Fairyhouse", "Goodwood", "Haydock", "Kelso", "Kilbeggan",
"Perth", "Punchestown", "Sandown", "Towcester", "York"
};
int idReference = 1;
foreach (var name in expectedNames)
{
RaceCourse rc = new RaceCourse();
rc.RaceCourseID = idReference;
rc.RaceCourseName = name;
expectedListRaceCourses.Add(rc);
idReference++;
}
List <RaceCourse> ActualRaceCourseList = new List <RaceCourse>();
SqliteConnection dbConnection = new SqliteConnection("Filename=HotTipster.db");
using (dbConnection)
{
dbConnection.Open();
dataWriter.InsertExistingRaceCoursesIntoDB();
ActualRaceCourseList = ReadWriteToSQLite.RetrieveRaceCourseNamesFromDB();
dbConnection.Close();
}
int expectedLength = expectedListRaceCourses.Count; //number of unique racecourse names in historic data
int actualLenght = ActualRaceCourseList.Count;
Assert.AreEqual(expectedLength, actualLenght);
Assert.AreEqual(expectedListRaceCourses[0].RaceCourseID, ActualRaceCourseList[0].RaceCourseID);
Assert.AreEqual(expectedListRaceCourses[0].RaceCourseName, ActualRaceCourseList[0].RaceCourseName);
Assert.AreEqual(expectedListRaceCourses[0].RaceCourseName, "Aintree");
Assert.IsInstanceOfType(ActualRaceCourseList[0], typeof(RaceCourse));
Assert.IsInstanceOfType(expectedListRaceCourses[0], typeof(RaceCourse));
//CollectionAssert.AreEquivalent(expectedListRaceCourses, ActualRaceCourseList, "Message",new RaceCourseComparer()); can't get this to pass even though both lists are the same
}
public static List <RaceCourse> RetrieveRaceCourseNamesFromDB()
{
string query = "SELECT RaceCourseID, RaceCourseName FROM Racecourses";
SqliteCommand cmdselectCourseNames = new SqliteCommand(query, dbConnection);
List <RaceCourse> rcList = new List <RaceCourse>();
using (dbConnection)
{
dbConnection.Open();
SqliteDataReader results = cmdselectCourseNames.ExecuteReader();
while (results.Read())
{
RaceCourse rc = new RaceCourse();
rc.RaceCourseID = results.GetInt32(0);
rc.RaceCourseName = results.GetString(1);
rcList.Add(rc);
}
}
return(rcList);
}
public ViewResult MeetingDetails(int id)
{
Meeting meeting = SessionService.DbContainer.Resolve <MeetingDataManager>().GetById(id);
var model = new MeetingsDetailsModel();
model.MeetingId = id;
Country country = SessionService.DbContainer.Resolve <CountrysDataManager>().GetById(meeting.CountryId);
model.CountryCode = country == null?"":country.Code;
RaceCourse raceCourse = SessionService.DbContainer.Resolve <RacecourseDataManager>().GetById(meeting.RaceCourseId);
model.RaceCourseCode = raceCourse == null?"":raceCourse.Code;;
model.Date = meeting.MeetingDate.ToShortDateString();
Weather weather = SessionService.DbContainer.Resolve <WeatherDataManager>().GetById(meeting.WeatherId);
model.WeatherName = weather == null?"":weather.Name;
Going going = SessionService.DbContainer.Resolve <GoingDataManager>().GetById(meeting.DefaultGoingId);
model.GoingName = going == null?"":going.Name;
model.DayNight = model.CountryCode.Contains("HK")?((meeting.HK_isNightMeet != null && (bool)meeting.HK_isNightMeet)?MeetingType.nigth.ToString():MeetingType.day.ToString()):string.Empty;
CourseVariant courseVariant = SessionService.DbContainer.Resolve <CourseVariantDataManager>().GetById(meeting.CourseVariantId);
model.CourseVariantName = courseVariant == null?"":courseVariant.Name;
model.NumberOfRaces = SessionService.DbContainer.Resolve <MeetingDataManager>().GetById(id).NumberOfRaces;
model.Races = SessionService.DbContainer.Resolve <RaceDataManager>().GetByMeetingId(id);
return(View("Details", model));
}
public void TestRaceCourseClassExists()
{
RaceCourse rc = new RaceCourse("Aintree");
Assert.IsInstanceOfType(rc, typeof(RaceCourse));
}
