Beispiel #1
0
 public void FullUpdate()
 {
     if (Ubox.Text.Contains("Administrator"))
     {
         string[] txt = Ubox.Text.Split('|');
         string   sql = "Select UserID, FullName from users where(Role='Expert');";
         Aclb1.Items.Clear();
         sqldata = GetData(sql, 2);
         foreach (string[] x in sqldata)
         {
             Aclb1.Items.Add(x[0] + "|" + x[1]);
         }
         sqldata.Clear();
         comboBox1.Items.Clear();
         sql     = "select * from project";
         sqldata = GetData(sql, 2);
         foreach (string[] x in sqldata)
         {
             comboBox1.Items.Add(x[0] + "|" + x[1]);
         }
         Acb.Items.Clear();
         itbox.Items.Clear();
         sqldata.Clear();
         Art.Clear();
     }
     else if (Ubox.Text.Contains("Expert"))
     {
         other.Rows.Clear(); other.Columns.Clear();
         string[] txt = Ecb.Text.Split('|');
         Eqgrid.Rows.Clear(); Eqgrid.Columns.Clear();
         Eagrid.Rows.Clear(); Eagrid.Columns.Clear();
         Eqgrid.Columns.Add("Question Text", "Question Text");
         Eqgrid.Columns.Add("Unit", "Unit");
         Eqgrid.Columns.Add("Max", "Max");
         Eqgrid.Columns.Add("Min", "Min");
         string sql = "Select questionid,unit,maximum,minimum,text from question where qid=" + txt[0] + ";";
         sqldata = GetData(sql, 5);
         sql     = "select Max(iteration) from answer where (userid=" + Ubox.Text[0] + " and questionid=(select top 1 questionid from question where qid=" + Ecb.Text[0] + "));";
         var cmd = new SqlCommand();
         cmd.Connection  = Main.conn;
         cmd.CommandText = sql;
         SqlDataReader reader = cmd.ExecuteReader();
         try
         {
             while (reader.Read())
             {
                 if (it < Convert.ToInt32(reader[0].ToString()))
                 {
                     it = Convert.ToInt32(reader[0].ToString());
                 }
             }
         }
         catch
         {
             it = 0;
         }
         reader.Close();
         if (it < 1)
         {
             El3.Visible = true;
             etb.Visible = true;
         }
         else
         {
         }
         Eagrid.Columns.Add("Answer", "Answer"); Eagrid.Columns.Add("Explanation", "Explanation");
         for (int i = 0; i < sqldata.Count; i++)
         {
             Eqgrid.Rows.Add(); Eqgrid.Rows[i].HeaderCell.Value = sqldata[i][0];
             Eqgrid.Rows[i].Cells[0].Value = sqldata[i][4];
             Eqgrid.Rows[i].Cells[1].Value = sqldata[i][1];
             Eqgrid.Rows[i].Cells[2].Value = sqldata[i][2];
             Eqgrid.Rows[i].Cells[3].Value = sqldata[i][3];
             Eagrid.Rows.Add(); Eagrid.Rows[i].HeaderCell.Value = sqldata[i][0];
         }
         sqldata.Clear();
         Sb.Visible = true;
         other.Columns.Clear(); other.Rows.Clear();
         sql     = "select questionid from question where qid=" + Ecb.Text[0] + ";";
         sqldata = GetData(sql, 1);
         int max = 0;
         sql             = "select max(iteration) from answer where questionid=" + sqldata[0][0] + ";";
         cmd             = new SqlCommand();
         cmd.Connection  = Main.conn;
         cmd.CommandText = sql;
         reader          = cmd.ExecuteReader();
         try
         {
             while (reader.Read())
             {
                 if (max < Convert.ToInt32(reader[0].ToString()))
                 {
                     max = Convert.ToInt32(reader[0].ToString());
                 }
             }
         }
         catch
         {
             max = 0;
         }
         reader.Close();
         if (max >= 1)
         {
             other.Columns.Add("Answer", "Answer");
             other.Columns.Add("Explanation", "Explanation");
             foreach (string[] x in sqldata)
             {
                 sql = "select answer, explanation from answer where questionid=" + x[0] + " and iteration=" + max + " and userid!=" + Ubox.Text[0] + ";";
                 List <string[]> ans = GetData(sql, 2);
                 foreach (string[] y in ans)
                 {
                     other.Rows.Add(); other.Rows[other.Rows.Count - 1].HeaderCell.Value = x[0];
                     other.Rows[other.Rows.Count - 1].Cells[0].Value = y[0];
                     other.Rows[other.Rows.Count - 1].Cells[1].Value = y[1];
                 }
             }
             sqldata.Clear();
         }
     }
 }