public void GetTable()
{
this.dataGridView1.Rows.Clear();
w_client.OperationChangesRef.Person p = new w_client.OperationChangesRef.Person();
p.tableName = "data_base.persons";
List <object> list = GetL(p);
foreach (object person_ in list)
{
Person obj = (Person)person_;
if (obj.WasDel != 1)
{
this.dataGridView1.Rows.Add(obj.ID_person, obj.surname, obj.name, obj.middle_name, "Привилегии");
}
}
this.dataGridView2.Rows.Clear();
w_client.OperationChangesRef.Group_ g = new w_client.OperationChangesRef.Group_();
g.tableName = "data_base.groups";
List <object> gr = GetL(g);
foreach (object g_ in gr)
{
Group_ v = (Group_)g_;
this.dataGridView2.Rows.Add(v.ID_group, v.name, "Привилегии");
}
}
private void button3_Click(object sender, EventArgs e)
{
w_client.OperationChangesRef.changes ch = new w_client.OperationChangesRef.changes();
ch.ID_person = Convert.ToInt32(this.textBox1.Text);
for (int i = 0; i <= dataGridView2.RowCount - 1; i++)
{
try
{
if (dataGridView2.Rows[i].Cells[2].Value.ToString() == "True")
{
if (ch.IDs_privch != null)
{
ch.IDs_privch = ch.IDs_privch + ", " + dataGridView2.Rows[i].Cells[0].Value;
}
else
{
ch.IDs_privch = dataGridView2.Rows[i].Cells[0].Value.ToString();
}
}
}
catch { }
}
Form2 a = new Form2();
w_client.OperationChangesRef.Group_ g = new w_client.OperationChangesRef.Group_();
g.name = comboBox1.SelectedItem.ToString();
g.tableName = "data_base.groups";
List <object> s = a.GetL(g);
g = (w_client.OperationChangesRef.Group_)s[0];
ch.ID_group = g.ID_group;
ch.surname = textBox2.Text;
ch.name = textBox3.Text;
ch.middle_name = textBox4.Text;
OperationChangesClient operationclient = new OperationChangesClient("BasicHttpBinding_IOperationChanges");
int flag = operationclient.update_per_priv(ch);
int flag_ = operationclient.update_pers(ch);
if ((flag == 1) && (flag_ == 1))
{
MessageBox.Show("Операция прошла успешно.");
}
else
{
MessageBox.Show("Ошибка! Попробуйте еще раз.");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Form2 ad = new Form2();
Dictionary <string, int> namegr_id = new Dictionary <string, int>();
w_client.OperationChangesRef.Group_ gr = new w_client.OperationChangesRef.Group_();
gr.tableName = "data_base.groups";
List <object> g = ad.GetL(gr);
foreach (object g_ in g)
{
w_client.OperationChangesRef.Group_ group = (w_client.OperationChangesRef.Group_)g_;
try
{
namegr_id.Add(group.name, group.ID_group);
}
catch { }
}
w_client.OperationChangesRef.Group_Privileges gp = new w_client.OperationChangesRef.Group_Privileges();
gp.Groups_ID_group = namegr_id[comboBox1.SelectedItem.ToString()];
gp.tableName = "data_base.groups_privileges";
List <object> grp = ad.GetL(gp);
List <w_client.OperationChangesRef.Group_Privileges> r = new List <w_client.OperationChangesRef.Group_Privileges>();
foreach (object g_ in grp)
{
r.Add((Group_Privileges)g_);
}
Dictionary <int, string> id_privname = new Dictionary <int, string>();
w_client.OperationChangesRef.Privilege pg = new w_client.OperationChangesRef.Privilege(); // все существующие привилегии
pg.tableName = "data_base.privileges";
List <object> up = ad.GetL(pg);
List <w_client.OperationChangesRef.Privilege> pl = new List <w_client.OperationChangesRef.Privilege>();
foreach (object u in up)
{
w_client.OperationChangesRef.Privilege u_ = (w_client.OperationChangesRef.Privilege)u;
id_privname.Add(u_.ID_privilege, u_.name_func);
pl.Add(u_);
}
dataGridView1.Rows.Clear();
foreach (w_client.OperationChangesRef.Group_Privileges gp0 in r)
{
dataGridView1.Rows.Add(gp0.Privileges_ID_privilege.ToString(), id_privname[gp0.Privileges_ID_privilege]);
}
}
private void button1_Click(object sender, EventArgs e)
{
Regex regex = new Regex("^[А-Яа-я]+$");
if (regex.IsMatch(textBox2.Text) && regex.IsMatch(textBox3.Text) && regex.IsMatch(textBox4.Text))
{
Form2 ad = new Form2();
w_client.OperationChangesRef.changes ch = new w_client.OperationChangesRef.changes();
ch.surname = textBox2.Text;
ch.name = textBox3.Text;
ch.middle_name = textBox4.Text;
Dictionary <string, int> namegr_id = new Dictionary <string, int>();
w_client.OperationChangesRef.Group_ gr = new w_client.OperationChangesRef.Group_();
gr.tableName = "data_base.groups";
List <object> g = ad.GetL(gr);
foreach (object g_ in g)
{
w_client.OperationChangesRef.Group_ group = (w_client.OperationChangesRef.Group_)g_;
try
{ namegr_id.Add(group.name, group.ID_group); }
catch { }
}
ch.ID_group = namegr_id[comboBox1.SelectedItem.ToString()];
OperationChangesClient operationclient = new OperationChangesClient("BasicHttpBinding_IOperationChanges");
int flag = operationclient.add_pers(ch);
if (flag == 1)
{
MessageBox.Show("Операция прошла успешно.");
}
else
{
MessageBox.Show("Ошибка! Попробуйте еще раз.");
}
}
else
{
MessageBox.Show("Ошибка! Некорректный ввод.");
}
}