예제 #1
0
 //LOGIN FORM
 private void button1_Click(object sender, EventArgs e)
 {
     ////try
     {
         QUERY obj = new QUERY();
         obj.LIST[0] = textBox1.Text;
         obj.LIST[1] = textBox2.Text;
         if (textBox1.Text == "" || textBox2.Text == "")
         {
             MessageBox.Show("Please fill In the empty boxes");
         }
         else
         {
             obj.LOGIN();
             if (obj.count == 1)
             {
                 MessageBox.Show("USRENAME and PASSWORD is valid");
                 Form1 IN = new Form1();
                 this.Hide();
                 IN.ShowDialog();
             }
             else
             {
                 MessageBox.Show("Wrong Password");
             }
         }
     }
 }
예제 #2
0
        //SAVE BUTTON
        private void button3_Click(object sender, EventArgs e)
        {
            QUERY OBJ = new QUERY();

            OBJ.LIST[0] = textBox1.Text;
            OBJ.LIST[1] = textBox2.Text;
            OBJ.LIST[2] = textBox3.Text;
            OBJ.LIST[3] = textBox4.Text;
            OBJ.LIST[5] = textBox5.Text;
            if (textBox3.Text == "" || textBox4.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox5.Text == "")
            {
                MessageBox.Show("PLEASE FILL THE TEXTBOXES");
            }
            else
            {
                OBJ.SAVELog();
                if (OBJ.count == 1)
                {
                    MessageBox.Show("YOUR USERNAME IS ALREADY EXIST!!");
                }
                else
                {
                    MessageBox.Show("ACCOUNT CREATED");
                    OBJ.insert();
                    dataGridView1.DataSource = OBJ.table;
                    OBJ.display();
                    textBox1.Text = "";
                    textBox2.Text = "";
                    textBox4.Text = "";
                    textBox5.Text = "";
                    label1.Text   = "";
                }
            }
        }
예제 #3
0
        private void Form3_Load(object sender, EventArgs e)
        {
            QUERY obj = new QUERY();

            dataGridView1.DataSource = obj.table;
            obj.display();
        }
예제 #4
0
        //UPDATE BUTTON
        private void button4_Click(object sender, EventArgs e)
        {
            QUERY obj = new QUERY();

            obj.LIST[0] = textBox1.Text;
            obj.LIST[1] = textBox2.Text;
            obj.LIST[2] = label1.Text;
            obj.LIST[3] = textBox3.Text;
            obj.LIST[4] = textBox4.Text;
            obj.LIST[5] = textBox5.Text;
            if (textBox3.Text == "" || textBox4.Text == "")
            {
                MessageBox.Show("ENTER YOUR CURRENT USER AND PASSWORD");
            }
            else
            {
                obj.AUTHENTICATE();
                if (obj.count == 1)
                {
                    MessageBox.Show("UsERname and password is valid, UPDATED");
                    dataGridView1.DataSource = obj.table;
                    obj.UPDATE();
                    obj.display();
                    textBox1.Text     = "";
                    textBox2.Text     = "";
                    textBox4.Text     = "";
                    label1.Text       = "";
                    textBox5.Text     = "";
                    btnsave.Enabled   = true;
                    btncleare.Enabled = false;
                    btnup.Enabled     = false;
                    btndel.Enabled    = false;
                }
                else
                {
                    MessageBox.Show("YOUR USER AND PASSWORD IS NOT VALID FOR YOUR ID");
                }
            }
        }