private STReferee GetSelectionData()
{
STReferee ret = new STReferee();
int id;
try
{
if (g_f)
{
foreach (DataGridViewRow item in dataGridViewReferee.SelectedRows)
{
id = int.Parse(item.Cells[7].Value.ToString());
foreach (STReferee s in list)
{
if (id == s.idref)
{
ret = s;
}
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
return(ret);
}
public DlgReferee(SqlConnection cn, ushort md, STReferee st)
{
InitializeComponent();
connect = cn;
mode = md;
gstReferee = st;
gid = gstReferee.idref;
clReferee = new CReferee(connect);
clParam = new CParamApp();
caption = "–едактировать данные судьи";
}
private void del()
{
STReferee data = GetSelectionData();
if (data.idref > 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 (clReferee.Delete(data))
{
init_data();
}
}
}
}
private bool save()
{
bool ret = false;
STReferee data = new STReferee();
data = read_data();
if (gstReferee.idref != 0)
{
ret = clReferee.Update(data, gstReferee.idref);
}
else
{
ret = clReferee.Insert(data);
}
return(ret);
}
private void edit()
{
STReferee data = GetSelectionData();
if (data.idref > 0)
{
DlgReferee wnd = new DlgReferee(connect, mode, data);
DialogResult result = wnd.ShowDialog();
if (result == DialogResult.OK)
{
init_data();
if (dataGridViewReferee.Rows.Count > 0)
{
int x = get_num_row(wnd.RetId());
dataGridViewReferee.Rows[x].Selected = true;
dataGridViewReferee.FirstDisplayedScrollingRowIndex = x;
}
}
}
}
private STReferee read_data()
{
STReferee ret = new STReferee();
CCountry clCo;
try
{
ret.idref = 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;
}
if (comboBoxCategory.Text.Length > 0)
{
ret.category = comboBoxCategory.Text;
}
else
{
ret.category = 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 (checkBoxVisible.Checked == true)
{
ret.vf = 1;
}
else
{
ret.vf = 0;
}
if (!string.IsNullOrEmpty(textBoxTax.Text.Trim()))
{
double dbl = 0;
string s = string.Format("{0:f2}", textBoxTax.Text.Trim());
double.TryParse(s, out dbl);
ret.tax = dbl;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
return(ret);
}
