?using System;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;    

namespace WindowsApplication1
{
    public partial class Menu : Form
    {
        public bool flag;
        public string limit;
        public string name;
        public bool cflag;
        public bool cflag1;
        public bool cflag2;
        public bool cflag3;
        public bool cflag4;
        public int count;
        public int count2;
        public string username;
        public string setlimit
        {
            set
            {
                limit = value;
            }
        }

        public string setname
        {
            set
            {
                name = value;
            }
        } 
        public Menu()
        {
            InitializeComponent();
            count = 0;
            count2 = 0;
            flag = false;
            cflag3 = false;
            cflag2 = false;
            cflag1 = false;    
            cflag = false;
            cflag4=false;
            
        }
        private DataSet ds;
        private DataSet ds1;
        private DataSet ds2;
        private SqlDataAdapter q;
        public SqlDataAdapter q1;
        public SqlDataAdapter q2;
        private void button1_Click(object sender, EventArgs e)
        {
            if (cflag || cflag2)
            {
              
                dataGridView1.Enabled = false;
                dataGridView1.Visible = false;
                dataGridView3.Enabled = true;
                dataGridView3.Visible = true;
              //  dataGridView4.Enabled = false;
             //   dataGridView4.Visible = false;
                dataGridView4.Enabled = true;
                dataGridView4.Visible = true;
             //   dataGridView7.Enabled = true;
              //  dataGridView7.Visible = true;
                dataGridView2.Enabled = false;
                dataGridView2.Visible = false;

                SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");

                if (cflag2)
                {
                    if (cflag == false)
                    {
                        dataGridView4.Enabled = false;
                        dataGridView4.Visible = false;
                    }
                    dataGridView2.Enabled = true;
                    dataGridView2.Visible = true;
                    string select2 = "select * from sell";
                    q2 = new SqlDataAdapter(select2, conn);
                    ds2 = new DataSet();
                    q2.Fill(ds2, "sell");
                  //  dataGridView4.DataSource = ds2.Tables[0];
                    dataGridView2.DataSource = ds2.Tables[0];
                }
                
                

                string select = "select * from users";
                q = new SqlDataAdapter(select, conn);
                ds = new DataSet();
                q.Fill(ds, "users");
                dataGridView3.DataSource = ds.Tables[0];

                string select1 = "select * from storage";
                q1 = new SqlDataAdapter(select1, conn);
                ds1 = new DataSet();
                q1.Fill(ds1, "storage");
               // dataGridView7.DataSource = ds.Tables[0];
                dataGridView4.DataSource = ds1.Tables[0];
            }

            else
            {
                dataGridView1.Enabled = true;
                dataGridView1.Visible = true;
              //  dataGridView7.Enabled = false;
               // dataGridView7.Visible = false;
                dataGridView4.Enabled = false;
                dataGridView4.Visible = false;
                dataGridView3.Enabled = false;
                dataGridView3.Visible = false;
       //         dataGridView4.Enabled = false;
         //       dataGridView4.Visible = false;
                dataGridView2.Enabled = false;
                dataGridView2.Visible = false;

                SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
                string select = "select * from users";
                q = new SqlDataAdapter(select, conn);
                ds = new DataSet();
                q.Fill(ds, "users");
                dataGridView1.DataSource = ds.Tables[0];
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                SqlCommandBuilder SCB = new SqlCommandBuilder(q);
                q.Update(ds, "users");
                if (cflag)
                {
                    SqlCommandBuilder SCB1 = new SqlCommandBuilder(q1);
                    q1.Update(ds1, "storage");
                   
                }
                if (cflag1)
                {
                    SqlCommandBuilder SCB2 = new SqlCommandBuilder(q2);
                    q2.Update(ds2, "sell");
                }
            }
            catch (IndexOutOfRangeException)
            {
                MessageBox.Show("Update error!");
                return;
            }
            MessageBox.Show("Update successful!");
        }

        private void changeUserToolStripMenuItem_Click(object sender, EventArgs e)
        {
            flag = true;
            this.Close();
        }

        private void exitToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void Menu_Load(object sender, EventArgs e)
        {
            int i;
            f();
            f1(false);
            panel1.Visible = false;
            panel2.Visible = false;
            panel3.Visible = false;

            if (limit != "2")
            {
                maintenanceToolStripMenuItem.Enabled = false;
                accountToolStripMenuItem.Enabled = false;
            }
            
            SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
            string select = "select * from sell";
            ds = new DataSet();
            q = new SqlDataAdapter(select, conn);
            q.Fill(ds, "sell");
            for (i = ds.Tables[0].Columns.Count; i>0; i--)
                sc.Items.Insert(0, ds.Tables[0].Columns[i - 1].ColumnName);
            sc.Items.Insert(0, "*");
            select = "select * from storage";
            ds1 = new DataSet();
            q1 = new SqlDataAdapter(select, conn);
            q1.Fill(ds1, "storage");
            for (i = ds1.Tables[0].Columns.Count; i > 0; i--)
                comboBox1.Items.Insert(0, ds1.Tables[0].Columns[i - 1].ColumnName);
             comboBox1.Items.Insert(0, "*");

        }

        private void maintenanceToolStripMenuItem_Click(object sender, EventArgs e)
        {
            f1(false);
            panel1.Visible = false;
            panel2.Visible = false;
            panel3.Visible = false;
            dataGridView1.Enabled = true;
            dataGridView1.Visible = true;
            dataGridView2.Enabled = false;
            dataGridView2.Visible = false;
            dataGridView3.Enabled = false;
            dataGridView3.Visible = false;
            dataGridView4.Enabled = false;
            dataGridView4.Visible = false;
            button1.Enabled = true;
            button2.Enabled = true;
            button1.Visible = true;
            button2.Visible = true;
            textBox1.Enabled = true;
            textBox1.Visible = true;
            button5.Enabled = true;
            button5.Visible = true;
            button3.Enabled = false;
            button3.Visible = false;
            button4.Enabled = false;
            button4.Visible = false;
            button6.Enabled = true;
            button6.Visible = true;
            textBox2.Enabled = true;
            textBox2.Visible = true;
            textBox3.Enabled = true;
            textBox3.Visible = true;
            label1.Enabled = true;
            label1.Visible = true;
            checkBox1.Enabled = true;
            checkBox1.Visible = true;
            checkBox3.Enabled = true;
            checkBox3.Visible = true;
            radioButton1.Enabled = true;
            radioButton1.Visible = true;
            radioButton2.Enabled = true;
            radioButton2.Visible = true;
            
     
        }

        private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
            string select = "select * from users where username='" + name + "'";
            q = new SqlDataAdapter(select, conn);
            ds = new DataSet();
            q.Fill(ds, "users");
            dataGridView1.DataSource = ds.Tables[0];
            dataGridView1.Columns[2].Visible = false;

        }


        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                SqlCommandBuilder SCB = new SqlCommandBuilder(q);
                q.Update(ds, "users");
            }
            catch (IndexOutOfRangeException)
            {

                MessageBox.Show("Update error!");
                return;
            }
            MessageBox.Show("Update successful!");
        }

        private void userInforToolStripMenuItem_Click(object sender, EventArgs e)
        {
            f1(false);
            panel1.Visible = false;
            panel2.Visible = false;
            panel3.Visible = false;
            dataGridView1.Enabled = true;
            dataGridView1.Visible = true;
            button3.Enabled = true;
            button4.Enabled = true;
            button3.Visible = true;
            button4.Visible = true;
            button1.Enabled = false;
            button1.Visible = false;
            button2.Enabled = false;
            button2.Visible = false;
            button5.Enabled = false;
            button5.Visible = false;
            textBox1.Enabled = false;
            textBox1.Visible = false;
            button6.Enabled = false;
            button6.Visible = false;
            textBox2.Enabled = false;
            textBox2.Visible = false;
            textBox3.Enabled = false;
            textBox3.Visible = false;
            label1.Enabled = false;
            label1.Visible = false;
    //        dataGridView7.Enabled = false;
      //      dataGridView7.Visible = false;
            dataGridView4.Enabled = false;
            dataGridView4.Visible = false;
            dataGridView3.Enabled = false;
            dataGridView3.Visible = false;
            checkBox1.Enabled = false;
            checkBox1.Visible = false;
            checkBox3.Enabled = false;
            checkBox3.Visible = false;
  //          dataGridView4.Enabled = false;
   //         dataGridView4.Visible = false;
            dataGridView2.Enabled = false;
            dataGridView2.Visible = false;
            radioButton1.Enabled = false;
            radioButton1.Visible = false;
            radioButton2.Enabled = false;
            radioButton2.Visible = false;
            

        }

        private void button5_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("Error:drop null!");
                return;
            }
            else
            {
                try
                {
                    if (cflag1)
                    {
                        SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
                        string drop = "alter   table  storage  drop   column  " + textBox1.Text + "";
                        q = new SqlDataAdapter(drop, conn);
                        ds = new DataSet();
                        q.Fill(ds, "storage");
                        comboBox1.Items.Remove(textBox1.Text);
                    }
                    else if (cflag3)
                    {
                        SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
                        string drop = "alter   table  sell  drop   column  " + textBox1.Text + "";
                        ds = new DataSet();
                        q = new SqlDataAdapter(drop, conn);
                        q.Fill(ds, "sell");
                        sc.Items.Remove(textBox1.Text);
                        
                    }
                    else
                    {
                        SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
                        string drop = "alter   table  users  drop   column  " + textBox1.Text + "";
                        ds = new DataSet();
                        q = new SqlDataAdapter(drop, conn);
                        q.Fill(ds, "users");
                    }
                }
                catch (IndexOutOfRangeException)
                {
                    MessageBox.Show("Drop error!");
                    return;
                }
                MessageBox.Show("Drop successful!");
                textBox1.Text = "";
            }
        }


        private void button6_Click(object sender, EventArgs e)
        {

             if (textBox2.Text == "")
            {
                MessageBox.Show("Error:add null!");
                return;
            }
            else if (textBox3.Text == "")
            {
                MessageBox.Show("Error:type null!");
                return;
            }
            else
            {