private void edit()
{
try
{
STPostment data = GetSelectionData();
DlgPostmetn wnd = new DlgPostmetn(connect, data);
DialogResult result = wnd.ShowDialog();
if (result == DialogResult.OK)
{
flawour = wnd.GetFl();
init_data();
if (gpos >= 0 && dataGridViewPostment.Rows.Count > 0)
{
dataGridViewPostment.Rows[gpos].Selected = true;
dataGridViewPostment.FirstDisplayedScrollingRowIndex = gpos;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void del()
{
try
{
STPostment data = GetSelectionData();
if (MessageBox.Show("Вы действиетльно желаете удалить запись?", "Внимание!",
MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
clWork.Delete(data);
init_data();
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private STPostment GetSelectionData()
{
STPostment ret = new STPostment();
int n;
try
{
foreach (DataGridViewRow item in dataGridViewPostment.SelectedRows)
{
n = int.Parse(item.Cells[0].Value.ToString());
ret = clWork.GetPost(n);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
private void set_data(STPostment data)
{
try
{
textBoxId.Text = data.idpost.ToString();
if (data.namepost != null)
{
textBoxName.Text = data.namepost;
}
if (data.descript != null)
{
textBoxDescript.Text = data.descript;
}
textBoxId.Focus();
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private STPostment read_data()
{
STPostment ret = new STPostment();
try
{
if (textBoxId.Text.Length > 0)
{
ret.idpost = int.Parse(textBoxId.Text.Trim());
}
else
{
ret.idpost = 0;
}
if (textBoxName.Text.Length > 0)
{
ret.namepost = textBoxName.Text.Trim();
}
else
{
ret.namepost = null;
}
if (textBoxDescript.Text.Length > 0)
{
ret.descript = textBoxDescript.Text.Trim();
}
else
{
ret.descript = null;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
rData = read_data();
if (mode == 1)
{
if (clWork.Update(rData, (STPostment)oldData))
{
DialogResult = DialogResult.OK;
}
}
if (mode == 0)
{
if (clWork.Insert(rData))
{
DialogResult = DialogResult.OK;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void init_data()
{
string text;
DateTime dt;
List <int> arr;
bool fl;
CCountry clCo = new CCountry(connect);
clPost = new CPostment(connect);
g_f = false;
try
{
dataGridViewPart.Rows.Clear();
list = new List <STParticipant>();
list = clParticipant.GetList();
if (list.Count > 0)
{
g_f = true;
dataGridViewPart.Rows.Add(list.Count);
for (int i = 0; i < list.Count; i++)
{
dataGridViewPart.Rows[i].Cells[0].Value = (i + 1).ToString();
text = list[i].family + " " + list[i].name + " " + list[i].payname;
dataGridViewPart.Rows[i].Cells[1].Value = text;
if (list[i].datebirth != null)
{
dt = (DateTime)list[i].datebirth;
dataGridViewPart.Rows[i].Cells[2].Value = dt.ToShortDateString();
}
dataGridViewPart.Rows[i].Cells[3].Value = list[i].personalnum;
if (list[i].idcountry != null)
{
clCo = new CCountry(connect, (int)list[i].idcountry);
dataGridViewPart.Rows[i].Cells[4].Value = clCo.stCountry.shortname;
}
dataGridViewPart.Rows[i].Cells[5].Value = list[i].namefoto;
if (list[i].post != null)
{
arr = clParticipant.GetArrayPost(list[i].post);
if (arr.Count > 0)
{
text = null;
string hd = null;
fl = false;
foreach (int n in arr)
{
STPostment st = clPost.GetPost(n);
if (fl == false)
{
text = st.namepost;
fl = true;
}
else
{
text += ", " + st.namepost;
}
}
}
dataGridViewPart.Rows[i].Cells[6].Value = text;
}
if (list[i].adminflag == 1)
{
dataGridViewPart.Rows[i].Cells[7].Value = " * ";
}
dataGridViewPart.Rows[i].Cells[8].Value = list[i].idpart.ToString();
if (list[i].vf != null)
{
if (list[i].vf == 1)
{
dataGridViewPart.Rows[i].Cells[9].Value = "*";
}
}
if (flawour.Equals(list[i]))
{
gpos = i;
}
}
dataGridViewPart.AllowUserToAddRows = false;
}
else
{
dataGridViewPart.AllowUserToAddRows = false;
}
toolStripStatusLabel1.Text = string.Format("Число персонала: {0}", list.Count);
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
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);
}