private void ConstructObject(IDataReader dr_, enComment enComment_)
{
enComment_.ID = Convert.ToInt32(dr_["ID"]);
enComment_.Message = dr_["Message"].ToString();
enComment_.Type = Convert.ToInt32(dr_["Type"]);
enComment_.Debate_ID = Convert.ToInt32(dr_["Debate_ID"]);
enComment_.User_ID = Convert.ToInt32(dr_["User_ID"]);
enComment_.InsertedOn = Convert.ToDateTime(dr_["InsertedOn"]);
enComment_.ModifiedOn = DBNull.Value == dr_["ModifiedOn"] ? (DateTime?)null : Convert.ToDateTime(dr_["ModifiedOn"]);
}
public JsonResult ajaxComment(int debID, int type, string msg)
{
var objENComment = new enComment();
objENComment.User_ID = CookieDetail.UserID;
objENComment.Debate_ID = debID;
objENComment.Type = type;
objENComment.Message = msg;
var objBLComment = new blComment(objENComment);
try
{
objBLComment.Create();
}
catch (Exception ex)
{
Log.Error("Hangout.UI.DebateController.Comment() Error while Create() Comment Exception:-" + ex.ToString());
return(Json(null, JsonRequestBehavior.AllowGet));
}
objENComment = new enComment()
{
User_ID = (int)Session["User_ID"]
};
objBLComment = new blComment(objENComment);
List <enComment> listOfComments = new List <enComment>();
try
{
listOfComments = objBLComment.ReadAll();
}
catch (Exception ex)
{
Log.Error("Hangout.UI.DebateController.Comment() Error while Read() Comment Exception:-" + ex.ToString());
return(Json(null, JsonRequestBehavior.AllowGet));
}
listOfComments = listOfComments.FindAll(x => x.Debate_ID == debID && x.Type == type);
return(Json(listOfComments, JsonRequestBehavior.AllowGet));
}
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 List <enComment> ReadAll(int?startRowIndex_ = null, int?endRowIndex_ = null)
{
var listOfComments = new List <enComment>();
using (IDataReader idr = base.Read(_enComment.ID, _enComment.Debate_ID, _enComment.User_ID, startRowIndex_, endRowIndex_))
{
while (idr.Read())
{
var objENComment = new enComment();
ConstructObject(idr, objENComment);
listOfComments.Add(objENComment);
_enComment.IsGetSuccess = true;
}
if (idr.NextResult())
{
idr.Read();
_enComment.RecordsCount = Convert.ToInt32(idr["RecordsCount"]);
}
}
return(listOfComments);
}
public blComment(enComment enComment_)
{
this._enComment = enComment_;
}
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));
}
public dlComment(enComment enComment_) : base("Comment")
{
this._enComment = enComment_;
}
