public ActionResult Comment()
{
dd_NJTrafficTicketsEntities dbentity = new dd_NJTrafficTicketsEntities();
var list = dbentity.tblComments.ToList();
return(View(list));
}
public ActionResult DeleteComment(int id)
{
dd_NJTrafficTicketsEntities dbentity = new dd_NJTrafficTicketsEntities();
var Result = dbentity.tblComments.FirstOrDefault(a => a.Comment_Id == id);
dbentity.tblComments.Remove(Result);
dbentity.SaveChanges();
return(Redirect("/Blog/Comment"));
}
public LoginModel login(LoginModel logins)
{
LoginModel model = new LoginModel();
dd_NJTrafficTicketsEntities dbentity = new dd_NJTrafficTicketsEntities();
var result = dbentity.tblUsers.FirstOrDefault(a => a.UserName == logins.UserName && a.Password == logins.Password);
if (result != null)
{
model.Name = result.Name;
model.Userid = result.tblUserId;
model.UserName = result.UserName;
model.tblUserRoleId = result.tblUserRoleId;
}
return(model);
}
public ActionResult Index1(int PageIndex = 0, int categoryID = 0, string SearchItem = "")
{
var BlogList = objblog.getBlog(categoryID, SearchItem);
dd_NJTrafficTicketsEntities dbentity = new dd_NJTrafficTicketsEntities();
int PageSize = 3;
int skip = PageIndex * PageSize;
double PageCount = Convert.ToDouble(Math.Ceiling((double)((double)BlogList.Count() / (double)PageSize)));
ViewBag.PageCount = PageCount;
ViewBag.CurrentPageIndex = PageIndex;
List <Blog> query = BlogList.Skip(skip).Take(PageSize).ToList();
ViewBag.totalRecord = query.Count();
return(PartialView("/Views/Blog/_index.cshtml", query));
}
public List <ResultModel> GetResult()
{
List <ResultModel> objResultModel = new List <ResultModel>();
dd_NJTrafficTicketsEntities dbentity = new dd_NJTrafficTicketsEntities();
var result = (from s in dbentity.tblUsers
join sa in dbentity.tblResults on s.tblUserId equals sa.tblUserId
select new
{
tblResultId = sa.tblResultId,
tblUserId = sa.tblUserId,
UserName = s.UserName,
Result_Date = sa.Result_Date,
Result_Heading = sa.Result_Heading,
Result_Text = sa.Result_Text,
Name = s.Name
}).ToList();
foreach (var item in result)
{
objResultModel.Add(new ResultModel
{
tblResultId = item.tblResultId,
tblUserId = item.tblUserId,
UserName = item.UserName,
Result_Date = item.Result_Date,
Date = Convert.ToDateTime(item.Result_Date).ToShortDateString(),
Result_Heading = item.Result_Heading,
Result_Text = item.Result_Text.Substring(0, Math.Min(item.Result_Text.Length, 400)),
Result_Text_st = item.Result_Text.Substring(0, Math.Min(item.Result_Text.Length, 140)),
Name = item.Name,
Result_Heading_st = item.Result_Heading.Substring(0, Math.Min(item.Result_Heading.Length, 40)),
});
}
objResultModel = objResultModel.OrderByDescending(l => l.Result_Date).ToList();
return(objResultModel);
}
