public ActionResult ViewNews(int k)
{
@ViewBag.id = "1";
@ViewBag.name = "Ashmi Bhanushali";
VC_News_Category newscat = new VC_News_Category();
/* join query
*
* var q = (from p in obj.VC_News_Category join a in obj.VC_News on p.NewsCategory_id equals a.NewsCategory_id where a.NewsCategory_id==k select new {p.CategoryName,a.});
*
* */
var n = (from a in obj.VC_News_Category where a.NewsCategory_Id == k select a.CategoryName);
ViewBag.catname = n.SingleOrDefault();
var q = (from m in obj.VC_News_Link where m.NewsCategory_Id == k select m);
ViewBag.newslist = q;
//ViewBag.newscatname = from(m in obj.VC_News_Category select m where)
return View();
}
public ActionResult AddNews(VirtualCampus.Models.NewsCategoryModel model)
{
try
{
VC_News_Category n = new VC_News_Category();
n.Created_TS = DateTime.Now;
n.Updated_TS = DateTime.Now;
n.CategoryName = model.CategoryName.ToString();
obj.AddToVC_News_Category(n);
obj.SaveChanges();
}
catch
{
return View();
}
return RedirectToAction("ViewNewsCategory", "Manage");
}
