private STPlayer GetSelectionData() { STPlayer ret = new STPlayer(); int id; try { if (g_f) { foreach (DataGridViewRow item in dataGridViewPlayers.SelectedRows) { id = int.Parse(item.Cells[6].Value.ToString()); foreach (STPlayer s in list) { if (id == s.idplayer) { ret = s; } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(ret); }
private void edit() { try { STPlayer data = GetSelectionData(); DlgPlayers wnd = new DlgPlayers(connect, mode, data); DialogResult result = wnd.ShowDialog(); if (result == DialogResult.OK) { init_data(); if (dataGridViewPlayers.Rows.Count > 0) { int x = get_num_row(wnd.RetId()); dataGridViewPlayers.Rows[x].Selected = true; dataGridViewPlayers.FirstDisplayedScrollingRowIndex = x; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public HistoryPlayer(SqlConnection cn, ushort md, STPlayer st) { InitializeComponent(); connect = cn; mode = md; gstPlayer = st; }
private void ToolStripMenuItemHistory_Click(object sender, EventArgs e) { try { STPlayer data = GetSelectionData(); HistoryPlayer wnd = new HistoryPlayer(connect, mode, data); DialogResult result = wnd.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DlgPlayers(SqlConnection cn, ushort md, STPlayer st) { InitializeComponent(); connect = cn; mode = md; gstPlayer = st; gid = gstPlayer.idplayer; clPlayer = new CPlayer(connect); clParam = new CParamApp(); caption = "Редактировать данные игрока"; }
private bool save() { bool ret = false; STPlayer data = new STPlayer(); data = read_data(); if (gstPlayer.idplayer != 0) { ret = clPlayer.Update(data, gstPlayer.idplayer); } else { ret = clPlayer.Insert(data); } return(ret); }
private void del() { try { STPlayer data = GetSelectionData(); string text = string.Format("Вы действительно желаете удалить игрока: {0} {1} {2}", data.family, data.name, data.payname); if (MessageBox.Show(text, "Внимание!", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { if (clPlayer.Delete(data)) { init_data(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private bool save() { bool fl = true; bool ret = false; STPlayer data = new STPlayer(); data = read_data(); string text; string str; DateTime dt; List <STPlayer> lst_p = clPlayer.IsFamily(data.family); if (lst_p.Count > 0) { text = "Игроки с такой фамилией уже есть в базе данных:\r\n"; foreach (STPlayer player in lst_p) { if (player.datebirth != null) { dt = (DateTime)player.datebirth; str = string.Format("{0} {1} {2}, {3}\r\n", player.family, player.name, player.payname, dt.ToShortDateString()); } else { str = string.Format("{0} {1} {2}\r\n", player.family, player.name, player.payname); } text += str; } text += "Продолжить?"; if (MessageBox.Show(text, "Внимание!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.Cancel) { fl = false; } } if (fl) { if (gstPlayer.idplayer != 0) { ret = clPlayer.Update(data, gstPlayer.idplayer); } else { ret = clPlayer.Insert(data); } } return(ret); }
private STPlayer read_data() { STPlayer ret = new STPlayer(); CCountry clCo; try { ret.idplayer = gid; if (textBoxFamily.Text.Length > 0) { ret.family = textBoxFamily.Text; } else { ret.family = null; } if (textBoxName.Text.Length > 0) { ret.name = textBoxName.Text; } else { ret.name = null; } if (textBoxSecondName.Text.Length > 0) { ret.payname = textBoxSecondName.Text; } else { ret.payname = null; } ret.datebirth = new DateTime(dateTimePickerDateBirth.Value.Year, dateTimePickerDateBirth.Value.Month, dateTimePickerDateBirth.Value.Day, 0, 0, 0, 0); if (textBoxPersonalNum.Text.Length > 0) { ret.personalnum = textBoxPersonalNum.Text; } else { ret.personalnum = null; } if (comboBoxCountry.Text.Length > 0) { string c = comboBoxCountry.Text; clCo = new CCountry(connect, c); ret.idcountry = clCo.stCountry.id; } else { ret.idcountry = 0; } if (labelNameFoto.Text.Length > 0) { ret.namefoto = labelNameFoto.Text.Trim(); } else { ret.namefoto = null; } if (textBoxDescript.Text.Length > 0) { ret.descript = textBoxDescript.Text; } else { ret.descript = null; } if (textBoxFotoWeb.Text.Length > 0) { ret.fotoweb = textBoxFotoWeb.Text.Trim(); } else { ret.fotoweb = null; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } return(ret); }