private void OKBtn_Click(object sender, EventArgs e)
{
if (FIOtextBox.Text != "" && LogintextBox.Text != "" && PsswdtextBox.Text != "")
{
DataSet1 newDataSet1 = new DataSet1();
DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter();
workerTA.Fill(newDataSet1.worker);
if (EditFlag == false)
{
workerTA.Insert(LogintextBox.Text, PsswdtextBox.Text, comboBox1.Text, FIOtextBox.Text, BornDTP.Value.Date);
}
else
{
workerTA.UpdateQuery(LogintextBox.Text, PsswdtextBox.Text, comboBox1.Text, FIOtextBox.Text, Convert.ToString(BornDTP.Value.Date),
Login, Password, tipe, FIO, Convert.ToString(BornDate));
}
SuccessFlag = true;
WorkerAddForm.ActiveForm.Close();
}
else
{
MessageBox.Show("Заполнены не все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
FIOtextBox.Focus();
}
}
private void Form1_Shown(object sender, EventArgs e)
{
label7.Text = label7.Text + login;
label14.Text = label14.Text + login;
label20.Text = label20.Text + login;
label17.Text = label17.Text + login;
DataSet1 newDataSet1 = new DataSet1();
DateTime onlyDate;
DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter();
workerTA.Fill(newDataSet1.worker);
workerTA.Adapter.SelectCommand.CommandText = "SELECT * FROM worker WHERE worker_login='******' and worker_password ='******'";
workerTA.Fill(newDataSet1.worker);
DataTable workerTable = newDataSet1.worker;
DataRow[] foundRowsWorkers = workerTable.Select();
foreach (DataRow rowWork in foundRowsWorkers)
{
label10.Text = label10.Text + rowWork["worker_fio"].ToString();
label13.Text = label10.Text;
label16.Text = label10.Text;
label19.Text = label10.Text;
onlyDate = DateTime.Parse(rowWork["worker_born"].ToString());
label11.Text = label11.Text + onlyDate.Date.ToString("yyyy-MM-dd");
label12.Text = label11.Text;
label15.Text = label11.Text;
label18.Text = label11.Text;
}
}
private void button2_Click(object sender, EventArgs e)
{
string cell = dataGridView1.CurrentRow.Cells[5].Value.ToString();
DialogResult result = MessageBox.Show("Вы действительно хотите удалить эту запись?",
"Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
DataSet1 newDataSet1 = new DataSet1();
DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter();
workerTA.DeleteQuery(Convert.ToInt32(cell));
WorkerViewForm_Activated(sender, e);
}
}
private void pictureBox6_Click(object sender, EventArgs e)
{
DataSet1 newDataSet1 = new DataSet1();
DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter();
workerTA.Fill(newDataSet1.worker);
workerTA.Adapter.SelectCommand.CommandText = "SELECT * FROM worker WHERE worker_login='******' and worker_password ='******'" + " and worker_type = 'Администратор'";
workerTA.Fill(newDataSet1.worker);
if (newDataSet1.worker.Rows.Count == 1)
{
WorkerAddForm a = new WorkerAddForm("Добавление нового сотрудника", "", "", "", "", DateTime.Now, false);
a.ShowDialog();
}
else
{
MessageBox.Show("Действие доступно только администратору");
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet1 newDataSet1 = new DataSet1();
DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter();
workerTA.Fill(newDataSet1.worker);
workerTA.Adapter.SelectCommand.CommandText = "SELECT * FROM worker WHERE worker_login='******' and worker_password ='******'";
workerTA.Fill(newDataSet1.worker);
if (newDataSet1.worker.Rows.Count == 1)
{
this.Hide();
Form1 a = new Form1(login.Text.Trim(), psswd.Text.Trim());
a.Show();
}
else
{
MessageBox.Show("Неверный логин или пароль, обратитесь к Администратору");
}
}
