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);
}
