public ActionResult Create(enCategory enCategory_) { if (enCategory_.file != null) { enCategory_.Image_Name = Helper.GetRandomAlphaNumericSMSToken() + "-" + Path.GetFileName(enCategory_.file.FileName); try { var path = Path.Combine(Server.MapPath(Helper.CategoryImagePath()) + enCategory_.Image_Name); bool exist = Directory.Exists(Server.MapPath(Helper.CategoryImagePath())); if (!exist) { Directory.CreateDirectory(Server.MapPath(Helper.CategoryImagePath())); } enCategory_.file.SaveAs(path); } catch (Exception ex) { return(RedirectToAction("error", "misc")); } } var objBLCategory = new blCategory(enCategory_); try { objBLCategory.Create(); } catch (Exception ex) { return(RedirectToAction("error", "misc")); } return(RedirectToAction("list")); }
private void ConstructObject(IDataReader dr_, enCategory enCategory_) { enCategory_.ID = Convert.ToInt32(dr_["ID"]); enCategory_.Name = dr_["Name"].ToString(); enCategory_.Image_Name = dr_["Image_Name"].ToString(); enCategory_.IsActive = Convert.ToBoolean(dr_["IsActive"]); enCategory_.InsertedOn = Convert.ToDateTime(dr_["InsertedOn"]); enCategory_.ModifiedOn = DBNull.Value == dr_["ModifiedOn"] ? (DateTime?)null : Convert.ToDateTime(dr_["ModifiedOn"]); }
public List <enCategory> ReadAll() { var listOfCategories = new List <enCategory>(); using (IDataReader idr = base.Read(_enCategory.ID)) { while (idr.Read()) { var objENCategory = new enCategory(); ConstructObject(idr, objENCategory); listOfCategories.Add(objENCategory); } } return(listOfCategories); }
public ActionResult Category() { var objENCategory = new enCategory(); var objBLCategory = new blCategory(objENCategory); List <enCategory> listOfCategories = new List <enCategory>(); try { listOfCategories = objBLCategory.ReadAll(); } catch (Exception ex) { Log.Error("HangOut.UI.DebateController.Category() Error while Read Category() Exception:-" + ex.ToString()); } return(View(listOfCategories)); }
public ActionResult Delete(int id) { var objENCategory = new enCategory() { ID = id }; var objBLCategory = new blCategory(objENCategory); try { objBLCategory.Delete(); } catch (Exception ex) { } return(RedirectToAction("list")); }
public ActionResult List() { var objENCategory = new enCategory(); var objBLCategory = new blCategory(objENCategory); List <enCategory> listOfCategories = new List <enCategory>(); try { listOfCategories = objBLCategory.ReadAll(); } catch (Exception ex) { return(RedirectToAction("error", "misc")); } ViewBag.listOfCategories = listOfCategories; return(View(listOfCategories)); }
public ActionResult Update(int id) { if (id == 0) { return(RedirectToAction("error", "misc")); } var objENCategory = new enCategory { ID = id }; var objBLCategory = new blCategory(objENCategory); try { objBLCategory.Read(); } catch (Exception ex) { RedirectToAction("error", "misc"); } return(View("create", objENCategory)); }
public blCategory(enCategory enCategory_) { this._enCategory = enCategory_; }
public dlCategory(enCategory enCategory_) : base("Category") { this._enCategory = enCategory_; }
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)); }