public ActionResult getParticepent(int debateID) { var objENComment = new enComment() { Debate_ID = debateID }; var objBLComment = new blComment(objENComment); List <enComment> listOfComments = new List <enComment>(); try { listOfComments = objBLComment.ReadAllAndAggregate(null, null, typeof(enDebate), typeof(enUser)); } catch { return(RedirectToAction("error", "misc")); } listOfComments = listOfComments.DistinctBy(x => x.User_ID).ToList(); foreach (var item in listOfComments) { var objENLikeCounter = new enLikeCounter() { User_ID = item.User_ID, Debate_ID = item.Debate_ID }; var objBLLikeCounter = new blLikeCounter(objENLikeCounter); List <enLikeCounter> listOfLikesCounters = new List <enLikeCounter>(); try { listOfLikesCounters = objBLLikeCounter.ReadAll(); item.LikesCount = listOfLikesCounters.Count(); } catch { return(RedirectToAction("error", "misc")); } } return(Json(listOfComments, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(int id) { #region Category var objENCategory = new enCategory() { ID = id }; var objBLCategory = new blCategory(objENCategory); try { objBLCategory.Read(); } catch (Exception ex) { throw; } ViewBag.Title = objENCategory.Name; #endregion var objENDebate = new enDebate() { Category_ID = id }; var objBLDebate = new blDebate(objENDebate); List <enDebate> listOfDebates = new List <enDebate>(); try { listOfDebates = objBLDebate.ReadAllAndAggregate(null, null, typeof(enUser)); } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Read() Debate Exception:- " + ex.ToString()); } foreach (var item in listOfDebates) { if (item.Date.Date < DateTime.Now.Date) { if (item.IsActive != false) { var objENLikeCounter = new enLikeCounter() { Debate_ID = item.ID }; var objBLLikeCounter = new blLikeCounter(objENLikeCounter); List <enLikeCounter> listOfLikesCounter = new List <enLikeCounter>(); try { listOfLikesCounter = objBLLikeCounter.ReadAll(); if (listOfLikesCounter.Count > 0) { var maxRepeated = listOfLikesCounter.GroupBy(s => s.User_ID).OrderByDescending(s => s.Count()).First().Key; int count = listOfLikesCounter.FindAll(x => x.User_ID == Convert.ToInt32(maxRepeated)).Count; if (Convert.ToInt32(count) > 0) { var objENReward = new enReward(); objENReward.Point = 50; objENReward.Type = (int)RewardType.WINNER; objENReward.User_ID = Convert.ToInt32(maxRepeated); var objBLReward = new blReward(objENReward); try { objBLReward.Create(); } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Create() Reward Exception:-" + ex.ToString()); return(RedirectToAction("error", "misc")); } item.IsActive = false; item.LikesCount = count; item.User_ID = maxRepeated; objBLDebate = new blDebate(item); try { objBLDebate.Update(); } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Update() Debate Exception:-" + ex.ToString()); return(RedirectToAction("error", "misc")); } } } } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Read() LikeCounter Exception:-" + ex.ToString()); return(RedirectToAction("error", "misc")); } } } else if (item.Date.Date == DateTime.Now.Date) { if (item.Start <= DateTime.Now.TimeOfDay && item.End >= DateTime.Now.TimeOfDay) { item.IsActive = true; } else if (item.Start <= DateTime.Now.TimeOfDay && item.End <= DateTime.Now.TimeOfDay) { if (item.IsActive != false) { item.IsActive = false; var objENLikeCounter = new enLikeCounter() { Debate_ID = item.ID }; var objBLLikeCounter = new blLikeCounter(objENLikeCounter); List <enLikeCounter> listOfLikesCounter = new List <enLikeCounter>(); try { listOfLikesCounter = objBLLikeCounter.ReadAll(); if (listOfLikesCounter.Count > 0) { var maxRepeated = listOfLikesCounter.GroupBy(s => s.User_ID).OrderByDescending(s => s.Count()).First().Key; int count = listOfLikesCounter.FindAll(x => x.User_ID == Convert.ToInt32(maxRepeated)).Count; if (Convert.ToInt32(count) > 0) { var objENReward = new enReward(); objENReward.Point = 50; objENReward.Type = (int)RewardType.WINNER; objENReward.User_ID = Convert.ToInt32(maxRepeated); var objBLReward = new blReward(objENReward); try { objBLReward.Create(); } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Create() Reward Exception:-" + ex.ToString()); return(RedirectToAction("error", "misc")); } item.LikesCount = count; item.User_ID = maxRepeated; objBLDebate = new blDebate(item); try { objBLDebate.Update(); } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Update() Debate Exception:-" + ex.ToString()); return(RedirectToAction("error", "misc")); } } } else { objBLDebate = new blDebate(item); try { objBLDebate.Update(); } catch (Exception ex) { Log.Error("Hangout.UI.DebateControl.Index() error while Update() Debate Exception:-" + ex.ToString()); } } } catch (Exception ex) { Log.Error("Hang-Out.UI.DebateController.Index() Error while Read() LikeCounter Exception:-" + ex.ToString()); return(RedirectToAction("error", "misc")); } } } else { item.IsActive = false; } } else { item.IsActive = false; } } return(View(listOfDebates)); }