public void LoadData()
{
Sqlconnect c = new Sqlconnect();
c.query = "Exec LineUp_Select " + team_id;
dvgLineUP.DataSource = c.Select();
dvgLineUP.Columns["Команда"].Visible = false;
dvgLineUP.Columns["Тренер"].Visible = false;
dvgLineUP.Columns["ID"].Visible = false;
dvgLineUP.Columns["IDCOACH"].Visible = false;
dvgLineUP.Columns["IDPLAYER"].Visible = false;
lblNameTeam.Text = dvgLineUP.Rows[0].Cells[0].Value.ToString();
lblNameCoach.Text = dvgLineUP.Rows[0].Cells[1].Value.ToString();
switch (int.Parse(team_id))
{
case 1: pctLogo.Image = Logos.Avangard_Omsk_logo; break;
case 2: pctLogo.Image = Logos.Avtomobilist_Yekaterinburg_Logo; break;
case 3: pctLogo.Image = Logos.Admiral_01; break;
case 4: pctLogo.Image = Logos.Ak_Bars_Kazan_Logo; break;
case 5: pctLogo.Image = Logos.Vityaz; break;
case 6: pctLogo.Image = Logos.Dinamo_Minsk; break;
case 7: pctLogo.Image = Logos.Dinamo_msk; break;
case 8: pctLogo.Image = Logos.Dinamo_riga; break;
case 9: pctLogo.Image = Logos.kunlun_red_star; break;
case 10: pctLogo.Image = Logos.metallurg_magnitogorsk; break;
case 11: pctLogo.Image = Logos.HC_Neftekhimik_logo; break;
case 12: pctLogo.Image = Logos.Salavat_ulaev; break;
case 13: pctLogo.Image = Logos.slovan_bratislava_min; break;
case 14: pctLogo.Image = Logos.Severstal_Cherepovets; break;
case 15: pctLogo.Image = Logos.SKA_2015; break;
case 16: pctLogo.Image = Logos.sibir_novosibirskaya; break;
case 17: pctLogo.Image = Logos.HC_Spartak_Moscow; break;
case 18: pctLogo.Image = Logos.torpedo; break;
case 19: pctLogo.Image = Logos.Traktor; break;
case 20: pctLogo.Image = Logos.Cska; break;
default:
pctLogo.Image = Logos.NoLogo;
break;
}
}
public void LoadData()
{
Sqlconnect c = new Sqlconnect();
c.query = "Exec Players_Select";
DataGridPlayers.DataSource = c.Select();
}
public void LoadData()
{
Sqlconnect c = new Sqlconnect();
c.query = "exec stats_select";
DataGridStats.DataSource = c.Select();
}
private void btnLogin_Click(object sender, EventArgs e)
{
//ДОРАБОТАТЬ ВЗАИМОДЕЙСТВИЕ С TEXTBOX
connected = false;
Sqlconnect SQLhelp = new Sqlconnect();
SQLhelp.connection = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3};", cmbServer.selectedValue, txtNameDataBase.Text, txtLogin.Text, txtPassword.Text);
try
{
SQLhelp.sqlConnect();
if (SQLhelp.IsConnection)
{
AppSetting setting = new AppSetting();
setting.SaveConnectionString("cn", SQLhelp.connection);
MessageBox.Show("Ваша строка подключения успешно сохранена.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
connected = true;
SQLhelp.ConnectClose();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Close();
}
public void LoadData()
{
Sqlconnect c = new Sqlconnect();
c.query = "exec Games_Select";
DataGridGames.DataSource = c.Select();
}
public void LoadData()
{
Sqlconnect c = new Sqlconnect();
c.query = "Exec Coachs_Select";
DataGridCoachs.DataSource = c.Select();
}
private void btnDeletePlayer_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Удалить игрока " + dvgLineUP.CurrentRow.Cells["Игрок"].Value.ToString(), "Подтверждение удаления",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Sqlconnect LP = new Sqlconnect();
LP.id_lineup = (int)dvgLineUP.CurrentRow.Cells["ID"].Value;
LP.Delete_LineUP();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
LoadData();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string messege = string.Format("Удалить игрока {0} {1}", DataGridPlayers.CurrentRow.Cells[1].Value.ToString(), DataGridPlayers.CurrentRow.Cells[2].Value.ToString());
if (MessageBox.Show(messege, "Подтверждение удаления",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Sqlconnect CP = new Sqlconnect();
CP.id_player = (int)DataGridPlayers.CurrentRow.Cells[0].Value;
CP.Delete_Player();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
LoadData();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string messege = string.Format("Удалить команду {0}", DataGridTeams.CurrentRow.Cells[1].Value.ToString());
if (MessageBox.Show(messege, "Подтверждение удаления",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Sqlconnect CT = new Sqlconnect();
CT.id_team = (int)DataGridTeams.CurrentRow.Cells[0].Value;
CT.Delete_Team();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
LoadData();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string messege = string.Format("Удалить игру №{0} между командами {1} и {2}", DataGridGames.CurrentRow.Cells[0].Value.ToString(),
DataGridGames.CurrentRow.Cells[4].Value.ToString(), DataGridGames.CurrentRow.Cells[5].Value.ToString());
if (MessageBox.Show(messege, "Подтверждение удаления",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Sqlconnect CG = new Sqlconnect();
CG.id_games = (int)DataGridGames.CurrentRow.Cells[0].Value;
CG.Delete_Game();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
LoadData();
}
}
