private void schDepartment_changee(object sender, EventArgs e)
{
int idOfDep = DBConnection.GetDepartmentID(schDepartment.Text);
DataTable dt = DBConnection.SelectWorkersByDep(idOfDep);
dataGridView1.DataSource = dt;
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=DESKTOP-3MKAK0L;Initial Catalog=CompanyDB;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
conn.Open();
int idOfPos = DBConnection.GetIDByPositionName(comboBox.SelectedItem.ToString());
//DateTime date = DateTime.Parse(textBox6.Text);
//Изпълнение на метод, който изпраща заявка, която връща ID на избрания тип
int idOfDep = DBConnection.GetDepartmentID(comboBox2.SelectedItem.ToString());
SqlDataAdapter dataAdap = new SqlDataAdapter("UPDATE Worker SET Name= '" + textBox2.Text + "', Lastname ='" + textBox3.Text + "', PositionID ='" + idOfPos + "', DepartmentID ='" + idOfDep + "', АppointmentDate ='" + textBox6.Text + "'WHERE WorkerID='" + textBox1.Text + "'", conn);
dataAdap.SelectCommand.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Data updated successfully!");
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("Please enter a name/lastname!");
return;
}
//int workerID;
string name = textBox2.Text;
string lastname = textBox3.Text;
//string date = (textBox6.Text);
DateTime date = DateTime.Parse(textBox6.Text);
/*try
* {
* workerID = int.Parse(textBox1.Text);
* }
* catch (FormatException)
* {
* MessageBox.Show("Please enter a ID!");
*
* return;
* }*/
int idOfPos = DBConnection.GetIDByPositionName(comboBox.SelectedItem.ToString());
//Изпълнение на метод, който изпраща заявка, която връща ID на избрания отдел
int idOfDep = DBConnection.GetDepartmentID(comboBox2.SelectedItem.ToString());
/*if (idOfDep == -1)
* {
* MessageBox.Show("There is no ID for type: " + typeListBox.SelectedItem.ToString() + "!");
*
* return;
* }*/
DBConnection.InsertWorkerToDB(name, lastname, idOfPos, idOfDep, date);
}