private IhalematikProBL.Entity.License CehckExistingLicense(string HashSerialNumber)
        {
            IhalematikProBL.Entity.License license = new IhalematikProBL.Entity.License();

            using (SqlConnection conn = new SqlConnection(@"server=.;user id=sa;password=Stonefish1;initial catalog=IhalematikDB"))

            // using (SqlConnection conn = new SqlConnection(@"server=.\MSSQLSErVER2014;user id=sa;password=Stonefish1;initial catalog=IhalematikLicense"))
            {
                conn.Open();

                SqlCommand cmd = new SqlCommand("License_Select", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@HashSerialNumber", HashSerialNumber));

                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        license.AuthorNameSurname = rdr["AuthorNameSurname"].ToString();
                        license.CompanyName       = rdr["CompanyName"].ToString();
                        license.HashSerialNumber  = rdr["HashSerialNumber"].ToString();
                        license.Address           = rdr["Address"].ToString();
                        license.TaxNumber         = rdr["TaxNumber"].ToString();
                        license.TaxOffice         = rdr["TaxOffice"].ToString();
                        license.Telephone         = rdr["Telephone"].ToString();
                        license.Id = (int)rdr["Id"];
                        //Console.WriteLine("Product: {0,-35} Total: {1,2}", rdr["ProductName"], rdr["Total"]);
                    }
                }
            }


            return(license);
        }
        private void btnTamam_Click(object sender, EventArgs e)
        {
            string passPhrase = "LifeTreeSoftware!.1";
            string keyPart1   = txtSerialNumberPart1.Text.Trim();
            string keyPart2   = txtSerialNumberPart2.Text.Trim();
            string keyPart3   = txtSerialNumberPart3.Text.Trim();
            string keyPart4   = txtSerialNumberPart4.Text.Trim();

            string serialNumber = string.Join("", new string[] { keyPart1, keyPart2, keyPart3, keyPart4 });

            Encryption.InitVector = "LifeTreeSoftware";
            string hashSerialNumber = Encryption.Encrypt(serialNumber, passPhrase);

            IhalematikProBL.Entity.License license = this.CehckExistingLicense(hashSerialNumber);//LicenseProvider.Instance.GetOne("HashSerialNumber", hashSerialNumber);
            if (license != null && license.Id != 0 && !string.IsNullOrEmpty(license.HashSerialNumber) && license.HashSerialNumber.Equals(hashSerialNumber))
            {
                MessageBox.Show(string.Format("Aktivasyon yapildi."));
                this._owner.IsActivateSerialNumber = true;
                this._owner.License = license;
                this.Hide();
                this._owner.LicenseInformationForm();
            }
            else
            {
                MessageBox.Show("Lisans Anahtarı hatalı.");
                this._owner.IsActivateSerialNumber = false;
            }
        }