Beispiel #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            Form_customer fc = new Form_customer();

            fc.Show();
            this.Hide();
        }
        private void button_sign_in_Click(object sender, EventArgs e)
        {
            string username = textBox1.Text;
            string password = textBox2.Text;

            if (username == "admin" && password == "123")
            {
                Admin admin = new Admin();
                admin.Visible = true;
                this.Hide();
            }



            try
            {
                string     sql = "select * from Customer where C_Name ='" + textBox1.Text + "' ";
                SqlCommand cmd = new SqlCommand(sql, m_con);
                m_con.Open();
                SqlDataReader dreader = cmd.ExecuteReader();

                if (dreader.Read())
                {
                    if (dreader[5].ToString().Equals(textBox2.Text))
                    {
                        USER_ID = dreader[0].ToString();

                        if (string.IsNullOrWhiteSpace(textBox1.Text))
                        {
                            textBox1.Focus();
                            textBox1.BackColor = System.Drawing.Color.LightPink;
                        }
                        if (string.IsNullOrWhiteSpace(textBox2.Text))
                        {
                            textBox2.Focus();
                            textBox2.BackColor = System.Drawing.Color.LightPink;
                        }
                        else
                        {
                            Form_customer fc = new Form_customer();
                            fc.Show();
                            this.Hide();
                            textBox1.Clear();

                            textBox2.Clear();
                        }
                    }
                }

                dreader.Close();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Error");
            }
            finally
            {
                m_con.Close();
            }


            try
            {
                string     sql2 = "select * from Driver where D_Name ='" + textBox1.Text + "' ";
                SqlCommand cmd2 = new SqlCommand(sql2, m_con);
                m_con.Open();
                SqlDataReader dreader2 = cmd2.ExecuteReader();

                if (dreader2.Read())
                {
                    if (dreader2[3].ToString().Equals(textBox2.Text))
                    {
                        USER_ID = dreader2[0].ToString();
                        Form_employee fe = new Form_employee();
                        fe.Show();
                        this.Hide();
                        textBox1.Clear();
                        textBox2.Clear();
                    }
                    dreader2.Close();
                    if (string.IsNullOrWhiteSpace(textBox2.Text))
                    {
                        textBox2.Focus();
                        textBox2.BackColor = System.Drawing.Color.LightPink;
                    }
                    if (string.IsNullOrWhiteSpace(textBox2.Text))
                    {
                        textBox2.Focus();
                        textBox2.BackColor = System.Drawing.Color.LightPink;
                    }
                    else
                    {
                        Form_employee fe = new Form_employee();
                        fe.Show();
                        this.Hide();
                        textBox1.Clear();
                        textBox2.Clear();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error");
            }

            finally
            {
                m_con.Close();
            }
        }
Beispiel #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            //step 1 - create the sql connection
            SqlConnection con = new SqlConnection();

            //step 2 - rightclick on database - properties - connection string (address of the database the path)
            con.ConnectionString = "Data Source=DESKTOP-MHS4TMT\\SQLEXPRESS;Initial Catalog=Ayubo_drive;Integrated Security=True";

            //step 3 - Open the sql connection
            con.Open();

            //step 4 - Define the sql command
            SqlCommand cmd = new SqlCommand();

            //step 5 - set the sql connection object to the sql command
            cmd.Connection = con;

            //step 6 - Define the sql query type in the sql command
            cmd.CommandType = CommandType.Text;

            //step 7 - set the sql query to the sql command
            cmd.CommandText = "Insert Into customer(C_Name,C_Address,C_Email,C_Contact_No,C_Password)values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
            if (string.IsNullOrWhiteSpace(textBox1.Text))
            {
                textBox1.Focus();
                textBox1.BackColor = System.Drawing.Color.LightPink;
            }

            if (string.IsNullOrWhiteSpace(textBox2.Text))
            {
                textBox2.Focus();
                textBox2.BackColor = System.Drawing.Color.LightPink;
            }

            if (string.IsNullOrWhiteSpace(textBox3.Text))
            {
                textBox3.Focus();
                textBox3.BackColor = System.Drawing.Color.LightPink;
            }

            if (string.IsNullOrWhiteSpace(textBox4.Text))
            {
                textBox4.Focus();
                textBox4.BackColor = System.Drawing.Color.LightPink;
            }

            if (string.IsNullOrWhiteSpace(textBox5.Text))
            {
                textBox5.Focus();
                textBox5.BackColor = System.Drawing.Color.LightPink;
            }
            else
            {
                //step 10 - Display a successfull message

                MessageBox.Show("Successfully inserted values");

                textBox1.Clear();
                textBox2.Clear();
                textBox3.Clear();
                textBox4.Clear();
                textBox5.Clear();



                Form_customer fc = new Form_customer();
                fc.Show();

                this.Hide();
            }
            //step 8 - execute the sql command
            cmd.ExecuteReader();



            //step 9 - close the sql connection
            con.Close();
        }