private void loadData()
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
var DataSource = tourtab.Participant
.Join(tourtab.Human,
partic => partic.Id,
hum => hum.Id,
(partic, hum) => new
{
id = partic.Id,
name = hum.Name,
surname = hum.Surname
}
)
.Join(tourtab.Team,
partic => partic.id,
team => team.Id,
(partic, team) => new
{
id = partic.id,
team_id = team.Id,
team_name = team.Team_name,
name = partic.name,
surname = partic.surname
}
).Select(x => x);
teamEditTable.DataSource = DataSource;
teamEditTable.Columns["id"].HeaderText = "ID";
teamEditTable.Columns["team_id"].Visible = false;
//teamEditTable.Columns["team_name"].HeaderText = "Название команды";
teamEditTable.Columns["name"].HeaderText = "Имя";
teamEditTable.Columns["surname"].HeaderText = "Фамилия";
}
private void ParticipantEdit_Load(object sender, EventArgs e)
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
/*Если это редактирование, заполняем поля информацией по организатору*/
if (isEdit)
{
try {
var part = tourtab.Participant
.Join(tourtab.Human,
p => p.Human_id,
h => h.Id,
(p, h) => new
{
id = p.Id,
name = h.Name,
surname = h.Surname,
birthday = h.Birthday,
address = h.Address,
weight = p.Weight,
about = p.About,
team_id = p.Team_id
})
.Where(x => x.id == partID)
.Select(x => x).First();
nameInputBox.Text = part.name;
surnameInputBox.Text = part.surname;
addressInputBox.Text = part.address;
weightInputBox.Text = part.weight.ToString();
aboutInputBox.Text = part.about;
birthdayInputBox.Value = DateTime.Parse(part.birthday.ToString());
}
catch(Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show("Произошел сбой",
"Ошибка",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
return;
}
}
}
/*Действие при загрузке формы*/
private void AuthForm_Load(object sender, EventArgs e)
{
try
{
TourtabDatabase = new TourtabDatabase(Classes.StaticMembers.connectionString);
if(TourtabDatabase != null)
{
logger.Info("Соединение установлено");
}
else
{
logger.Info("Соединение не установлено");
}
}
catch(Exception exc)
{
MessageBox.Show("Произошла ошибка\n" + exc.Message);
logger.Error("Error message: " + exc.Message);
}
}
private void OrganizatorEdit_Load(object sender, EventArgs e)
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
/*Если это редактирование, заполняем поля информацией по организатору*/
if (isEdit)
{
var org = tourtab.Organizators
.Join(tourtab.Human,
o => o.Human_id,
h => h.Id,
(o, h) => new
{
id = o.Id,
name = h.Name,
surname = h.Surname,
birthday = h.Birthday,
address = h.Address,
login = o.Login,
password = o.Password,
is_admin = o.Is_admin,
org_type = o.Org_type
})
.Where(x => x.id == orgID)
.Select(x => x).First();
nameInputBox.Text = org.name;
surnameInputBox.Text = org.surname;
addressInputBox.Text = org.address;
loginInputBox.Text = org.login;
passwordInputBox.Text = org.password;
orgTypeInputBox.Text = org.org_type;
birthdayInputBox.Value = DateTime.Parse(org.birthday.ToString());
isAdminBox.Checked = (bool)org.is_admin;
}
}
/*Загрузка данных*/
private void loadData()
{
try
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
/*Запрос на три таблицы*/
var sourceData = tourtab.Tournament
.Join(tourtab.Location,
tour => tour.Location_id,
loc => loc.Id,
(tour, loc) => new
{
id = tour.Id,
name = tour.Name,
match_count = tour.Match,
place = loc.Place,
date = loc.Date,
sport_id = tour.Sport_id
})
.Join(tourtab.Sport,
tour => tour.sport_id,
sprt => sprt.Id,
(tour, sprt) => new
{
id = tour.id,
name = tour.name,
match_count = tour.match_count,
place = tour.place,
date = tour.date.Value.Date,
sport = sprt.Name
})
.Select(x => x);
tournamentTable.DataSource = sourceData;
tournamentTable.Columns["id"].HeaderText = "ID";
tournamentTable.Columns["name"].HeaderText = "Название турнира";
tournamentTable.Columns["match_count"].HeaderText = "Число матчей";
tournamentTable.Columns["place"].HeaderText = "Место проведения";
tournamentTable.Columns["date"].HeaderText = "Дата проведения";
tournamentTable.Columns["sport"].HeaderText = "Вид спорта";
}
catch (Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show("Произошла ошибка при загрузке данных",
"Ошибка",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
return;
}
}
private void TeamEdit_Load(object sender, EventArgs e)
{
loadData();
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
if (isEdit)
{
var team = tourtab.Team.Where(x => x.Id == teamID).Select(x => x).First();
teamNameInputBox.Text = team.Team_name;
countInputBox.Text = team.Participant_count.ToString();
}
}
private void loadData()
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
var sports = tourtab.Sport.Select(x => x);
sportTable.DataSource = sports;
sportTable.Columns["id"].HeaderText = "ID";
sportTable.Columns["name"].HeaderText = "Наименование";
sportTable.Columns["description"].HeaderText = "Описание";
sportTable.Columns["teams"].Visible = false;
sportTable.Columns["description"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
/*Функция загрузки таблицы*/
private void loadData()
{
/*Оптимизация*/
if(tourtab != null)
{
tourtab.Dispose();
tourtab = null;
}
try
{
/*Получаем базу данных*/
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
/*Делаем запрос из двух таблиц и создаем новую*/
var sourceData = tourtab.Organizators
.Join(tourtab.Human,
org => org.Human_id,
hum => hum.Id,
(org, hum) => new
{
id = org.Id,
name = hum.Name,
surname = hum.Surname,
address = hum.Address,
birthday = hum.Birthday,
login = org.Login,
password = org.Password,
is_admin = org.Is_admin,
org_type = org.Org_type,
human_id = org.Human_id
})
.Select(x => x);
/*Теперь таблица заполняется из этой базы данных*/
organzitorTable.DataSource = sourceData;
organzitorTable.Columns["human_id"].Visible = false;
/*Проверяем права доступа*/
if (!permission)
{
/*Простой организатор не видит логины и пароли других пользователей*/
organzitorTable.Columns["login"].Visible = false;
organzitorTable.Columns["password"].Visible = false;
}
/*Изменяем названия заголовков таблиц*/
organzitorTable.Columns["id"].HeaderText = "ID";
organzitorTable.Columns["name"].HeaderText = "Имя";
organzitorTable.Columns["surname"].HeaderText = "Фамилия";
organzitorTable.Columns["address"].HeaderText = "Адрес";
organzitorTable.Columns["birthday"].HeaderText = "Дата рождения";
organzitorTable.Columns["login"].HeaderText = "Логин";
organzitorTable.Columns["password"].HeaderText = "Пароль";
organzitorTable.Columns["is_admin"].HeaderText = "Права администратора";
organzitorTable.Columns["org_type"].HeaderText = "Тип обязанностей";
}
catch (Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show(
"Произошла ошибка при загрузке данных!",
"Ошибка",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
return;
}
}
/*Действие при загрузке формы*/
private void TournamentEdit_Load(object sender, EventArgs e)
{
try
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
tournamentSportTypeComboBox.DataSource = tourtab.Sport.Select(x => x.Name);
if (isEdit)
{
/*Запрос на три таблицы*/
var tournament = tourtab.Tournament
.Join(tourtab.Location,
tour => tour.Location_id,
loc => loc.Id,
(tour, loc) => new
{
id = tour.Id,
name = tour.Name,
place = loc.Place,
date = loc.Date,
sport_id = tour.Sport_id
})
.Join(tourtab.Sport,
tour => tour.sport_id,
sprt => sprt.Id,
(tour, sprt) => new
{
id = tour.id,
name = tour.name,
place = tour.place,
date = tour.date,
sport = sprt.Name
})
.Where(x => x.id == tournamentID)
.Select(x => x)
.First();
tournamentNameInputBox.Text = tournament.name;
tournamentPlaceInputBox.Text = tournament.place;
tournamentDatePicker.Value = tournament.date.Value;
}
}
catch(Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show("Произошла ошибка при загрузке данных",
"Ошибка",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
this.Dispose();
}
}
//Функция заргузки таблицы
private void loadData()
{
try
{
//Получение базы данных
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
//Запрос из двух таблиц и создание новой
var sourceData = tourtab.Participant
.Join(tourtab.Human,
part => part.Human_id,
hum => hum.Id,
(part, hum) => new
{
id = part.Id,
name = hum.Name,
surname = hum.Surname,
birthday = hum.Birthday,
address = hum.Address,
weight = part.Weight,
about = part.About,
human_id = part.Human_id,
team_id = part.Team_id,
club_id = part.Club_id
})
.Select(x => x);
//Заполнение таблицы из базы данных
participantTable.DataSource = sourceData;
participantTable.Columns["human_id"].Visible = false;
participantTable.Columns["team_id"].Visible = false;
participantTable.Columns["club_id"].Visible = false;
//Изменение название заголовков таблицы
participantTable.Columns["id"].HeaderText = "ID";
participantTable.Columns["name"].HeaderText = "Имя";
participantTable.Columns["surname"].HeaderText = "Фамилия";
participantTable.Columns["address"].HeaderText = "Адрес";
participantTable.Columns["birthday"].HeaderText = "Дата рождения";
participantTable.Columns["weight"].HeaderText = "Вес";
participantTable.Columns["about"].HeaderText = "Биография";
}
catch (Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show(
"Произошла ошибка при загрузке данных!",
"Ошибка",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
return;
}
}
/*Действие при первоначальной загрузке окна*/
private void MatchList_Load(object sender, EventArgs e)
{
try
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
currentRound.Text = "1";
generateMatchTable(1);
}
catch(Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show("Произошла ошибка при загрузке данных",
"Ошибка",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
this.Dispose();
}
}
/*Действие при загрзке формы*/
private void SportEdit_Load(object sender, EventArgs e)
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
if(isEdit)
{
var sport = tourtab.Sport.Where(x => x.Id == sportID).Select(x => x).First();
sportNameInputBox.Text = sport.Name;
sportDescriptionInputBox.Text = sport.Description;
teamVteamCheckBox.Enabled = false;
}
}
private void loadData()
{
try
{
tourtab = new TourtabDatabase(Classes.StaticMembers.connectionString);
var team = tourtab.Team.Select(x => x);
teamTable.DataSource = team;
teamTable.Columns["id"].HeaderText = "ID";
teamTable.Columns["Team_name"].HeaderText = "Название команды";
teamTable.Columns["Participant_count"].Visible = false;
teamTable.Columns["Club_id"].Visible = false;
teamTable.Columns["Club"].Visible = false;
/* var DataSource = tourtab.Team
.Join(tourtab.Participant,
partic => partic.Id,
team => team.Id,
(partic, team) => new
{
id = partic.Id,
team_id = team.Id,
//team_name = team.T,
// name = partic.name,
// surname = partic.surname
}
).Select(x => x);*/
// teamTable.DataSource = DataSource;
// teamTable.Columns["id"].HeaderText = "ID";
// teamTable.Columns["team_id"].Visible = false;
teamTable.Columns["team_name"].HeaderText = "Название команды";
// teamTable.Columns["name"].HeaderText = "Имя";
// teamTable.Columns["surname"].HeaderText = "Фамилия";
}
catch (Exception exc)
{
logger.Error(exc.Message);
MessageBox.Show("Произошел сбой",
"Сообщение",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
return;
}
}
