private void del() { try { STEntryPlayers?data = GetSelectionData(); if (data != null) { if (MessageBox.Show("Вы действиетльно желаете удалить данную запись?", "Внимание!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { clWork.Delete((STEntryPlayers)data); init_data(); STEntryPlayers del = (STEntryPlayers)data; // делаем запись в историю stHEP = new STHistoryEntryPlayers(); stHEP.opertype = 2; stHEP.ed = DateTime.Now; stHEP.idseason = del.idseason; stHEP.idteam = del.idteam; stHEP.idplayer = del.idplayer; stHEP.text = string.Format("Дата: {0}, Номер: {1}, Рост: {2}, Вес: {3}", del.datein.ToString(), del.number, del.growing, del.weight); clHEP.Insert(stHEP); } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private STEntryPlayers GetSelectionData() { STEntryPlayers ret = new STEntryPlayers(); string shortname = null; string comp = null; CPlayer clPlayer; try { foreach (DataGridViewRow item in dataGridViewCompositionTeam.SelectedRows) { shortname = item.Cells[1].Value.ToString(); foreach (STEntryPlayers data in team_composition) { clPlayer = new CPlayer(connect, data.idplayer); comp = string.Format("{0} {1} {2}", clPlayer.stPlayer.family, clPlayer.stPlayer.name, clPlayer.stPlayer.payname); if (shortname == comp) { ret = data; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } return(ret); }
private void add() { try { DlgEntryPlayer wnd = new DlgEntryPlayer(connect, IS, null, recom); if (wnd.ShowDialog() == DialogResult.OK) { flawour = wnd.GetFl(); init_data(); if (gpos >= 0 && dataGridViewEntryPlayers.Rows.Count > 0) { dataGridViewEntryPlayers.Rows[gpos].Selected = true; dataGridViewEntryPlayers.FirstDisplayedScrollingRowIndex = gpos; } recom = flawour.idteam; // делаем запись в историю stHEP = new STHistoryEntryPlayers(); stHEP.opertype = 1; stHEP.ed = DateTime.Now; stHEP.idseason = flawour.idseason; stHEP.idteam = flawour.idteam; stHEP.idplayer = flawour.idplayer; stHEP.text = string.Format("Дата: {0}, Номер: {1}, Рост: {2}, Вес: {3}", flawour.datein.ToString(), flawour.number, flawour.growing, flawour.weight); clHEP.Insert(stHEP); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void edit() { try { STEntryPlayers?data = GetSelectionData(); if (data != null) { DlgEntryPlayer wnd = new DlgEntryPlayer(connect, IS, data, recom); if (wnd.ShowDialog() == DialogResult.OK) { flawour = wnd.GetFl(); init_data(); if (gpos >= 0 && dataGridViewEntryPlayers.Rows.Count > 0) { dataGridViewEntryPlayers.Rows[gpos].Selected = true; dataGridViewEntryPlayers.FirstDisplayedScrollingRowIndex = gpos; } recom = flawour.idteam; } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void buttonAdd_Click(object sender, EventArgs e) { STEntryPlayers tc = new STEntryPlayers(); try { if (comboBoxPlayers.Text.Length > 0) { string text = comboBoxPlayers.Text.Trim(); char[] del = { '#', ' ' }; string[] words = text.Split(del); string number = words[1]; string famili = words[2]; string name = words[3]; foreach (STEntryPlayers item in currteam) { CPlayer clp = new CPlayer(connect, item.idplayer); if (number.Equals(item.number) && famili.Equals(clp.stPlayer.family) && name.Equals(clp.stPlayer.name)) { tc = item; } } DlgStats wnd = new DlgStats(connect, mode, tc.idseason, gSTGame.idgame, tc.idteam, tc.idplayer, tc.number, lst_records); if (wnd.ShowDialog() == DialogResult.OK) { flawour = wnd.GetFl(); init_data(); if (gpos >= 0 && dataGridViewStats.Rows.Count > 0) { dataGridViewStats.Rows[gpos].Selected = true; // dataGridViewStats.FirstDisplayedScrollingRowIndex = gpos; } if (wnd.GetRec()) { init_records(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void ToolStripMenuItemHistory_Click(object sender, EventArgs e) { try { STEntryPlayers?data = GetSelectionData(); STEntryPlayers ret = (STEntryPlayers)data; CPlayer clP = new CPlayer(connect, ret.idplayer); HistoryPlayer wnd = new HistoryPlayer(connect, mode, clP.stPlayer); DialogResult result = wnd.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void set_data(STEntryPlayers data) { string text = null; try { CPlayer part = new CPlayer(connect, data.idplayer); text = string.Format("{0} {1} ({2})", part.stPlayer.family, part.stPlayer.name, part.stPlayer.personalnum); comboBoxName.Text = text; clTeam = new CTeam(connect, data.idteam); comboBoxTeam.Text = clTeam.stTeam.name; dateTimePickerDate.Value = data.datein; dateTimePickerTimeIn.Value = data.datein; textBoxNumber.Text = data.number.ToString(); if (data.growing != null) { textBoxGrowing.Text = data.growing.ToString(); } if (data.weight != null) { textBoxWeight.Text = data.weight.ToString(); } if (data.dateout != null) { checkBoxOut.CheckState = CheckState.Checked; dateTimePickerDateOut.Value = (DateTime)data.dateout; dateTimePickerTimeOut.Value = (DateTime)data.dateout; } else { checkBoxOut.CheckState = CheckState.Unchecked; dateTimePickerDateOut.Enabled = false; dateTimePickerTimeOut.Enabled = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void buttonSave_Click(object sender, EventArgs e) { try { rData = read_data(); if (rData.idplayer > 0 && rData.idteam > 0) { if (mode == 1) { if (clWork.Update(rData, (STEntryPlayers)oldData)) { DialogResult = DialogResult.OK; } } if (mode == 0) { if (bDraft) { if (MessageBox.Show("Удалить игрока с драфта?", "Внимание!", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { DateTime dtout = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0, 0); clDraft.OutDraft(rData.idplayer, stDraft.dtin, dtout, rData.idteam); } } if (clWork.Insert(rData)) { DialogResult = DialogResult.OK; } } } else { MessageBox.Show("Не все обязательные поля заполнены", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void buttonSave_Click(object sender, EventArgs e) { try { rData = read_data(); if (mode == 1) { if (clWork.Update(rData, (STEntryPlayers)oldData)) { DialogResult = DialogResult.OK; } } if (mode == 0) { if (clWork.Insert(rData)) { DialogResult = DialogResult.OK; } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private STEntryPlayers read_data() { STEntryPlayers ret = new STEntryPlayers(); try { ret.idseason = IS.idseason; if (comboBoxName.Text.Length > 0) { ret.idplayer = clPlayer.stPlayer.idplayer; } else { ret.idplayer = 0; } if (comboBoxTeam.Text.Length > 0) { clTeam = new CTeam(connect, comboBoxTeam.Text.Trim()); ret.idteam = clTeam.stTeam.id; } ret.datein = new DateTime(dateTimePickerDate.Value.Year, dateTimePickerDate.Value.Month, dateTimePickerDate.Value.Day, dateTimePickerTimeIn.Value.Hour, dateTimePickerTimeIn.Value.Minute, 0, 0); if (textBoxNumber.Text.Length > 0) { ret.number = textBoxNumber.Text.Trim(); } else { ret.number = null; } if (textBoxGrowing.Text.Length > 0) { ret.growing = int.Parse(textBoxGrowing.Text.Trim()); } else { ret.growing = 0; } if (textBoxWeight.Text.Length > 0) { ret.weight = int.Parse(textBoxWeight.Text.Trim()); } else { ret.weight = 0; } if (checkBoxOut.CheckState == CheckState.Checked) { ret.dateout = new DateTime(dateTimePickerDateOut.Value.Year, dateTimePickerDateOut.Value.Month, dateTimePickerDateOut.Value.Day, dateTimePickerTimeOut.Value.Hour, dateTimePickerTimeOut.Value.Minute, 0, 0); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } return(ret); }
private void edit() { try { STEntryPlayers?data = GetSelectionData(); if (data != null) { DlgEntryPlayer wnd = new DlgEntryPlayer(connect, IS, data, recom); if (wnd.ShowDialog() == DialogResult.OK) { flawour = wnd.GetFl(); init_data(); if (gpos >= 0 && dataGridViewEntryPlayers.Rows.Count > 0) { dataGridViewEntryPlayers.Rows[gpos].Selected = true; dataGridViewEntryPlayers.FirstDisplayedScrollingRowIndex = gpos; } recom = flawour.idteam; STEntryPlayers old = (STEntryPlayers)data; // делаем запись в историю stHEP = new STHistoryEntryPlayers(); stHEP.ed = DateTime.Now; stHEP.idseason = flawour.idseason; stHEP.idteam = flawour.idteam; stHEP.idplayer = flawour.idplayer; if (flawour.dateout != null) { DateTime dt = (DateTime)flawour.dateout; stHEP.opertype = 3; stHEP.text = string.Format("Отзаявка {0}", dt.ToString()); clHEP.Insert(stHEP); } if (old.idteam != flawour.idteam) { string team1; string team2; CTeam clTeam = new CTeam(connect, old.idteam); team1 = clTeam.stTeam.name; clTeam = new CTeam(connect, flawour.idteam); team2 = clTeam.stTeam.name; stHEP.opertype = 4; stHEP.text = string.Format("Смена команды с {0} на {1}", team1, team2); clHEP.Insert(stHEP); } if (old.number != flawour.number) { stHEP.opertype = 5; stHEP.text = string.Format("Смена номера с {0} на {1}", old.number, flawour.number); clHEP.Insert(stHEP); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }