public int Like(int id, bool status)
{
using (var db = new DigitalArtefactEntities()) //this dbentities to access class from Model also we will get in wed.config
{
int Aid = id;
bool LikeStatus = status;
string userName = Session["UserName"].ToString();
var articles = db.Articles.FirstOrDefault(x => x.ArticleId == Aid);
Like like = db.Likes.FirstOrDefault(x => x.ArticleId == Aid && x.UserName == userName);
like = new Like();
like.UserName = Session["userName"].ToString();
like.IsLiked = LikeStatus;
like.ArticleId = id;
if (articles.likeCount == null) // if no one has done like or dislike and first time any one doing like and dislike then assigning 1 and 0
{
articles.likeCount = 1;
}
else
{
articles.likeCount = articles.likeCount + 1;
}
db.Likes.Add(like);
db.SaveChanges();
int count = Getlikecounts(articles.ArticleId);
return(count);
}
}
public int Getlikecounts(int?ArticleId) // to count like
{
using (var db = new DigitalArtefactEntities())
{
string userName = Session["UserName"].ToString();
var count = (from x in db.Likes where (x.ArticleId == ArticleId && x.UserName == userName) select x).Count();
ViewBag.likeCount = count;
return(count);
}
}
public ActionResult Login(User users)
{
if (ModelState.IsValid)
{
using (DigitalArtefactEntities db = new DigitalArtefactEntities())
{
var obj = db.Users.Where(a => a.UserName.Equals(users.UserName) && a.Password.Equals(users.Password)).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.UserId.ToString();
Session["UserName"] = obj.UserName.ToString();
return(RedirectToAction("UserRedirection"));
}
}
}
return(View(users));
}
