protected void Button2_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text != null)
        {
            int AdID = Convert.ToInt32(TextBox1.Text);

            using (var context2 = new AdDatabaseModel.AdDatabaseEntities())
            {
                var r = (from c in context2.TempAds
                         where c.ID == AdID
                         select c).FirstOrDefault();
                //Success notification
                //Think about successful payment and denied payment table
                //If successful than call approve method

                context2.ApproveNewAd(AdID, r.SiteID, r.SectionID, r.PositionID, r.NavigateUrl, r.FormatID, r.ImageUrl,
                                      r.AlternateText, r.Keyword, r.Impressions, r.Width, r.Height, r.StartDate,
                                      r.EndDate, true, r.UserID,
                                      r.LanguageID, r.GenderID, r.AgeRangeID, r.CountryID, r.CountryName, r.RegionID,
                                      r.RegionName, r.CityID,
                                      r.CityName, r.Zipcode, r.IndustryID, r.Profession, r.DateCreated, AdID, r.AdName,
                                      r.AdTypeID, r.CountryCode,
                                      r.FlagPath, r.ProfessionID);
            }
        }
    }