public ActionResult Microblog(string title, int?id)
{
if (!id.HasValue)
{
return(RedirectToAction("Index"));
}
Milist m = new Milist();
using (Model1 db = new Model1())
{
var blog = db.microblog.FirstOrDefault(b => b.bid == id);
if (blog == null)
{
blog = db.microblog.FirstOrDefault(b => b.title == title);
if (blog == null)
{
return(RedirectToAction("Index"));
}
}
if (Session[id.ToString()] != null)
{
string iid = Session[id.ToString()].ToString();
if (iid != id.ToString())
{
Microblog up = (from p in db.microblog
where p.bid == id
select p).FirstOrDefault();
if (up == null)
{
up = (from p in db.microblog
where p.title == title
select p).FirstOrDefault();
if (up == null)
{
return(RedirectToAction("Index"));
}
}
up.reads = up.reads + 1;
Tag tag = (from p in db.tag
where p.bid == up.bid
select p).FirstOrDefault();
if (tag == null)
{
tag = (from p in db.tag
where p.title == up.title
select p).FirstOrDefault();
if (tag == null)
{
return(RedirectToAction("Index"));
}
}
tag.reads = tag.reads + 1;
db.SaveChanges();
}
}
else
{
Session[id.ToString()] = id;
Microblog up = (from p in db.microblog
where p.bid == id
select p).FirstOrDefault();
if (up == null)
{
up = (from p in db.microblog
where p.title == title
select p).FirstOrDefault();
if (up == null)
{
return(RedirectToAction("Index"));
}
}
up.reads = up.reads + 1;
Tag tag = (from p in db.tag
where p.bid == up.bid
select p).FirstOrDefault();
if (tag == null)
{
tag = (from p in db.tag
where p.title == up.title
select p).FirstOrDefault();
if (tag == null)
{
return(RedirectToAction("Index"));
}
}
tag.reads = tag.reads + 1;
db.SaveChanges();
}
var list = db.tag.Where(y => y.tag == blog.tag).
OrderByDescending(x => x.id).Take(10).ToList();
m.blog = blog;
m.list = list;
List <Trend> trends = new List <Trend>();
var t = db.tag.Select(x => x).OrderByDescending(x => x.id).Take(10000).
ToList();
var taglist = t.Select(p => p.tag).Distinct();
int c;
foreach (var tt in taglist)
{
c = 0;
for (int j = 0; j < t.Count; j++)
{
if (tt == t[j].tag)
{
c++;
}
}
Trend newt = new Trend();
newt.tag = tt;
newt.count = c;
trends.Add(newt);
}
m.tagtrend = trends.OrderByDescending(v => v.count).ToList();
return(View(m));
}
}
public ActionResult Browse()
{
Browse b = new Browse();
Latlist catlist = new Latlist();
List <megacat> list = new List <megacat>();
list.Add(new megacat()
{
cat = "DIY", link = "~/Content/images/diy.png"
});
list.Add(new megacat()
{
cat = "Food", link = "~/Content/images/food.png"
});
list.Add(new megacat()
{
cat = "Sports", link = "~/Content/images/sp.png"
});
list.Add(new megacat()
{
cat = "Health & Fitness", link = "~/Content/images/hf.png"
});
list.Add(new megacat()
{
cat = "Business/Finance", link = "~/Content/images/bf.png"
});
list.Add(new megacat()
{
cat = "Industry", link = "~/Content/images/in.png"
});
list.Add(new megacat()
{
cat = "Political", link = "~/Content/images/p.png"
});
list.Add(new megacat()
{
cat = "Books", link = "~/Content/images/boo.png"
});
list.Add(new megacat()
{
cat = "Current Events", link = "~/Content/images/ce.png"
});
list.Add(new megacat()
{
cat = "Entertainment", link = "~/Content/images/et.png"
});
list.Add(new megacat()
{
cat = "Music", link = "~/Content/images/mu.png"
});
list.Add(new megacat()
{
cat = "Celebrities", link = "~/Content/images/cel.png"
});
list.Add(new megacat()
{
cat = "Problem & Solution", link = "~/Content/images/ps.png"
});
list.Add(new megacat()
{
cat = "Artist", link = "~/Content/images/ar.png"
});
list.Add(new megacat()
{
cat = "Infographics", link = "~/Content/images/i.png"
});
list.Add(new megacat()
{
cat = "Reviews", link = "~/Content/images/rev.png"
});
list.Add(new megacat()
{
cat = "Comparison", link = "~/Content/images/co.png"
});
list.Add(new megacat()
{
cat = "Personal", link = "~/Content/images/per.png"
});
list.Add(new megacat()
{
cat = "Games", link = "~/Content/images/gam.png"
});
list.Add(new megacat()
{
cat = "Movies", link = "~/Content/images/mov.png"
});
list.Add(new megacat()
{
cat = "Funny", link = "~/Content/images/fun.png"
});
list.Add(new megacat()
{
cat = "Inspiration", link = "~/Content/images/ins.png"
});
list.Add(new megacat()
{
cat = "Engineering", link = "~/Content/images/eng.png"
});
list.Add(new megacat()
{
cat = "Computer", link = "~/Content/images/com.png"
});
list.Add(new megacat()
{
cat = "Tutorials/Guide", link = "~/Content/images/tg.png"
});
list.Add(new megacat()
{
cat = "Information & Technology", link = "~/Content/images/it.png"
});
list.Add(new megacat()
{
cat = "Fashion", link = "~/Content/images/f.png"
});
list.Add(new megacat()
{
cat = "Lifestyle", link = "~/Content/images/ls.png"
});
catlist.catlist = list;
b.catlist = catlist;
Milist m = new Milist();
using (Model1 db = new Model1())
{
List <Trend> trends = new List <Trend>();
var t = db.tag.Select(x => x).OrderByDescending(x => x.id).Take(10000).
ToList();
var taglist = t.Select(p => p.tag).Distinct();
int c;
foreach (var tt in taglist)
{
c = 0;
for (int j = 0; j < t.Count; j++)
{
if (tt == t[j].tag)
{
c++;
}
}
Trend newt = new Trend();
newt.tag = tt;
newt.count = c;
trends.Add(newt);
}
m.tagtrend = trends.OrderByDescending(v => v.count).Take(50).ToList();
b.milist = m;
return(View(b));
}
}
