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