protected void Button1_Click1(object sender, EventArgs e)
{
if (Class_FIO.Employees_position == "1")
{
oraConnection.Open();
Get_ID_Position();
if (TextBox2.Text != "" && DropDownList_Position.SelectedValue.ToString() != "-Выберите должность-")
{
string query = "INSERT INTO TECHNOPARK.EMPLOYEES (POSITION, FIO) VALUES('" + id_position + "', '" + TextBox2.Text + "')";
oraAdap.InsertCommand = new OracleCommand(query, oraConnection);
oraAdap.InsertCommand.ExecuteNonQuery();
Select_Key();
Response.Write("<script>alert('Данные успешно добавлены! Ваш пароль: " + s_key + "')</script>");
GridView1.DataBind();
TextBox2.Text = string.Empty;
DropDownList_Position.ClearSelection();
//DropDownList1.SelectedIndex = -1;
DropDownList_Position.DataBind();
}
else
{
Response.Write("<script>alert('Проверьте введенные данные!')</script>");
}
}
else
{
TextBox2.Text = string.Empty;
DropDownList_Position.ClearSelection();
Response.Write("<script>alert('Только методист может добавлять нового сотрудника!')</script>");
}
}
private void GetPosition()
{
string s1 = "Select DIR_POSITION from DIR_POSITION Where ID_DIR_POSITION <>3";
OracleDataAdapter oraAdap = new OracleDataAdapter(s1, oraConnection);
oraAdap.Fill(ds_position);
if (ds_position.Tables[0].Rows.Count > 0)
{
DropDownList_Position.DataSource = ds_position;
DropDownList_Position.DataTextField = "DIR_POSITION";
DropDownList_Position.DataBind();
DropDownList_Position.Items.Insert(0, new ListItem("-Выберите должность-"));
DropDownList_Position.SelectedIndex = 0;
}
}
