예제 #1
0
        private void employer_signup(object sender, RoutedEventArgs e)
        {
            Employer_Sign_Up es = new Employer_Sign_Up();

            es.Show();
            this.Close();
        }
예제 #2
0
        private void btn_sign(object sender, RoutedEventArgs e)
        {
            string fullname, username, email, password, phn, add, bld, marry, gender, dob, nid;

            fullname = txt_fullname.Text;
            username = txtusername.Text;
            email    = txtemail.Text;
            password = pbpass.Password;
            phn      = txtphone.Text;
            add      = txtadd.Text;
            bld      = txtblood.Text;
            nid      = textnid.Text;

            if (chkms.IsChecked.Value == true)
            {
                marry = "Yes";
            }
            else
            {
                marry = "No";
            }
            if (rdomale.IsChecked.Value == true)
            {
                gender = "Male";
            }
            else
            {
                gender = "Female";
            }
            var    a   = (ComboBoxItem)cmd_reg.SelectedItem;
            string rel = (String)a.Content;

            dob = dpdob.SelectedDate.Value.ToShortDateString();

            try
            {
                string        connectionstring = @"Data Source=DESKTOP-1A5KDLM;Initial Catalog=fall16;Integrated Security=True";
                SqlConnection sqlcon           = new SqlConnection(connectionstring);

                SqlCommand cmd = new SqlCommand("insert into Employee(fullname,username,email,password,phn,address,bld,nid,ms,gender,dob,rel) values(@a,@b,@c,@d,@e,@f,@g,@h,@i,@j,@k,@l)", sqlcon);

                cmd.Parameters.Add("@a", SqlDbType.VarChar).Value = fullname;
                cmd.Parameters.Add("@b", SqlDbType.VarChar).Value = username;
                cmd.Parameters.Add("@c", SqlDbType.VarChar).Value = email;
                cmd.Parameters.Add("@d", SqlDbType.VarChar).Value = password;
                cmd.Parameters.Add("@e", SqlDbType.VarChar).Value = phn;
                cmd.Parameters.Add("@f", SqlDbType.VarChar).Value = add;
                cmd.Parameters.Add("@g", SqlDbType.VarChar).Value = bld;
                cmd.Parameters.Add("@h", SqlDbType.VarChar).Value = nid;
                cmd.Parameters.Add("@i", SqlDbType.VarChar).Value = marry;
                cmd.Parameters.Add("@j", SqlDbType.VarChar).Value = gender;
                cmd.Parameters.Add("@k", SqlDbType.Date).Value    = dob;
                cmd.Parameters.Add("@l", SqlDbType.VarChar).Value = rel;
                //cmd.ExecuteNonQuery();
                // MessageBox.Show("Account Created Successfully");

                sqlcon.Open();
                int rows = cmd.ExecuteNonQuery();
                if (rows > 0)
                {
                    MessageBox.Show("Account Created Successfully");
                }
                sqlcon.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed");
            }
            finally
            {
                Employer_Sign_Up hm = new Employer_Sign_Up();
                hm.Show();
                this.Close();
            }
        }