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