private void FormEditPlayer_Load(object sender, EventArgs e)
{
WorkWithBD.ReadTeamOfDatabaseInComboBox(comboBox1);
WorkWithBD.ReadPositionOfDatabaseInComboBox(comboBox2);
comboBox1.SelectedIndex = comboBox1.Items.IndexOf(Team);
comboBox2.SelectedIndex = comboBox2.Items.IndexOf(Position);
}
private void start()
{
RatingCB.Items.Add(" ");
for (int i = 1; i <= 10; i++)
{
RatingCB.Items.Add(i.ToString());
}
DataSet User = new DataSet();
string sql = "SELECT GroupNameID FROM GroupName WHERE Name='" + MainWindow.NameGroup + "'";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
var id = User.Tables[0].DefaultView[0].Row[0].ToString();
sql = "SELECT FIO FROM Student WHERE GroupNameID = '" + id.ToString() + "'";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
FIOCB.Items.Add(User.Tables[0].DefaultView[i].Row[0].ToString());
}
try
{
FIOCB.Text = UCLogs.row.Row.ItemArray[1].ToString();
DayB.Text = (UCLogs.row.Row.ItemArray[2].ToString()).Split(' ')[0];
MissedChB.IsChecked = (UCLogs.row.Row.ItemArray[3].ToString() == "н") ? true:false;
RatingCB.Text = UCLogs.row.Row.ItemArray[4].ToString();
}
catch { MessageBox.Show("Не выбран учащийся"); Close(); }
}
private void AddBN_Click(object sender, RoutedEventArgs e) // поставить ифы на сравнение, если учитель, совпадение имени учителя в комбобоксе и логина
{
//try
//{
DataSet User = new DataSet();
string sql = "SELECT [Login], [Password], Users.EmployeeID, Users.Access, Users.StudentID, " +
"Employee.FIOEmployee, Student.FIO, GroupName.Name, GroupName.GroupNameID " +
"FROM Users " +
"FULL OUTER JOIN Employee ON (Users.EmployeeID=Employee.EmployeeID) " +
"FULL OUTER JOIN Student ON (Users.StudentID=Student.StudentID) " +
"FULL OUTER JOIN GroupName ON (Student.GroupNameID=GroupName.GroupNameID)";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
if (LoginTB.Text == User.Tables[0].DefaultView[i].Row[0].ToString() && PasswordTB.Password.ToString() == User.Tables[0].DefaultView[i].Row[1].ToString())
{
MainWindow.Access = User.Tables[0].DefaultView[i].Row[3].ToString();
MainWindow.NAME = User.Tables[0].DefaultView[i].Row[5].ToString();
MainWindow.GroupNameID = User.Tables[0].DefaultView[i].Row[8].ToString();
MainWindow.StudentID = User.Tables[0].DefaultView[i].Row[4].ToString();
Close();
}
}
if (MainWindow.Access == "")
{
MessageBox.Show("Неверный логин или пароль.");
}
//}
//catch { MessageBox.Show("Заполните поля"); }
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.EditTeam(Id, textBox1.Text, Convert.ToString(numericUpDown1.Value));
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.EditCoach(Id, textBox1.Text, textBox2.Text, textBox3.Text, numericUpDown1.Value.ToString(), comboBox1.Text);
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.AddPlayer(textBox1.Text, textBox2.Text, textBox3.Text, comboBox1.Text, comboBox2.Text, Convert.ToString(numericUpDown1.Value));
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.EditPlay(Id, comboBox1.Text, Convert.ToString(numericUpDown1.Value), comboBox2.Text, Convert.ToString(numericUpDown2.Value), comboBox3.Text, radioButton2.Checked, radioButton3.Checked, Convert.ToString(dateTimePicker1.Value));
this.Close();
}
}
private void FormAddPlay_Load(object sender, EventArgs e)
{
panel1.Visible = false;
this.Width = 330;
WorkWithBD.ReadTeamOfDatabaseInComboBox(comboBox1);
WorkWithBD.ReadTeamOfDatabaseInComboBox(comboBox2);
WorkWithBD.ReadTournamentOfDatabaseInComboBox(comboBox3);
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.AddTournament(textBox1.Text, comboBox1.Text);
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.AddStadium(textBox1.Text, textBox2.Text, numericUpDown1.Value.ToString());
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (Check())
{
WorkWithBD.EditJudge(Id, textBox1.Text, textBox2.Text, textBox3.Text, dateTimePicker1.Value.ToString("yyyyMMdd"), numericUpDown1.Value.ToString());
this.Close();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы уверены что хотите удалить данный турнир?", "Сообщение", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
WorkWithBD.DeleteTournament(Convert.ToString(dataGridView1.CurrentRow.Cells[0].Value));
dataGridView1.Rows.Clear();
WorkWithBD.ReadTournamentForDataGridView(dataGridView1);
}
}
private void button4_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы уверены что хотите удалить данный стадион?", "Сообщение", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
WorkWithBD.DeleteStadium(dataGridView1.CurrentRow.Cells[0].Value.ToString());
dataGridView1.Rows.Clear();
WorkWithBD.ReadStadiumForDataGridView(dataGridView1);
}
}
private void button4_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы уверены что хотите удалить данного тренера?", "Сообщение", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
WorkWithBD.DeleteCoach(Convert.ToString(dataGridView1.CurrentRow.Cells[0].Value));
dataGridView1.Rows.Clear();
WorkWithBD.ReadCoachOfDatabaseInDatagridview(dataGridView1);
}
}
private void button2_Click(object sender, EventArgs e)
{
this.Visible = false;
FormAddCoach form = new FormAddCoach();
form.ShowDialog();
dataGridView1.Rows.Clear();
WorkWithBD.ReadCoachOfDatabaseInDatagridview(dataGridView1);
this.Visible = true;
}
private void button2_Click(object sender, EventArgs e)
{
this.Visible = false;
FormAddStadium form = new FormAddStadium();
form.ShowDialog();
dataGridView1.Rows.Clear();
WorkWithBD.ReadStadiumForDataGridView(dataGridView1);
this.Visible = true;
}
private void button3_Click(object sender, EventArgs e)
{
this.Visible = false;
FormEditTeam form = new FormEditTeam(Convert.ToString(dataGridView1.CurrentRow.Cells[0].Value), Convert.ToString(dataGridView1.CurrentRow.Cells[1].Value), Convert.ToString(dataGridView1.CurrentRow.Cells[5].Value));
form.ShowDialog();
dataGridView1.Rows.Clear();
WorkWithBD.ReadTeamOfDataBaseInDataGridView(dataGridView1);
this.Visible = true;
}
private void start()
{
DataSet User = new DataSet();
string sql = "EXEC SelectAllClass";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
ClassCB.Items.Add(User.Tables[0].DefaultView[i].Row[1].ToString());
}
}
private void button3_Click(object sender, EventArgs e)
{
this.Visible = false;
FormEditStadium form = new FormEditStadium(dataGridView1.CurrentRow.Cells[0].Value.ToString(), dataGridView1.CurrentRow.Cells[1].Value.ToString(),
dataGridView1.CurrentRow.Cells[2].Value.ToString(), dataGridView1.CurrentRow.Cells[3].Value.ToString());
form.ShowDialog();
dataGridView1.Rows.Clear();
WorkWithBD.ReadStadiumForDataGridView(dataGridView1);
this.Visible = true;
}
private void AddBN_Click(object sender, RoutedEventArgs e)
{
try
{
string sql = "EXEC InsertRating " +
"@Data='" + Convert.ToDateTime(DayB.Text) + "', @SubjectsID=" + MainWindow.SubjectID + ", " +
"@Missed='" + ((MissedChB.IsChecked == true) ? "н" : "") + "', @Rating=" + RatingCB.Text + ", @FIO='" + (FIOCB.SelectedItem).ToString() + "'";
WorkWithBD.outPutdb(sql);
Close();
}
catch { MessageBox.Show("Введите корректные данные"); }
}
private void addSubjects() // добавление предметов в комбо бокс
{
DataSet User = new DataSet();
string sql = "EXEC SelectAllSubject";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
//SubjectCB.Items.Add("Все");
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
SubjectCB.Items.Add(User.Tables[0].DefaultView[i].Row[0].ToString());
}
}
private void AddBN_Click(object sender, RoutedEventArgs e)
{
try
{
string sql = "EXEC InsertStudent " +
"@GroupNameID=" + (ClassCB.SelectedIndex + 1).ToString() + " ,@MedGroupID=" + (MedGroupCB.SelectedIndex + 1) + ",@FIO='" + FIOTB.Text + "', " +
"@Sex='" + SexCB.SelectedItem.ToString() + "', @DOB='" + Convert.ToDateTime(DayB.Text) + "'," +
"@Tel='" + TelTB.Text + "'";
WorkWithBD.outPutdb(sql);
Close();
}
catch { MessageBox.Show("Введите корректные данные"); }
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.Cells[0].Value.ToString() != "1")
{
WorkWithBD.EditPrivilege(dataGridView1.CurrentRow.Cells[0].Value.ToString());
dataGridView1.Rows.Clear();
WorkWithBD.ReadUserForAdminFormForDataGirdView(dataGridView1);
}
else
{
WorkWithMessage.MessageBoxShow("Главного администратора нельзя изменить!");
}
}
private void button3_Click(object sender, EventArgs e)
{
this.Visible = false;
FormEditPlay form = new FormEditPlay(Convert.ToString(dataGridView1.CurrentRow.Cells[0].Value), Convert.ToString(dataGridView1.CurrentRow.Cells[1].Value),
Convert.ToString(dataGridView1.CurrentRow.Cells[2].Value), Convert.ToString(dataGridView1.CurrentRow.Cells[3].Value),
Convert.ToString(dataGridView1.CurrentRow.Cells[4].Value), Convert.ToString(dataGridView1.CurrentRow.Cells[5].Value),
Convert.ToBoolean(dataGridView1.CurrentRow.Cells[6].Value), Convert.ToBoolean(dataGridView1.CurrentRow.Cells[7].Value),
Convert.ToString(dataGridView1.CurrentRow.Cells[8].Value));
form.ShowDialog();
dataGridView1.Rows.Clear();
WorkWithBD.ReadScheduleForDataGridView(dataGridView1);
this.Visible = true;
}
private bool Check()
{
if (String.IsNullOrWhiteSpace(textBox1.Text))
{
WorkWithMessage.MessageBoxShow("Введите название турнира!");
return(false);
}
if (WorkWithBD.CheckTournament(textBox1.Text))
{
WorkWithMessage.MessageBoxShow("Такой турнир уже существует!");
return(false);
}
return(true);
}
private void DelBN_Click(object sender, RoutedEventArgs e) // delete something
{
try
{
if ((MainListView?.Items?[MainListView.SelectedIndex].ToString() ?? "") != "")
{
string sql = ("EXEC DeleteRating @LogsID=" + UCLogs.index);
WorkWithBD.outPutdb(sql);
ContentGrid.Children.Clear();
ContentGrid.Children.Add(new UCLogs());
}
}
catch { }
}
private void addItems()
{
SexCB.Items.Add("М");
SexCB.Items.Add("Ж");
DataSet User = new DataSet();
string sql = "SELECT SubName FROM Subjects";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
SubjectCB.Items.Add(User.Tables[0].DefaultView[i].Row[0].ToString());
}
}
private void start()
{
SexCB.Items.Add("М");
SexCB.Items.Add("Ж");
DataSet User = new DataSet();
string sql = "EXEC SelectAllSubject";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
SubjectCB.Items.Add(User.Tables[0].DefaultView[i].Row[0].ToString());
}
}
private void addFIO()
{
FIOCB.Items.Clear();
DataSet User = new DataSet();
User = WorkWithBD.outPutdb("SELECT GroupNameID FROM GroupName Where Name = '" + GroupCB.SelectedItem.ToString() + "'");
string id = User.Tables[0].DefaultView[0].Row[0].ToString();
string sql = "SELECT FIO FROM Student WHERE GroupNameID = '" + id + "'";
User = WorkWithBD.outPutdb(sql).Tables[0].DataSet;
for (int i = 0; i < User.Tables[0].DefaultView.Count; i++)
{
FIOCB.Items.Add(User.Tables[0].DefaultView[i].Row[0].ToString());
}
}
private void EnterBut_Click(object sender, EventArgs e)
{
if (Check())
{
if (WorkWithBD.CheckUser(LoginTXTBox.Text, PasswordTXTBox.Text))
{
WorkWithMessage.MessageBoxShow("Данный логин уже занят!");
return;
}
else
{
WorkWithBD.AddUser(LoginTXTBox.Text, PasswordTXTBox.Text);
this.Close();
}
}
}
