private void PopulateEventComboBox()
{
SqlCeConnection Connection = DataBaseConnection.Instance.Connection;
EventViewComboBox.Items.Clear();
SqlCeCommand cmd = Connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Event";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
int team1 = Int16.Parse(dr["Team_Id"].ToString());
int team2 = Int16.Parse(dr["Team_Id1"].ToString());
int game1 = Int16.Parse(dr["Game_type_Id"].ToString());
int sport1 = Int16.Parse(dr["Sport_Id"].ToString());
int leage1 = Int16.Parse(dr["League_Id"].ToString());
string team11 = TeamRepository.GetTeamNameById(team1);
string team22 = TeamRepository.GetTeamNameById(team2);
string game11 = GameTypeRepository.GetGameTypeMarkById(game1);
string sport11 = SportRepository.GetSportNameById(sport1);
string league11 = LeagueRepository.GetLeagueNameById(leage1);
EventViewComboBox.Items.Add(sport11 + " - " + league11 + " - " + team11 + " - " + team22 + " - " + dr["Time"].ToString() + " - " + game11 + " - " + dr["Quota"].ToString() + "KM ");
}
EventViewComboBox.SelectedIndex = 0;
}
public NotConnected(BspServerState state, BspSender sender,
GameTypeRepository gameTypeRepo, UserRepository userRepo)
{
_state = state;
_sender = sender;
_gameTypeRepo = gameTypeRepo;
_userRepo = userRepo;
}
public WaitingForBoard(BspServerState state, BspSender sender,
GameTypeRepository gameTypeRepo, MatchMaker matchMaker)
{
_state = state;
_sender = sender;
_gameTypeRepo = gameTypeRepo;
_matchMaker = matchMaker;
}
public void SelectList_returns_more_than_one_record()
{
// Arrange
// Act
var dbModel = new GameTypeRepository().SelectList();
// Assert
Assert.IsTrue(dbModel.Count > 0);
}
/// <summary>
/// Create a basic repository for GameTypes
/// </summary>
/// <returns>A small GameTypeRepository</returns>
private static GameTypeRepository CreateGameTypeRepository()
{
var repo = new GameTypeRepository();
repo.TryAdd(new GameType(1, 15, 15, new byte[] { 2 }));
repo.TryAdd(new GameType(2, 5, 5, new byte[] { 1 }));
repo.TryAdd(new GameType(3, 10, 10, new byte[] { 3, 2, 1 }));
return(repo);
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (MarkTextBox.Text == "")
{
MessageBox.Show("Unesite vrstu igre!");
}
else
{
string text = MarkTextBox.Text;
GameTypeRepository.AddGameType(text);
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
SqlCeConnection Connection = DataBaseConnection.Instance.Connection;
try
{
if (QuotaTextBox.Text == "")
{
MessageBox.Show("Uneste iznos kvote!");
}
else if (EventDateTimePicker.Text == "")
{
MessageBox.Show("Unesite vrijeme dogadjaja!");
}
else
{
int SportID = SportRepository.GetIdByNameSport(SportIDComboBox.Text);
int TeamID = TeamRepository.GetIdByNameTeam(TeamIDComboBox.Text);
int LeagueID = LeagueRepository.GetIdByNameLeague(LeagueIDComboBox.Text);
int GameTypeID = GameTypeRepository.GetIdByNameGameType(GameTypeIDComboBox.Text);
int TeamID1 = TeamRepository.GetIdByNameTeam(TeamID1ComboBox.Text);
SqlCeCommand command1 = new SqlCeCommand("INSERT INTO Event (Sport_Id, Team_Id, Time, League_Id, Game_type_Id, Quota, Team_Id1) VALUES" + " ('" + SportID + "', '" + TeamID + "', '" + EventDateTimePicker.Value.Date.ToString("yyyy-MM-dd") + "', '" + LeagueID + "', '" + GameTypeID + "', '" + QuotaTextBox.Text + "', '" + TeamID1 + "'); ", Connection);
/*SqlCeCommand command1 = new SqlCeCommand(@"INSERT INTO Event (Sport_Id, Team_Id, Time, League_Id, Game_type_Id, Quota, Team_Id1) VALUES (@sportId, @teamId, @time, @leagueId, @gameTypeId, @quota, @teamId1)", Connection);
* command1.Parameters.AddWithValue("@sportId", SportID);
* command1.Parameters.AddWithValue("@teamId", TeamID);
* command1.Parameters.AddWithValue("@time", DateTime.Now.Date.ToString());
* command1.Parameters.AddWithValue("@leagueId", LeagueID);
* command1.Parameters.AddWithValue("@gameTypeId", GameTypeID);
* command1.Parameters.AddWithValue("@quota", QuotaTextBox.Text);
* command1.Parameters.AddWithValue("@teamId1", TeamID1);*/
command1.ExecuteNonQuery();
MessageBox.Show("Unos je uspio!");
QuotaTextBox.Clear();
QuotaTextBox.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("Unos nije uspio! \r Greska: " + ex.Message);
return;
}
}
public void Insert_returns_new_id_with_value_greater_than_zero()
{
// Arrange
var dbModel = new GameTypeModel
{
Name = "Test value",
Description = "Some test description"
};
// Act
var newId = new GameTypeRepository().Insert(dbModel);
// Assert
Assert.IsTrue(newId > 0);
}
public ServerNetworkStateContainer(BspSender sender, IBspDisconnecter disconnecter,
GameTypeRepository gameTypeRepo, UserRepository userRepo, MatchMaker matchMaker)
{
var state = new BspServerState();
NotConnected = new NotConnected(state, sender, gameTypeRepo, userRepo);
PendingLogOn = new PendingLogOn();
WaitingForBoard = new WaitingForBoard(state, sender, gameTypeRepo, matchMaker);
PendingBoard = new PendingBoard();
WaitingForGame = new WaitingForGame(state, sender, disconnecter, userRepo);
FoundGame = new FoundGame(state, sender, disconnecter, userRepo);
InitialGame = new InitialGame();
MyTurn = new MyTurn(state, sender, disconnecter, userRepo);
TheirTurn = new TheirTurn();
Waiting = new Waiting();
}
private void DeleteGameTypeButton_Click(object sender, EventArgs e)
{
SqlCeConnection Connection = DataBaseConnection.Instance.Connection;
DialogResult dr = MessageBox.Show("Da li želite da izbrišete ?", "Brisanje", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
string name = GameTypeViewComboBox.SelectedItem.ToString();
GameTypeRepository.DeleteDataGameType(name);
GameTypeViewComboBox.Items.Remove(GameTypeViewComboBox.SelectedItem);
}
else if (dr == DialogResult.No)
{
}
}
