public static string getCategoryName(int?categoryID)
{
using (dbDataContext db = new dbDataContext())
{
return(db.Categories.Where(n => n.Id == categoryID).Select(n => n.Name).SingleOrDefault());
}
}
private void loadCards(int?category, int?postID)
{
using (dbDataContext db = new dbDataContext())
{
var cardsInfo = db.Posts.Where(n => n.Category == category && n.Id != postID).OrderByDescending(n => n.Id).Take(6);
string infoString = "";
foreach (var c in cardsInfo)
{
infoString += "<div class='card'><span class='catSpan'>" + globalMethods.getCategoryName(c.Category) + "</span><img src='getImage.ashx?PostID=" + c.Id + "&Size=thumbnail' alt='" +
c.HeadLine + "'><div class='cardHeadline'>" + c.HeadLine + " <a href='News.aspx?ID=" + globalMethods.EncodeID(c.Id) + "' target='_blank' style='font-size:10px'>Read more..</a></div></div>";
}
RelatedNews.InnerHtml = infoString;
}
}
private void FindResult(string searchTerm)
{
var posts = new List <Post>();
using (dbDataContext db = new dbDataContext())
{
var splitedSearch = searchTerm.Split(' ');
foreach (var s in splitedSearch)
{
posts.AddRange(db.Posts.Where(n => n.HeadLine.Contains(s)).ToList());
}
loadResults(posts);
}
}
private void loadHoroscope()
{
using (dbDataContext db = new dbDataContext())
{
var horosocpe = db.Zodiacs.Select(n => new
{
n.Id,
zodiac = n.Zodiac_English + "(" + n.Zodiac_Odia + ")",
hs = db.Horoscopes.Where(m => m.Zodiac_ID == n.Id && m.Date == DateTime.Now.Date).Select(o => o.Horoscope_English).FirstOrDefault()
}).ToList();
string empty = "";
foreach (var h in horosocpe)
{
empty += "<li class='zodiac' onclick='window.open('Zodiac.aspx?h=" + h.zodiac + "')'><p>" + h.zodiac + "</p><span class='tooltipText'>" + h.hs + "</span></li>";
}
rashifal.InnerHtml = empty;
}
}
public void ProcessRequest(HttpContext context)
{
using (dbDataContext db = new dbDataContext())
{
var postID = Convert.ToInt32(context.Request.QueryString["PostID"]);
string Size = context.Request.QueryString["Size"].ToString().ToLower();
var post = db.Posts.Where(n => n.Id == postID).SingleOrDefault();
if (post != null)
{
var img = BinaryToImage(post.Image.ToArray());
var imgArray = GetBytesFromImage(generateImage(img, Size));
context.Response.ContentType = "image/jpg";
context.Response.OutputStream.Write(imgArray, 0, imgArray.Length);
context.Response.Flush();
context.Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
setDateTime();
using (dbDataContext db = new dbDataContext())
{
var categories = db.Categories.ToList();
var posts = db.Posts.Where(n => n.Submitted == true).ToList();
loadScroller(posts);
loadCategory(categories);
loadCards(posts);
loadRecentVideo(posts);
loadHoroscope();
}
}
}