protected void Button4_Click(object sender, EventArgs e)
{
LMsg.Text = "";
if (DropDownList1.SelectedIndex == 0)
{
LMsg.Text = "ابتدا عضو مورد نظر را از ليست انتخاب كنيد !";
DropDownList1.Focus();
return;
}
if (CheckBox1.Checked == false)
{
LMsg.Text = "ابتدا گزينه مربوط به ( تاييد حذف ) را فعال كنيد !";
CheckBox1.Focus();
return;
}
conn.Close();
SqlCommand cmd4 = new SqlCommand("update User_Pass set Manager = 'No' where User_Name = '" + DropDownList1.SelectedItem.Text + "'", conn);
conn.Open();
SqlDataReader reader4;
reader4 = cmd4.ExecuteReader();
conn.Close();
LMsg.Text = "براي عضو انتخاب شده اجازه دسترسي به بخش مديريت لغو شد !";
Label8.Text = "No";
CheckBox1.Checked = false;
}
protected void Button1_Click1(object sender, EventArgs e)
{
LMsg.Text = "";
if (DropDownList1.SelectedIndex == 0)
{
LMsg.Text = "ابتدا عضو مورد نظر را از ليست انتخاب كنيد !";
DropDownList1.Focus();
return;
}
if (CheckBox1.Checked == false)
{
LMsg.Text = "ابتدا گزينه مربوط به ( تاييد حذف ) را فعال كنيد !";
CheckBox1.Focus();
return;
}
conn.Close();
SqlCommand cmd4 = new SqlCommand("Delete from User_Pass where User_Name = '" + DropDownList1.SelectedItem.Text + "'", conn);
conn.Open();
SqlDataReader reader4;
reader4 = cmd4.ExecuteReader();
conn.Close();
LMsg.Text = "عضو انتخاب شده از ليست اعضاء حذف شد !";
Label3.Text = "";
Label4.Text = "";
Label5.Text = "";
Label6.Text = "";
Label7.Text = "";
Label8.Text = "";
Label9.Text = "";
Label10.Text = "";
CheckBox1.Checked = false;
DropDownList1.Items.Remove(DropDownList1.SelectedItem);
}
public MainWindow()
{
InitializeComponent();
List <CheckBox> checkboxes = new List <CheckBox>();
checkboxes.Add(CheckBox1);
checkboxes.Add(CheckBox2);
_checkboxes = checkboxes.ToArray();
_checkboxActions.Add(CheckBox1.GetHashCode(), OnCheckBox1Checked);
_checkboxActions.Add(CheckBox2.GetHashCode(), OnCheckBox2Checked);
}
private void LearnerLabInteres()
{
string command = SqlDataSource2.SelectCommand;
//SqlDataSource2.SelectCommand = "SELECT TECHNOPARK.LEARNER.ID_LEARNER, TECHNOPARK.LEARNER.FIO, TECHNOPARK.QUEUE.DATE_REGISTRATION, TECHNOPARK.LEARNER.CLASS, TECHNOPARK.LEARNER.SHIFT, TECHNOPARK.LEARNER.SCHOOL, TECHNOPARK.DIR_LABORATORIES.LABORATORY, TECHNOPARK.DIR_PROJECTS.TITLE, TECHNOPARK.QUEUE.ID_QUEUE FROM (SELECT ID_LEARNER_Q AS ID_l, ID_QUEUE FROM QUEUE WHERE ID_STATUS_L = 2 OR ID_STATUS_L = 10) A, TECHNOPARK.LEARNER INNER JOIN TECHNOPARK.QUEUE ON TECHNOPARK.LEARNER.ID_LEARNER = TECHNOPARK.QUEUE.ID_LEARNER_Q INNER JOIN TECHNOPARK.DIR_PROJECTS ON TECHNOPARK.QUEUE.ID_PROJECT = TECHNOPARK.DIR_PROJECTS.ID_DIR_PROJECTS INNER JOIN TECHNOPARK.DIR_LABORATORIES ON TECHNOPARK.QUEUE.ID_LABORATORIES = TECHNOPARK.DIR_LABORATORIES.ID_LABORATORIES INNER JOIN TECHNOPARK.DIR_STATUS_LEARNER ON TECHNOPARK.QUEUE.ID_STATUS_L = TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER WHERE(TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 2) AND(TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 6) AND(TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 7) AND(TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 8) AND(TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 10) and TECHNOPARK.DIR_LABORATORIES.LABORATORY = '" + DropDownList2.Text + "' and ID_LEARNER!= 0 AND QUEUE.ID_QUEUE != 0 AND A.ID_QUEUE = QUEUE.ID_QUEUE AND LEARNER.ID_LEARNER<> A.ID_l";
//SqlDataSource2.SelectCommand = "SELECT TECHNOPARK.LEARNER.ID_LEARNER, TECHNOPARK.LEARNER.FIO, TECHNOPARK.QUEUE.DATE_REGISTRATION, TECHNOPARK.LEARNER.CLASS, TECHNOPARK.LEARNER.SHIFT, TECHNOPARK.LEARNER.SCHOOL, TECHNOPARK.DIR_LABORATORIES.LABORATORY, TECHNOPARK.DIR_PROJECTS.TITLE, TECHNOPARK.QUEUE.ID_QUEUE FROM TECHNOPARK.QUEUE INNER JOIN TECHNOPARK.DIR_LABORATORIES ON TECHNOPARK.QUEUE.ID_LABORATORIES = TECHNOPARK.DIR_LABORATORIES.ID_LABORATORIES INNER JOIN TECHNOPARK.DIR_PROJECTS ON TECHNOPARK.QUEUE.ID_PROJECT = TECHNOPARK.DIR_PROJECTS.ID_DIR_PROJECTS INNER JOIN TECHNOPARK.LEARNER ON TECHNOPARK.QUEUE.ID_LEARNER_Q = TECHNOPARK.LEARNER.ID_LEARNER where TECHNOPARK.LEARNER.INTERESTS LIKE '%" + DropDownList2.Text + "%' minus SELECT TECHNOPARK.LEARNER.ID_LEARNER, TECHNOPARK.LEARNER.FIO, QUEUE.DATE_REGISTRATION, TECHNOPARK.LEARNER.CLASS, TECHNOPARK.LEARNER.SHIFT, TECHNOPARK.LEARNER.SCHOOL, TECHNOPARK.DIR_LABORATORIES.LABORATORY, TECHNOPARK.DIR_PROJECTS.TITLE, TECHNOPARK.QUEUE.ID_QUEUE FROM TECHNOPARK.QUEUE INNER JOIN TECHNOPARK.DIR_LABORATORIES ON TECHNOPARK.QUEUE.ID_LABORATORIES = TECHNOPARK.DIR_LABORATORIES.ID_LABORATORIES INNER JOIN TECHNOPARK.DIR_PROJECTS ON TECHNOPARK.QUEUE.ID_PROJECT = TECHNOPARK.DIR_PROJECTS.ID_DIR_PROJECTS INNER JOIN TECHNOPARK.LEARNER ON TECHNOPARK.QUEUE.ID_LEARNER_Q = TECHNOPARK.LEARNER.ID_LEARNER INNER JOIN (SELECT DISTINCT ID_LEARNER_Q AS id_q FROM TECHNOPARK.QUEUE b WHERE (ID_STATUS_L = 2) OR (ID_STATUS_L = 10)) a ON TECHNOPARK.QUEUE.ID_LEARNER_Q = a.id_q";
SqlDataSource2.SelectCommand = "SELECT TECHNOPARK.LEARNER.ID_LEARNER, TECHNOPARK.LEARNER.FIO, TECHNOPARK.QUEUE.DATE_REGISTRATION, TECHNOPARK.LEARNER.CLASS, TECHNOPARK.LEARNER.SHIFT, TECHNOPARK.LEARNER.SCHOOL, TECHNOPARK.LEARNER.PHONE, TECHNOPARK.LEARNER.INTERESTS, TECHNOPARK.DIR_LABORATORIES.LABORATORY, TECHNOPARK.DIR_PROJECTS.TITLE, TECHNOPARK.QUEUE.ID_QUEUE FROM TECHNOPARK.QUEUE INNER JOIN TECHNOPARK.DIR_LABORATORIES ON TECHNOPARK.QUEUE.ID_LABORATORIES = TECHNOPARK.DIR_LABORATORIES.ID_LABORATORIES INNER JOIN TECHNOPARK.DIR_PROJECTS ON TECHNOPARK.QUEUE.ID_PROJECT = TECHNOPARK.DIR_PROJECTS.ID_DIR_PROJECTS INNER JOIN TECHNOPARK.LEARNER ON TECHNOPARK.QUEUE.ID_LEARNER_Q = TECHNOPARK.LEARNER.ID_LEARNER where TECHNOPARK.QUEUE.Date_Registration = (Select max(Date_Registration) from QUEUE Q where Q.ID_LEARNER_Q = TECHNOPARK.QUEUE.ID_LEARNER_Q) and TECHNOPARK.LEARNER.INTERESTS LIKE '%" + DropDownList2.Text + "%' or(TECHNOPARK.DIR_LABORATORIES.LABORATORY = '" + DropDownList2.Text + "' and((ID_STATUS_L = 1) OR(ID_STATUS_L = 4))) minus SELECT TECHNOPARK.LEARNER.ID_LEARNER, TECHNOPARK.LEARNER.FIO, QUEUE.DATE_REGISTRATION, TECHNOPARK.LEARNER.CLASS, TECHNOPARK.LEARNER.SHIFT, TECHNOPARK.LEARNER.SCHOOL, TECHNOPARK.LEARNER.PHONE, TECHNOPARK.LEARNER.INTERESTS, TECHNOPARK.DIR_LABORATORIES.LABORATORY, TECHNOPARK.DIR_PROJECTS.TITLE, TECHNOPARK.QUEUE.ID_QUEUE FROM TECHNOPARK.QUEUE INNER JOIN TECHNOPARK.DIR_LABORATORIES ON TECHNOPARK.QUEUE.ID_LABORATORIES = TECHNOPARK.DIR_LABORATORIES.ID_LABORATORIES INNER JOIN TECHNOPARK.DIR_PROJECTS ON TECHNOPARK.QUEUE.ID_PROJECT = TECHNOPARK.DIR_PROJECTS.ID_DIR_PROJECTS INNER JOIN TECHNOPARK.LEARNER ON TECHNOPARK.QUEUE.ID_LEARNER_Q = TECHNOPARK.LEARNER.ID_LEARNER INNER JOIN (SELECT DISTINCT ID_LEARNER_Q AS id_q FROM TECHNOPARK.QUEUE b WHERE(ID_STATUS_L = 2) OR(ID_STATUS_L = 10)) a ON TECHNOPARK.QUEUE.ID_LEARNER_Q = a.id_q";
//SqlDataSource2.SelectCommand = "SELECT TECHNOPARK.LEARNER.ID_LEARNER, TECHNOPARK.LEARNER.FIO, TECHNOPARK.QUEUE.DATE_REGISTRATION, TECHNOPARK.LEARNER.CLASS, TECHNOPARK.LEARNER.SHIFT, TECHNOPARK.LEARNER.SCHOOL, TECHNOPARK.DIR_LABORATORIES.LABORATORY, TECHNOPARK.DIR_PROJECTS.TITLE, TECHNOPARK.QUEUE.ID_QUEUE FROM TECHNOPARK.LEARNER INNER JOIN TECHNOPARK.QUEUE ON TECHNOPARK.LEARNER.ID_LEARNER = TECHNOPARK.QUEUE.ID_LEARNER_Q INNER JOIN TECHNOPARK.DIR_PROJECTS ON TECHNOPARK.QUEUE.ID_PROJECT = TECHNOPARK.DIR_PROJECTS.ID_DIR_PROJECTS INNER JOIN TECHNOPARK.DIR_LABORATORIES ON TECHNOPARK.QUEUE.ID_LABORATORIES = TECHNOPARK.DIR_LABORATORIES.ID_LABORATORIES INNER JOIN TECHNOPARK.DIR_STATUS_LEARNER ON TECHNOPARK.QUEUE.ID_STATUS_L = TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER WHERE (TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 2) AND (TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 6) AND (TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 7) AND (TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 8) AND (TECHNOPARK.DIR_STATUS_LEARNER.ID_DIR_STATUS_LEARNER <> 10) and ID_LEARNER !=0 and TECHNOPARK.LEARNER.INTERESTS LIKE '%" + DropDownList2.Text + "%' or TECHNOPARK.DIR_LABORATORIES.LABORATORY = '" + DropDownList2.Text + "' AND ID_QUEUE!=0 ";
SqlDataSource2.DataBind();
CheckBox1.DataBind();
GridView1.DataBind();
Label9.Visible = true;
Label9.Text = "Список обучающихся по выбранному проекту, с учетом интересов";
}
