using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
 
namespace Modul1
{
    public partial class About : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //Предоставление прав доступа.
            String AlloyQuery =
            "SELECT id_control " +
            "FROM Access_rights WHERE id_user = " + Convert.ToInt16(Session["id_user"]) + ";";
            SqlConnection SelConnect =
                new SqlConnection("Data Source=(local)\\SQLEXPRESS;Initial Catalog=Alloys_db;" +
                    "Integrated Security=False; Pooling=False; User ID=sa;Password=' '");
            SqlCommand SelCommand = new SqlCommand(AlloyQuery.ToString(), SelConnect); //Создаём команду (запрос, соединение)
            SelConnect.Open();
            SqlDataReader AddReader = SelCommand.ExecuteReader();
            while (AddReader.Read())
            {
                if (AddReader["id_control"].ToString() == "AdmPanel1") { AdmPanel1.Visible = true; }
                if (AddReader["id_control"].ToString() == "AdmPanel2") { AdmPanel2.Visible = true; }
                if (AddReader["id_control"].ToString() == "AdmPanel3") { AdmPanel3.Visible = true; }
            }
            AddReader.Close();
            SelConnect.Close();
     
            //Создаём массив ссылок-кнопок для сплавов.
            LinkButton[] Alloy_buttons = new LinkButton[100];
           int i = 0;
            TableRow rw = new TableRow();
            AlloyQuery =
                "SELECT id_alloy, alloy_mark " +
                "FROM Alloys ORDER BY alloy_mark ASC;";
            SelCommand = new SqlCommand(AlloyQuery.ToString(), SelConnect); //Создаём команду (запрос, соединение)
            SelConnect.Open();
            AddReader = SelCommand.ExecuteReader();
            while (AddReader.Read())
            {
                Literal Lit1 = new Literal();
                Lit1.Text = "<br/>";
                Alloy_buttons[i] = new LinkButton();
                Alloy_buttons[i].Text = AddReader["alloy_mark"].ToString();
                Alloy_buttons[i].Click += new System.EventHandler(AButton_Click);
                Alloy_buttons[i].ID = "A0Button" + AddReader["id_alloy"].ToString(); //Записываем id сплава в button.ID.
                Alloy_buttons[i].PostBackUrl = "~/About.aspx";
                if (i % 4 == 0) { rw = new TableRow(); }
                if ((i + 1) % 8 == 0) { rw.BackColor = System.Drawing.Color.FromName("#A2CD5A"); }
                else { rw.BackColor = System.Drawing.Color.FromName("#BCEE68"); };
                TableCell cel = new TableCell();
                cel.Controls.Add(Alloy_buttons[i]);
                i++;
                rw.Cells.Add(cel);
                Table1.Rows.Add(rw);
            }
            AddReader.Close();
 
            SelConnect.Close();
 
            
 
        }
        //Переход на страницу сплава.
        void AButton_Click(object sender, EventArgs e)
        {
            LinkButton[] Alloy_buttons1 = new LinkButton[100]; //Верхний процент хим. состава
            LinkButton[] Alloy_buttons2 = new LinkButton[100]; //Нижний процент хим. состава
            
 
            //cоздаём таблицу с химическими элементами:
 
            TableCell cel = new TableCell();//столбец
            int i = 0;
            int n = 0; //счётчик строк
            TableRow rw = new TableRow();
            rw.Height = 50;
            rw.BackColor = System.Drawing.Color.FromName("#A2CD5A");
            for (int j = 0; j < 2; j++)
            {
                cel = new TableCell();
                cel.Text = "Элемент";
                cel.Width = Unit.Percentage(10);
                rw.Cells.Add(cel);
                cel = new TableCell();
                cel.Text = "от, %";
                cel.Width = Unit.Percentage(10);
                rw.Cells.Add(cel);
                cel = new TableCell();
                cel.Text = "до, %";
                cel.Width = Unit.Percentage(10);
                rw.Cells.Add(cel);
                
 
            }
            Table2.Rows.Add(rw);
            rw = new TableRow();
 
            String AlloyQuery =
 
                         "SELECT id_element, el_notation " +
                         "FROM Chemical_el ORDER BY el_notation ASC;";
            SqlConnection SelConnect =
             new SqlConnection("Data Source=(local)\\SQLExpress;Initial Catalog=Alloys_db;" +
                     "Integrated Security=False; Pooling=False; User ID=sa;Password=' '");
            SqlCommand SelCommand = new SqlCommand(AlloyQuery.ToString(), SelConnect); //Создаём команду (запрос, соединение)
            SelConnect.Open();
            SqlDataReader AddReader = SelCommand.ExecuteReader();
 
 
 
            while (AddReader.Read())
            {
                //Элементы
                if (n % 2 == 0) { rw = new TableRow(); }
                cel = new TableCell();
                cel.Text = AddReader["el_notation"].ToString();
                cel.Width = Unit.Percentage(10);
                cel.BackColor = System.Drawing.Color.FromName("#BCEE68");
                if (AddReader["el_notation"].ToString() == "Прочие")
                {
                    cel.Text += " примеси";
                }
                rw.Cells.Add(cel);
                //Верхний процент
                cel = new TableCell();
                Alloy_buttons1[i] = new LinkButton();
                Alloy_buttons1[i].ID = "ABox1" + AddReader["id_element"].ToString();
                Alloy_buttons1[i].Click += new System.EventHandler(QButton_Click);//при нажатии на эту кнопку значение этой кнопки должно попадать в формулу 
              
                cel.BackColor = System.Drawing.Color.FromName("#00FF00");
                Alloy_buttons1[i].Width = Unit.Percentage(95);
 
                cel.Controls.Add(Alloy_buttons1[i]);
                cel.Width = Unit.Percentage(10);
                rw.Cells.Add(cel);
                //Нижний процент
                cel = new TableCell();
                Alloy_buttons2[i] = new LinkButton();
                Alloy_buttons2[i].ID = "ABox1" + AddReader["id_element"].ToString();
                Alloy_buttons2[i].Click += new System.EventHandler(QButton_Click);//при нажатии на эту кнопку значение этой кнопки должно попадать в формулу 
                cel.BackColor = System.Drawing.Color.FromName("#00FF00");
                Alloy_buttons2[i].Width = Unit.Percentage(95);
                
                cel.Controls.Add(Alloy_buttons2[i]);
                cel.Width = Unit.Percentage(10);
                rw.Cells.Add(cel);
 
                Table2.Rows.Add(rw);
                i++;
                n++;
            }
            AddReader.Close();
            SelConnect.Close();
 
            //Заполнение значениями для хим. состава.
            for (int j = 0; j < i; j++)
            {
                AlloyQuery =
                    "SELECT max_percent, min_percent FROM Analysis WHERE id_element = " + Alloy_buttons1[j].ID.Substring(5) + ";";
                SelCommand = new SqlCommand(AlloyQuery.ToString(), SelConnect);
                SelConnect.Open();
                AddReader = SelCommand.ExecuteReader();
                if (AddReader.Read())
                {
                    Alloy_buttons1[j].Text = AddReader["min_percent"].ToString();
                    Alloy_buttons2[j].Text = AddReader["max_percent"].ToString();
 
                }
                AddReader.Close();
                SelConnect.Close();
            }
        }
 
 
 
                       
 
                                           
 
             void QButton_Click(object sender, EventArgs e)
        {
            здесь нужно сделать рассчет
                  
 
                     100+x
        }
          
                    
    
        
        protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            AdmPanel1.Visible = false;
            AdmPanel2.Visible = false;
            Session["id_user"] = null;
            AdmPanel3.Visible = false;
        }
        
 
        //==========>>
 
        
    }
}