protected void Button3_Click(object sender, EventArgs e)
{
//Pending Exsiting Ad so update from the user
if (TextBox1.Text != null)
{
int AdID = Convert.ToInt32(TextBox1.Text);
using (var context2 = new AdDatabaseModel.AdDatabaseEntities())
{
int n = (Admanagment.Helpers.Utility.GetNumberofProfessionFromCurrent(AdID));
var adgeneral = (from ad in context2.AdGenerals
where ad.AdID == AdID
select ad).ToList();
var adaudience = (from ad in context2.AdAudiences
where ad.AdID == AdID
select ad).ToList();
context2.PendExistingAd(AdID, adgeneral[0].SiteID, adgeneral[0].SectionID,
adgeneral[0].PositionID, adgeneral[0].NavigateUrl,
adgeneral[0].FormatID, adgeneral[0].ImageUrl, adgeneral[0].AlternateText,
adgeneral[0].Keyword, adgeneral[0].Impressions, adgeneral[0].Width,
adgeneral[0].Height, adgeneral[0].StartDate, adgeneral[0].EndDate,
adgeneral[0].AdTypeID, adgeneral[0].UserID, adgeneral[0].AdName,
adaudience[0].LanguageID,
adaudience[0].GenderID, adaudience[0].AgeRangeID, adaudience[0].Zipcode,
adaudience[0].IndustryID, n, adaudience[0].Profession, adaudience[0].DateCreated,
adaudience[0].CountryID, adaudience[0].CountryName, adaudience[0].RegionID,
adaudience[0].RegionName, adaudience[0].CityID, adaudience[0].CityName,
adaudience[0].CountryCode, adaudience[0].FlagPath, adaudience[0].ProfessionID);
}
}
}
