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);
}
