public void SelectWorkers() { Lootbox.ClearWorkers(); string sqlquery = @"select * from workers order by id"; SqlCommand sqlcmd = new SqlCommand(sqlquery, KEDR); KEDR.Open(); using (SqlDataReader reader = sqlcmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { int id = (int)reader["id"]; string fname = (string)reader["f_name"]; string lname = (string)reader["l_name"]; string mname = (string)reader["m_name"]; float speed = (float)(double)reader["speed"]; int boxsize = (int)reader["box_size"]; bool isbusy = (bool)reader["is_busy"]; Worker worker = new Worker(id, fname, lname, mname, speed, (BoxSize)boxsize, isbusy); Lootbox.AddWorker(worker); } } } KEDR.Close(); }
private void Click_btnAdd(object sender, EventArgs e) { this.Enabled = false; if ((bool)(txtFName.Tag ?? false) && (bool)(txtLName.Tag ?? false) && (bool)(txtMName.Tag ?? false) && (bool)(txtSpeed.Tag ?? false)) { string message = ""; message += txtFName.Text.Trim() + " "; message += txtLName.Text.Trim() + " "; message += txtMName.Text.Trim(); var res = MessageBox.Show($"Будет добавлен работник {message}", "Внимание", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation); if (res == DialogResult.OK) { string fname = txtFName.Text.Trim(); string lname = txtLName.Text.Trim(); string mname = txtMName.Text.Trim(); float speed = float.Parse(txtSpeed.Text.Trim()); int boxsize = (int)Enum.Parse(typeof(BoxSize), cmbBoxSize.Text.Trim(), true); Lootbox.AddWorker(fname, lname, mname, speed, boxsize); dgvWorkers.Rows.Clear(); dgvWorkers.Rows.AddRange(Lootbox.FillGridWorkers().ToArray()); ResetUserControls(); } } else { MessageBox.Show($"Данные не коректны или не предоставлены.\nИли исправьте подсвеченные поля.", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } this.Enabled = true; }