private STParticipant GetSelectionData()
{
STParticipant ret = new STParticipant();
int id;
try
{
foreach (DataGridViewRow item in dataGridViewPart.SelectedRows)
{
id = int.Parse(item.Cells[8].Value.ToString());
foreach (STParticipant s in list)
{
if (id == s.idpart)
{
ret = s;
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
private void edit()
{
try
{
STParticipant data = GetSelectionData();
if (data.idpart > 0)
{
DlgParticipant wnd = new DlgParticipant(connect, data);
DialogResult result = wnd.ShowDialog();
if (result == DialogResult.OK)
{
flawour = wnd.GetFl();
init_data();
if (gpos >= 0 && dataGridViewPart.Rows.Count > 0)
{
dataGridViewPart.Rows[gpos].Selected = true;
dataGridViewPart.FirstDisplayedScrollingRowIndex = gpos;
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
public DlgParticipant(SqlConnection cn, ushort md, STParticipant st)
{
InitializeComponent();
connect = cn;
mode = md;
gstParticipant = st;
gid = gstParticipant.idpart;
clParticipant = new CParticipant(connect);
clParam = new CParamApp();
caption = "–едактировать данные участника";
}
private void del()
{
STParticipant data = GetSelectionData();
if (data.idpart > 0)
{
string text = string.Format("Вы действительно желаете удалить тренера: {0} {1} {2}",
data.family, data.name, data.payname);
if (MessageBox.Show(text, "Внимание!", MessageBoxButtons.OKCancel,
MessageBoxIcon.Question) == DialogResult.OK)
{
if (clParticipant.Delete(data))
{
init_data();
}
}
}
}
private bool save()
{
bool ret = false;
STParticipant data = new STParticipant();
data = read_data();
if (gstParticipant.idpart != 0)
{
ret = clParticipant.Update(data, gstParticipant.idpart);
}
else
{
ret = clParticipant.Insert(data);
}
return(ret);
}
private void edit()
{
STParticipant data = GetSelectionData();
if (data.idpart > 0)
{
DlgParticipant wnd = new DlgParticipant(connect, mode, data);
DialogResult result = wnd.ShowDialog();
if (result == DialogResult.OK)
{
init_data();
if (dataGridViewPart.Rows.Count > 0)
{
int x = get_num_row(wnd.RetId());
dataGridViewPart.Rows[x].Selected = true;
dataGridViewPart.FirstDisplayedScrollingRowIndex = x;
}
}
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
rData = read_data();
if (mode == 1)
{
if (clWork.Update(rData, (STParticipant)oldData))
{
DialogResult = DialogResult.OK;
}
}
if (mode == 0)
{
if (clWork.Insert(rData))
{
DialogResult = DialogResult.OK;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private STParticipant read_data()
{
STParticipant ret = new STParticipant();
CCountry clCo;
try
{
ret.idpart = 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 (checkBoxNBL.CheckState == CheckState.Checked)
{
ret.adminflag = 1;
}
else
{
ret.adminflag = 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 (checkBoxVisible.Checked == true)
{
ret.vf = 1;
}
else
{
ret.vf = 0;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
return(ret);
}
private STParticipant read_data()
{
STParticipant ret = new STParticipant();
CCountry clCo;
try
{
if (textBoxId.Text.Length > 0)
{
ret.idpart = int.Parse(textBoxId.Text.Trim());
}
else
{
ret.idpart = 0;
}
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 (checkBoxNBL.CheckState == CheckState.Checked)
{
ret.adminflag = 1;
}
else
{
ret.adminflag = 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 (checkBoxVisible.Checked == true)
{
ret.vf = 1;
}
else
{
ret.vf = 0;
}
List <int> arr = new List <int>();
STPostment st;
for (int i = 0; i < checkedListBoxPost.Items.Count; i++)
{
if (checkedListBoxPost.GetItemChecked(i))
{
st = new STPostment();
string text = checkedListBoxPost.Items[i].ToString();
if (text.Length > 0)
{
st = clPost.GetPost(text);
}
arr.Add(st.idpost);
}
}
if (arr.Count > 0)
{
ret.post = clWork.GetStringPost(arr);
}
else
{
ret.post = null;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
return(ret);
}
private void set_data(STParticipant data)
{
CCountry clCo;
try
{
textBoxId.Text = data.idpart.ToString();
if (data.idpart != 0)
{
textBoxFamily.Text = data.family;
textBoxName.Text = data.name;
if (data.payname != null)
{
textBoxSecondName.Text = data.payname;
}
if (data.datebirth != null)
{
dateTimePickerDateBirth.Value = (DateTime)data.datebirth;
}
if (data.adminflag == 1)
{
checkBoxNBL.CheckState = CheckState.Checked;
}
else
{
checkBoxNBL.CheckState = CheckState.Unchecked;
}
textBoxPersonalNum.Text = data.personalnum;
if (data.idcountry != null)
{
clCo = new CCountry(connect, (int)data.idcountry);
comboBoxCountry.Text = clCo.stCountry.shortname;
}
if (data.namefoto != null && data.namefoto.Length > 0)
{
string pathfoto = string.Format("{0}\\{1}", clParam.s_Path.pathfoto, data.namefoto);
FileInfo fi = new FileInfo(pathfoto);
if (fi.Exists)
{
labelNameFoto.Text = data.namefoto;
Bitmap bt = new Bitmap(pathfoto);
pictureBoxFoto.Image = bt;;
}
else
{
MessageBox.Show(string.Format("‘айл {0} не найден", pathfoto),
"¬нимание!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
if (data.vf == 1)
{
checkBoxVisible.Checked = true;
}
else
{
checkBoxVisible.Checked = false;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
}
