public Boolean addBanner(BannerBiz oBannerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strRetValue = string.Empty;
if (oBannerBiz.UserAction.ToUpper().Equals("ADD"))
{
strRetValue = objCoreDataLayer.ExecuteScalar("pr_InsBannerAd", new object[] { oBannerBiz.Category,oBannerBiz.AdvName,oBannerBiz.ImgPath,oBannerBiz.Width,oBannerBiz.Height,
oBannerBiz.StartDate,oBannerBiz.EndDate,oBannerBiz.RedirectURL,oBannerBiz.Active,oBannerBiz.AltText,oBannerBiz.Weightage}, true);
}
else
{
strRetValue = objCoreDataLayer.ExecuteScalar("pr_UpdBannerAd", new object[] { oBannerBiz.AdId,oBannerBiz.Category,oBannerBiz.AdvName,oBannerBiz.ImgPath,oBannerBiz.Width,oBannerBiz.Height,
oBannerBiz.StartDate,oBannerBiz.EndDate,oBannerBiz.RedirectURL,oBannerBiz.Active,oBannerBiz.AltText,oBannerBiz.Weightage}, true);
}
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
protected void Page_Load(object sender, EventArgs e)
{
Banner oBanner = new Banner();
BannerBiz oBannerBiz = new BannerBiz();
oBannerBiz = oBanner.getRandomAdBanner(Category);
//hypLnkBanner.NavigateUrl = "/adtracker.aspx?AdId=" +oBannerBiz.AdId;
hypLnkBanner.Attributes.Add("onClick", "return fnTrackAd("+oBannerBiz.AdId+")");
bannerImg.ImageUrl = "/admin/banners/" + oBannerBiz.ImgPath;
bannerImg.Height = Unit.Parse(oBannerBiz.Height.ToString());
bannerImg.Width = Unit.Parse(oBannerBiz.Width.ToString());
bannerImg.AlternateText = oBannerBiz.AltText;
// bannerImg.BorderStyle = BorderStyle.None;
}
private void TrackBannerAd(HttpContext context)
{
Banner oBanner = new Banner();
string adId = context.Request.QueryString["adId"];
string redirectUrl = "";
BannerBiz oBannerBiz = new BannerBiz();
oBannerBiz.AdId = Convert.ToInt32(adId);
oBannerBiz.IpAddress = context.Request.UserHostAddress;
redirectUrl = oBanner.insAdTrackingAndBannerURL(oBannerBiz);
HttpResponse oResponse = context.Response;
oResponse.Redirect(redirectUrl);
}
public string insAdTrackingAndBannerURL(BannerBiz oBannerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
string redirectUrl = string.Empty;
try
{
redirectUrl = objCoreDataLayer.ExecuteNonQueryAndScalar("pr_InsAdtracking", new object[] { oBannerBiz.AdId, oBannerBiz.IpAddress });
}
catch (Exception e)
{
throw e;
}
return redirectUrl;
}
