public List<AdRequest> GetAd(int ClientId, int LastId) { List<AdRequest> list = new List<AdRequest>(); AdRequest ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT n.AdvertisementId, n.Title, n.Body, n.Number,n.WebSiteUrl,n.Email,n.PictureId " + "FROM Advertisement n WHERE n.ClientId=" + ClientId + " AND n.AdvertisementId >" + LastId, con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new AdRequest(); ins.AdId = Convert.ToInt32(drI["AdvertisementId"]); ins.Title = drI["Title"].ToString(); ins.Body = drI["Body"].ToString(); ins.Number = drI["Number"].ToString(); ins.Url = drI["WebSiteUrl"].ToString(); ins.Email = drI["Email"].ToString(); ins.PicUrl = drI["PictureId"].ToString(); list.Add(ins); } } drI.Close(); con.Close(); foreach (AdRequest item in list) { if (Convert.ToInt32(item.PicUrl) != 0) { item.PicUrl = picRep.GetPicture(Convert.ToInt32(item.PicUrl)).PicUrl; /*if (item.PicUrl.Contains("\\Images\\")) { string path = item.PicUrl.Substring(item.PicUrl.IndexOf("\\Images\\")); path = path.Replace('\\', '/'); item.PicUrl = "http://www.netintercom.co.za" + path; }*/ } } return list; }
public AdRequest GetRandomSplashAdd(int ClientId) { List<AdRequest> list = new List<AdRequest>(); AdRequest ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT n.AdvertisementId, n.Title, n.Body, n.Number,n.WebSiteUrl,n.Email,n.PictureId " + "FROM Advertisement n WHERE n.ClientId=" + ClientId, con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new AdRequest(); ins.AdId = Convert.ToInt32(drI["AdvertisementId"]); ins.Title = drI["Title"].ToString(); ins.Body = drI["Body"].ToString(); ins.Number = drI["Number"].ToString(); ins.Url = drI["WebSiteUrl"].ToString(); ins.Email = drI["Email"].ToString(); ins.PicUrl = drI["PicUrl"].ToString(); list.Add(ins); } } drI.Close(); con.Close(); foreach (AdRequest item in list) { if (!item.PicUrl.Equals("0")) { int id = Convert.ToInt32(item.PicUrl); item.PicUrl = picRep.GetPicture(id).PicUrl; } } if (list.Count != 0) { Random rnd = new Random(); int random = rnd.Next(0, list.Count); return list[random]; } else return new AdRequest(); }
public JsonResult GetSplashAd(int ClientId) { //...Query DB.... AdRequest list = new AdRequest(); list = appRep.GetRandomSplashAdd(ClientId); var j = this.Json(list); return Json(j, JsonRequestBehavior.AllowGet); }