private void button1_Click(object sender, EventArgs e) { string dtSt = dtpStart.Value.ToString("yyyy-MM-dd"), dtNd = dtpEnd.Value.ToString("yyyy-MM-dd"), emp = cbEmployee.SelectedValue.ToString(), desc = tbDescription.Text; string query = ""; if (cbHasEndDate.Checked) { query = string.Format("insert into [Order] (empl_id,dateStart,dateEnd,description) values ({0}, '{1}', '{2}', '{3}');", emp, dtSt, dtNd, desc); } else { query = string.Format("insert into [Order] (empl_id,dateStart,description) values ({0}, '{1}', '{2}');", emp, dtSt, desc); } if (radioButton2.Checked & (checkBox1.Checked | checkBox2.Checked)) { string addQuery = ""; if (checkBox2.Checked & checkBox1.Checked) { var post = cbPost.SelectedValue; var empl = cbEmployee.SelectedValue; var dep = cbDep.SelectedValue; addQuery = string.Format("update Employee set post_id = {0},dep_id={1} where id = {2};", post, dep, empl); } else if (checkBox1.Checked) { var post = cbPost.SelectedValue; var empl = cbEmployee.SelectedValue; addQuery = string.Format("update Employee set post_id = {0} where id = {1};", post, empl); } else if (checkBox2.Checked) { var empl = cbEmployee.SelectedValue; var dep = cbDep.SelectedValue; addQuery = string.Format("update Employee set dep_id={1} where id = {2};", dep, empl); } DBConnect.ExecuteNonQuery(addQuery); } if (radioButton3.Checked) { var empl = cbEmployee.SelectedValue; var addQuery = string.Format("update Employee set fired=1 where id = {0};", empl); DBConnect.ExecuteNonQuery(addQuery); } DBConnect.ExecuteNonQuery(query); Close(); }
private void button3_Click(object sender, EventArgs e) { string name = tbName.Text, birth = dtpBirth.Value.ToString("yyyy-MM-dd"), tab = textBox3.Text, inn = tbInn.Text, snils = tbSnils.Text, dep = cbDep.SelectedValue.ToString(), post = cbPost.SelectedValue.ToString(), pasp = tbPasp.Text, query = string.Format(@"insert into Employee (name,birth,inn,snils,pasp,post_id,dep_id,tabNumber) values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}');", name, birth, inn, snils, pasp, post, dep, tab); if (!ret) { DBConnect.ExecuteNonQuery(query); } else { query += "SELECT CAST(scope_identity() AS int)"; worker = Convert.ToInt16(DBConnect.ExecuteScalar(query)); } Close(); }