Ejemplo n.º 1
0
        public ActionResult IsActive(int id)
        {
            var objENDebate = new enDebate()
            {
                ID = id
            };
            var objBLDebate = new blDebate(objENDebate);

            try
            {
                objBLDebate.Read();
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }

            objENDebate.IsActive = false;
            objBLDebate          = new blDebate(objENDebate);
            try
            {
                objBLDebate.Update();
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }

            return(RedirectToAction("create"));
        }
Ejemplo n.º 2
0
        public ActionResult Update(int id, enDebate enDebate_)
        {
            var objENDebate = new enDebate()
            {
                ID = id
            };
            var objBLDebate = new blDebate(objENDebate);

            try
            {
                objBLDebate.Read();
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }

            enDebate_.InsertedOn = objENDebate.InsertedOn;
            objBLDebate          = new blDebate(enDebate_);
            try
            {
                objBLDebate.Update();
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }
            return(RedirectToAction("list"));
        }
Ejemplo n.º 3
0
 private void ConstructObject(IDataReader dr_, enDebate enDebate_)
 {
     enDebate_.ID          = Convert.ToInt32(dr_["ID"]);
     enDebate_.Topic       = dr_["Topic"].ToString();
     enDebate_.Description = dr_["Description"].ToString();
     enDebate_.Date        = Convert.ToDateTime(dr_["Date"]);
     enDebate_.Start       = TimeSpan.Parse(dr_["Start"].ToString());
     enDebate_.End         = TimeSpan.Parse(dr_["End"].ToString());
     enDebate_.User_ID     = DBNull.Value == dr_["User_ID"] ? (int?)null : Convert.ToInt32(dr_["User_ID"]);
     enDebate_.LikesCount  = DBNull.Value == dr_["LikesCount"] ? (int?)null : Convert.ToInt32(dr_["LikesCount"]);
     enDebate_.Category_ID = Convert.ToInt32(dr_["Category_ID"]);
     enDebate_.IsActive    = Convert.ToBoolean(dr_["IsActive"]);
     enDebate_.InsertedOn  = Convert.ToDateTime(dr_["InsertedOn"]);
     enDebate_.ModifiedOn  = DBNull.Value == dr_["ModifiedOn"] ? (DateTime?)null : Convert.ToDateTime(dr_["ModifiedOn"]);
 }
Ejemplo n.º 4
0
        public ActionResult Create(enDebate enDebate_)
        {
            var objBLDebate = new blDebate(enDebate_);

            enDebate_.IsActive = true;
            try
            {
                objBLDebate.Create();
            }
            catch (Exception ex)
            {
                return(RedirectToAction("error", "misc"));
            }
            return(RedirectToAction("list"));
        }
Ejemplo n.º 5
0
        public ActionResult List()
        {
            var             objENDebate   = new enDebate();
            var             objBLDebate   = new blDebate(objENDebate);
            List <enDebate> listOfDebates = new List <enDebate>();

            try
            {
                listOfDebates = objBLDebate.ReadAllAndAggregate(null, null, typeof(enCategory));
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }

            return(View(listOfDebates));
        }
Ejemplo n.º 6
0
        public ActionResult Update(int id)
        {
            var objENDebate = new enDebate()
            {
                ID = id
            };
            var objBLDebate = new blDebate(objENDebate);

            try
            {
                objBLDebate.Read();
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }
            return(View("create", objENDebate));
        }
Ejemplo n.º 7
0
        public ActionResult Delete(int id)
        {
            var objENDebate = new enDebate()
            {
                ID = id
            };
            var objBLDebate = new blDebate(objENDebate);

            try
            {
                objBLDebate.Delete();
            }
            catch
            {
                return(RedirectToAction("error", "misc"));
            }
            return(RedirectToAction("list"));
        }
Ejemplo n.º 8
0
        public List <enDebate> ReadAll(int?startRowIndex_ = null, int?endRowIndex_ = null)
        {
            var listOfDebates = new List <enDebate>();

            using (IDataReader idr = base.Read(_enDebate.ID, _enDebate.Category_ID, startRowIndex_, endRowIndex_))
            {
                while (idr.Read())
                {
                    var objENDebate = new enDebate();
                    ConstructObject(idr, objENDebate);
                    listOfDebates.Add(objENDebate);
                    _enDebate.IsGetSuccess = true;
                }

                if (idr.NextResult())
                {
                    idr.Read();
                    _enDebate.RecordsCount = Convert.ToInt32(idr["RecordsCount"]);
                }
            }
            return(listOfDebates);
        }
Ejemplo n.º 9
0
 public dlDebate(enDebate enDebate_) : base("Debate")
 {
     this._enDebate = enDebate_;
 }
        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));
        }
        public ActionResult DebateRoom(int debateID)
        {
            var objENDebate = new enDebate()
            {
                ID = debateID
            };
            var objBLDebate = new blDebate(objENDebate);

            try
            {
                objBLDebate.Read();
            }
            catch (Exception ex)
            {
                Log.Error("Hangout.UI.DebateController.DebateRoom() Error while Read() Debate  Exception:-" + ex.ToString());
            }
            ViewBag.DebateTopic       = objENDebate.Topic;
            ViewBag.DebateDescription = objENDebate.Description;

            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(enUser), typeof(enLikeCounter));
            }
            catch (Exception ex)
            {
                Log.Error("Hangout.UI.DebateController.DebateRoom() Error while Read() Comment  Exception:-" + ex.ToString());
            }

            if (listOfComments.Count > 0)
            {
                List <enComment> listOfDistinctID = listOfComments.DistinctBy(x => x.User_ID).ToList();
                ViewBag.DistinctID = listOfDistinctID;
            }
            var objCommentModel = new CommentModel();

            objCommentModel.listOfComments = listOfComments.OrderBy(x => x.ID).ToList();


            ViewBag.ForListOfComments     = listOfComments.FindAll(x => x.Type == (int)CommentType.FOR).OrderBy(x => x.InsertedOn);
            ViewBag.AgainstListOfComments = listOfComments.FindAll(x => x.Type == (int)CommentType.AGAINST).OrderBy(x => x.InsertedOn);

            objCommentModel.Comments_ = objENComment;
            ViewBag.UserID            = CookieDetail.UserID;

            var objENDebateAdvertisement = new enDebateAdvertisement()
            {
                GetByDate = 1
            };
            var objBLDebateAdvertisement = new blDebateAdvertisement(objENDebateAdvertisement);
            List <enDebateAdvertisement> listOfDebaetAdvertisements = new List <enDebateAdvertisement>();

            try
            {
                listOfDebaetAdvertisements = objBLDebateAdvertisement.ReadAllAndAggregate(typeof(enDebateAdvertisementImage));
            }
            catch (Exception ex)
            {
            }

            var count = listOfDebaetAdvertisements.FirstOrDefault().ListOfDebateAdvertisementImage_.Count;

            if (count > 0)
            {
                var half            = count / 2;
                var secondlistIndex = count - half;
                ViewBag.LeftDebateAdvertisementImage  = listOfDebaetAdvertisements.FirstOrDefault().ListOfDebateAdvertisementImage_.GetRange(0, half);
                ViewBag.RightDebateAdvertisementImage = listOfDebaetAdvertisements.FirstOrDefault().ListOfDebateAdvertisementImage_.GetRange(half, secondlistIndex);
            }



            return(View(objCommentModel));
        }
Ejemplo n.º 12
0
 public blDebate(enDebate enDebate_)
 {
     this._enDebate = enDebate_;
 }