private void textBox11_TextChanged(object sender, EventArgs e)
 {
     if (RegExp.checkForEmail(textBox11.Text.ToString()))
     {
         label18.Text      = "Valid mail Id";
         label18.ForeColor = System.Drawing.Color.Green;
     }
     else
     {
         label18.Text      = "InValid mail Id";
         label18.ForeColor = System.Drawing.Color.Red;
     }
 }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string ab, cd, ef, gh, ij, kl, mn, op, qr, st, uv, xy, mk;

                ab = textBox8.Text;
                cd = dateTimePicker1.Text;
                ef = comboBox1.Text;
                gh = textBox4.Text;
                ij = textBox5.Text;
                kl = textBox6.Text;
                mn = textBox10.Text;
                op = textBox9.Text;
                qr = dateTimePicker2.Text;
                st = textBox11.Text;
                uv = textBox13.Text;
                xy = textBox2.Text;
                mk = textBox1.Text;



                if ((ab == "") || (cd == "") || (ef == "") || (gh == "") || (ij == "") || (kl == "") || (mn == "") || (op == "") || (ab == "") || (qr == "") || (st == "") || (uv == "") || (xy == "") || (mk == ""))
                {
                    MessageBox.Show("please add the full details", "Warning");
                    label18.Text = string.Empty;
                }

                else if (RegExp.checkForEmail(textBox11.Text.ToString()))
                {
                    label18.Text = string.Empty;

                    StringBuilder            hash        = new StringBuilder();
                    MD5CryptoServiceProvider md5provider = new MD5CryptoServiceProvider();
                    byte[] bytes = md5provider.ComputeHash(new UTF8Encoding().GetBytes(xy));

                    for (int i = 0; i < bytes.Length; i++)
                    {
                        hash.Append(bytes[i].ToString("x2"));
                    }

                    con.Open();
                    sql = "insert into details values('" + ab + "','" + cd + "','" + ef + "','" + gh + "','" + ij + "','" + kl + "','" + mn + "','" + op + "','" + qr + "','" + st + "','" + uv + "','" + hash + "','" + mk + "')";
                    com = new SqlCommand(sql, con);
                    com.ExecuteNonQuery();

                    con.Close();

                    /*   con.Open();
                     * sql = "insert into detailsAdmin values('" + uv + "','" + hash + "','" + mk + "')";
                     * com = new SqlCommand(sql, con);
                     * com.ExecuteNonQuery();
                     *
                     * con.Close();*/


                    MessageBox.Show("successfully added", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    label18.Text         = string.Empty;
                    textBox8.Text        = "";
                    dateTimePicker1.Text = "";
                    comboBox1.Text       = "";
                    textBox4.Text        = "";
                    textBox5.Text        = "";
                    textBox6.Text        = "";
                    textBox10.Text       = "";
                    textBox9.Text        = "";
                    dateTimePicker2.Text = "";
                    textBox11.Text       = "";
                    textBox13.Text       = "";
                    textBox2.Text        = "";
                    textBox1.Text        = "";
                }
                else
                {
                    label18.Text         = string.Empty;
                    textBox8.Text        = "";
                    dateTimePicker1.Text = "";
                    comboBox1.Text       = "";
                    textBox4.Text        = "";
                    textBox5.Text        = "";
                    textBox6.Text        = "";
                    textBox10.Text       = "";
                    textBox9.Text        = "";
                    dateTimePicker2.Text = "";
                    textBox11.Text       = "";
                    textBox13.Text       = "";
                    textBox2.Text        = "";
                    textBox1.Text        = "";
                }
            }


            catch (Exception ex1)
            {
                MessageBox.Show("sorry there are something went wrong, please try again..!!");
            }
        }
예제 #3
0
        private void button5_Click(object sender, EventArgs e)
        {
            try
            {
                string ab, cd, ef, gh, ij, kl, mn, mk;

                ab = textBox1.Text;
                cd = textBox2.Text;
                ef = textBox3.Text;
                mn = textBox6.Text;
                gh = textBox4.Text;
                ij = textBox5.Text;
                kl = richTextBox1.Text;

                mk = textBox1.Text;
                if ((ab == "") || (cd == "") || (ef == "") || (ef == "") || (gh == "") || (ij == "") || (kl == ""))
                {
                    MessageBox.Show("please add the full details", "Warning");
                    label9.Text = string.Empty;
                }

                else if (RegExp.checkForEmail(textBox4.Text.ToString()))
                {
                    label9.Text = string.Empty;

                    con.Open();
                    sql = "insert into details_M values('" + ab + "','" + cd + "','" + ef + "','" + ef + "','" + gh + "','" + ij + "','" + kl + "')";
                    com = new SqlCommand(sql, con);
                    com.ExecuteNonQuery();

                    con.Close();
                    MessageBox.Show("successfully added", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);



                    textBox4.Text     = "";
                    textBox5.Text     = "";
                    richTextBox1.Text = "";
                    textBox2.Text     = "";
                    textBox1.Text     = "";
                    textBox3.Text     = "";
                    textBox6.Text     = "";
                }

                else
                {
                    label9.Text       = string.Empty;
                    textBox4.Text     = "";
                    textBox5.Text     = "";
                    richTextBox1.Text = "";
                    textBox2.Text     = "";
                    textBox1.Text     = "";
                    textBox3.Text     = "";
                    textBox6.Text     = "";
                }
            }

            catch (Exception ex1)
            {
                MessageBox.Show("Sorry there are some went to wrong, please try again..!!");
            }
        }
        private void button5_Click(object sender, EventArgs e)
        {
            try
            {
                if ((textBox5.Text == "") || (textBox7.Text == "") || (richTextBox1.Text == "") || (textBox4.Text == "") || (textBox5.Text == "") || (textBox2.Text == "") || (textBox6.Text == ""))
                {
                    label10.Text = string.Empty;
                    MessageBox.Show("Sorry,please add the full details", "Warning");
                }
                else if (RegExp.checkForEmail(textBox4.Text.ToString()))
                {
                    label10.Text = string.Empty;
                    con.Open();
                    String ab, cd, ef, gh, ij, kl, mn;

                    ab = textBox7.Text;
                    cd = textBox6.Text;
                    ef = textBox3.Text;
                    gh = textBox2.Text;
                    ij = textBox4.Text;
                    kl = textBox5.Text;
                    mn = richTextBox1.Text;


                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = con;
                    //string sql = "UPDATE details SET name = '" + ab + "', dob = '" + cd + "', gender = '" + ef + "', address = '" + gh + "', contactNum = '" + ij + "', age = '" + mn + "' , salary = '" + op + "' , joiningDate = '" + qr + "' , email = '" + st + "' , username = '******' , password = '******' , role = '" + mk + "' where NICno = '" +hs + "'";
                    string sql = "UPDATE sDetails SET supplierID = '" + ab + "',supplierName = '" + cd + "', companyName = '" + ef + "' ,licenceNo = '" + gh + "' ,contactNum = '" + ij + "', address = '" + mn + "' where supplierID = '" + comboBox1.Text + "'";
                    cmd.CommandText = sql;
                    cmd.ExecuteNonQuery();
                    //com = new OleDbCommand(sql,con);
                    // com.ExecuteNonQuery();
                    con.Close();
                    MessageBox.Show("Succesfully Updated", "Update");


                    textBox7.Text     = "";
                    textBox4.Text     = "";
                    textBox5.Text     = "";
                    textBox6.Text     = "";
                    textBox3.Text     = "";
                    textBox2.Text     = "";
                    richTextBox1.Text = "";
                }

                else
                {
                    label10.Text      = string.Empty;
                    textBox7.Text     = "";
                    textBox4.Text     = "";
                    textBox5.Text     = "";
                    textBox6.Text     = "";
                    textBox3.Text     = "";
                    textBox2.Text     = "";
                    richTextBox1.Text = "";
                }
            }
            catch (Exception ex1)
            {
                MessageBox.Show("Sorry there are some went to wrong, Please try again..!!");
            }
        }