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;
}
