private void button4_Click_2(object sender, EventArgs e)
        {
            string spName = nameTxt.Text;
            //Sponsorship sp1 = mse.Sponsorships.Where(a => a.Sponsorship)
            Sponsorship sp = new Sponsorship();

            sp.SponsorName    = spName;
            sp.Amount         = Convert.ToDecimal(donateTxt.Text);
            sp.RegistrationId = 80;

            mse.Sponsorships.Add(sp);
            mse.SaveChanges();

            MessageBox.Show("Thankyou, payment was succesful");
        }
        private void button3_Click(object sender, EventArgs e)
        {
            User user = mse.Users.Where(a => a.Email == emailTxt.Text).FirstOrDefault();

            if (user == null)
            {
                if (!pwdTxt.Equals(pwdAgainTxt))
                {
                    User user1 = new User();
                    user1.LastName  = lNameTxt.Text;
                    user1.Password  = pwdAgainTxt.Text;
                    user1.RoleId    = "R";
                    user1.FirstName = fNameTxt.Text;
                    user1.Email     = emailTxt.Text;

                    Runner runner = new Runner();
                    runner.Email       = emailTxt.Text;
                    runner.Gender      = genderCmb.SelectedItem.ToString();
                    runner.DateOfBirth = dateTimePicker1.Value;
                    string cntry = ctryCmb.SelectedItem.ToString();

                    Country ctry = mse.Countries.Where(a => a.CountryName == cntry).FirstOrDefault();

                    runner.CountryCode = ctry.CountryCode;

                    mse.Users.Add(user1);
                    mse.Runners.Add(runner);
                    mse.SaveChanges();

                    this.Hide();
                    new ThnaxRegister().Show();
                }
                else
                {
                    MessageBox.Show("Plz enter same passwords in both the fields");
                }
            }
            else
            {
                MessageBox.Show("User already exists");
            }
        }