public void Fill()
{
SqlConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
SqlDataReader dataReader;
string sql = "SELECT * FROM users_group";
SqlCommand command = new SqlCommand(sql, connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
UsersGroupDB obj = new UsersGroupDB();
obj.id = Convert.ToInt32(dataReader.GetValue(0));
obj.name = Convert.ToString(dataReader.GetValue(1));
obj.description = Convert.ToString(dataReader.GetValue(2));
obj.comment = Convert.ToString(dataReader.GetValue(3));
list_objects.Add(obj);
obj = null;
}
connection.Close();
}
catch (Exception ex)
{
}
}
private void btnConfirm_Click_1(object sender, EventArgs e)
{
string group_name = "";
group_name = tbName.Text;
UsersGroupDB ug = new UsersGroupDB();
ug.name = tbName.Text;
ug.description = tbDescription.Text;
ug.comment = tbComment.Text;
ug.date_created = tbRegDate.Text;
ug.AddToDB();
this.Close();
MessageBox.Show("Группа " + group_name + " создана!");
}
public EditUser(int _id_user)
{
InitializeComponent();
this.id_user = _id_user;
UserDB obj = new UserDB(_id_user);
tbName.Text = obj.name;
tbSername.Text = obj.last_name;
tbMiddleName.Text = obj.middle_name;
tbLogin.Text = obj.login;
tbPassword.Text = obj.password;
tbRegDate.Text = obj.register_time;
tbComment.Text = obj.comment;
tbPhone.Text = obj.phone;
tbEmail.Text = obj.email;
tbAddress.Text = obj.address;
cbConfirmed.Checked = Convert.ToBoolean(obj.confirmed);
cbBlock.Checked = Convert.ToBoolean(obj.block);
int selected_index = 0;
UsersGroupDB tu_obj = new UsersGroupDB();
tu_obj.Fill();
Dictionary <string, string> user_types = new Dictionary <string, string>();
for (int i = 0; i < tu_obj.list_objects.Count; i++)
{
user_types.Add(tu_obj.list_objects[i].id.ToString(), tu_obj.list_objects[i].name);
// Определим selected_index для выбранного типа
if (obj.type_user == tu_obj.list_objects[i].id)
{
selected_index = i;
}
}
cbGroup.DataSource = new BindingSource(user_types, null);
cbGroup.DisplayMember = "Value";
cbGroup.ValueMember = "Key";
cbGroup.SelectedIndex = selected_index;
obj = null;
}
public AddUser()
{
InitializeComponent();
tbRegDate.Text = DateTime.Now.ToString("");
UsersGroupDB obj = new UsersGroupDB();
obj.Fill();
Dictionary <string, string> user_group_list = new Dictionary <string, string>();
for (int i = 0; i < obj.list_objects.Count; i++)
{
user_group_list.Add(obj.list_objects[i].id.ToString(), obj.list_objects[i].name);
}
cbGroup.DataSource = new BindingSource(user_group_list, null);
cbGroup.DisplayMember = "Value";
cbGroup.ValueMember = "Key";
cbGroup.SelectedIndex = 0;
}
private void btnConfirm_Click_1(object sender, EventArgs e)
{
this.Close();
DialogResult dr = MessageBox.Show("Вы уверены, что хотите удалить объект?", "Вопрос", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
// Получим список юзеров данной группы
UsersDB udb = new UsersDB();
int group_from_id = Convert.ToInt32(((KeyValuePair <string, string>)cbUserGroupDelete.SelectedItem).Key);
// Если удаляем пользователей вместе с группой
if (rbDeleteUser.Checked == true)
{
udb.DeleteByGroupId(group_from_id);
}
// Если перемещаем пользователей группы в другую группу
if (rbMoveUser.Checked == true)
{
int group_to_move_id = Convert.ToInt32(((KeyValuePair <string, string>)cbUserGroupMove.SelectedItem).Key);
udb.MoveToGroupId(group_from_id, group_to_move_id);
}
// Затем удаляем группу из user_group
UsersGroupDB obj = new UsersGroupDB();
obj.Delete(Convert.ToInt32(((KeyValuePair <string, string>)cbUserGroupDelete.SelectedItem).Key));
// Обновим dgv
MainForm main_fm = (MainForm)Application.OpenForms["MainForm"];
main_fm.UpdateDGV_Users();
break;
case DialogResult.No:
break;
}
this.Close();
}
public DeleteUserGroup()
{
InitializeComponent();
UsersGroupDB obj = new UsersGroupDB();
rbDeleteUser.Checked = true;
obj.Fill();
// list групп для удаления
Dictionary <string, string> user_groups_list_delete = new Dictionary <string, string>();
for (int i = 0; i < obj.list_objects.Count; i++)
{
user_groups_list_delete.Add(obj.list_objects[i].id.ToString(), obj.list_objects[i].name);
}
// list групп для перемещения в неё
Dictionary <string, string> user_group_list_move = new Dictionary <string, string>();
for (int i = 0; i < obj.list_objects.Count; i++)
{
// Исключим из списка удаляемую группу, как?
user_group_list_move.Add(obj.list_objects[i].id.ToString(), obj.list_objects[i].name);
}
cbUserGroupDelete.DataSource = new BindingSource(user_groups_list_delete, null);
cbUserGroupDelete.DisplayMember = "Value";
cbUserGroupDelete.ValueMember = "Key";
cbUserGroupDelete.SelectedIndex = 0;
cbUserGroupMove.DataSource = new BindingSource(user_group_list_move, null);
cbUserGroupMove.DisplayMember = "Value";
cbUserGroupMove.ValueMember = "Key";
cbUserGroupMove.SelectedIndex = 0;
}
public AddRules()
{
InitializeComponent();
// ТЕСТЫ ------------------------------------------------------------------------------
dgvTests.Rows.Clear();
TestsGroupDB obj = new TestsGroupDB();
obj.Fill();
Dictionary <string, string> test_group_list = new Dictionary <string, string>();
for (int i = 0; i < obj.list_objects.Count; i++)
{
test_group_list.Add(obj.list_objects[i].id.ToString(), obj.list_objects[i].name);
}
cbTests.DataSource = new BindingSource(test_group_list, null);
cbTests.DisplayMember = "Value";
cbTests.ValueMember = "Key";
cbTests.SelectedIndex = 0;
tests = new TestsDB();
tests.Fill(Convert.ToInt32(((KeyValuePair <string, string>)cbTests.SelectedItem).Key));
for (int i = 0; i < tests.objects.Count; i++)
{
dgvTests.Rows.Add(
tests.objects[i].id,
false,
img_test,
tests.objects[i].name
);
}
// ПОЛЬЗОВАТЕЛИ -------------------------------------------------------------------------
dgvUsers.Rows.Clear();
UsersGroupDB obj_user = new UsersGroupDB();
obj_user.Fill();
Dictionary <string, string> user_group_list = new Dictionary <string, string>();
for (int i = 0; i < obj_user.list_objects.Count; i++)
{
user_group_list.Add(obj_user.list_objects[i].id.ToString(), obj_user.list_objects[i].name);
}
cbUsers.DataSource = new BindingSource(user_group_list, null);
cbUsers.DisplayMember = "Value";
cbUsers.ValueMember = "Key";
cbUsers.SelectedIndex = 0;
users = new UsersDB();
users.Fill(Convert.ToInt32(((KeyValuePair <string, string>)cbUsers.SelectedItem).Key));
for (int i = 0; i < users.objects.Count; i++)
{
dgvUsers.Rows.Add(
users.objects[i].id,
false,
img_test,
users.objects[i].last_name
);
}
// ГРУППА ПРАВИЛ -------------------------------------------------------------------------
RulesGroupDB obj_rules = new RulesGroupDB();
obj_rules.Fill();
Dictionary <string, string> rules_group_list = new Dictionary <string, string>();
for (int i = 0; i < obj_rules.list_objects.Count; i++)
{
rules_group_list.Add(obj_rules.list_objects[i].id.ToString(), obj_rules.list_objects[i].name);
}
cbRulesGroup.DataSource = new BindingSource(rules_group_list, null);
cbRulesGroup.DisplayMember = "Value";
cbRulesGroup.ValueMember = "Key";
cbRulesGroup.SelectedIndex = 0;
// РАСПИСАНИЕ ----------------------------------------------------------------------------
rbRaspType2.Checked = true;
rasp1_dateStart.CustomFormat = "dd.MM.yyyy hh:mm:ss";
rasp1_dateFinish.CustomFormat = "dd.MM.yyyy hh:mm:ss";
// КОЛИЧЕСТВО ПОПЫТОК --------------------------------------------------------------------
//cbNumberAttemptValue.SelectedIndex = 0;
}