?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 Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
            comboBox1.Visible = true;
            comboBox1.Enabled = true;
            uc.Visible = false;
            sc.Visible = false;
            cc.Visible = false;



        }

        public int flag=0;

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            flag = 1;
            comboBox1.Visible = false;
            comboBox1.Enabled = false;
            uc.Visible = true;
            uc.Enabled = true;
            sc.Visible = false;
            sc.Enabled = false;
            cc.Visible = false;
            cc.Enabled = false;
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            flag = 2;
            comboBox1.Visible = false;
            comboBox1.Enabled = false;
            uc.Visible = false;
            uc.Enabled = false;
            sc.Visible = true;
            sc.Enabled = true;
            cc.Visible = false;
            cc.Enabled = false;
        }

        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            flag = 3;
            comboBox1.Visible = false;
            comboBox1.Enabled = false;
            uc.Visible = false;
            uc.Enabled = false;
            sc.Visible = false;
            sc.Enabled = false;
            cc.Visible = true;
            cc.Enabled = true;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            sc.Text = ""; uc.Text = ""; cc.Text = ""; comboBox1.Text = ""; comboBox2.Text = ""; textBox1.Text = "";
            textBox2.Text = ""; textBox3.Text = "";
        }

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

        private void button1_Click(object sender, EventArgs e)
        {
            DataSet ds;
            DataSet ds1;
            float c;
            if ((textBox1.Text == "" && comboBox2.Text != "") || (textBox1.Text != "" && comboBox2.Text == "")|| ( flag==0) )
            {
                MessageBox.Show("Input error!");
                return; 
            }
            else
            {
                string colum,tab;
                if (flag == 1) { colum = uc.Text; tab = "users"; }
                else if (flag == 2) { colum = sc.Text; tab = "sell"; }
                else { colum = cc.Text; tab = "storage"; }

                try
                {
                    string select,select1;
                    SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
                    select1 = "select * from  " + tab + " ";

                    if (colum != "price" && colum != "scount" && colum != "count" && colum != "sumprice")
                    {
                        select = "select * from  "+tab+"  where " +colum+ " " + comboBox2.Text + "  '" +textBox1.Text + "'";
                    }
                    else if (colum == "price" || colum == "sumprice")
                    {
                        select = "select * from  " + tab + "  where  " + colum + "  " + comboBox2.Text + "  " + float.Parse(textBox1.Text) + "";
                     }
                     else select = "select * from  " + tab + "  where  " + colum + "  " + comboBox2.Text + "  " + int.Parse(textBox1.Text) + "";
                  
                    ds = new DataSet();
                    SqlDataAdapter q = new SqlDataAdapter(select, conn);
                    ds1 = new DataSet();
                    SqlDataAdapter q1 = new SqlDataAdapter(select1, conn);
                    q.Fill(ds, tab);
                    q1.Fill(ds1, tab);

                    
                }
                catch (IndexOutOfRangeException)
                {
                    MessageBox.Show("Account error!");
                    return;
                }
                MessageBox.Show("Account successful!");
                textBox2.Text = ds.Tables[0].Rows.Count.ToString();
                c = (float.Parse(ds.Tables[0].Rows.Count.ToString()) / float.Parse(ds1.Tables[0].Rows.Count.ToString())) * 100;
                textBox3.Text=c.ToString();
            } 

        }

        private void Form3_Load(object sender, EventArgs e)
        {
            int i;
            SqlConnection conn = new SqlConnection("server=;database=ll;uid=sa;pwd=;");
            string select1 = "select * from sell";
           DataSet ds1 = new DataSet();
           SqlDataAdapter q1 = new SqlDataAdapter(select1, conn);
            q1.Fill(ds1, "sell");
            for (i = ds1.Tables[0].Columns.Count; i > 0; i--)
                sc.Items.Insert(0, ds1.Tables[0].Columns[i - 1].ColumnName);

              string select2 = "select * from users";
           DataSet ds2 = new DataSet();
           SqlDataAdapter q2 = new SqlDataAdapter(select2, conn);
            q2.Fill(ds2, "users");
            for (i = ds2.Tables[0].Columns.Count; i > 0; i--)
                uc.Items.Insert(0, ds2.Tables[0].Columns[i - 1].ColumnName);

            string select3 = "select * from storage";
           DataSet ds3 = new DataSet();
           SqlDataAdapter q3 = new SqlDataAdapter(select3, conn);
           q3.Fill(ds3, "storage");
            for (i = ds3.Tables[0].Columns.Count; i > 0; i--)
                cc.Items.Insert(0, ds3.Tables[0].Columns[i - 1].ColumnName);
        }
     
    }
}