//Modified for testing public ActionResult BlockUser(User cur, string blockName, DateTime date, int InstId, int DepId, int YearId) { //User cur = new User(); //cur = (User)TempData["CurrentManager"]; //string UserName = Request.Form["username"]; string UserName = blockName; //int InstId; //int DepId; //int YearId; //try //{ // InstId = Int32.Parse(Request.Form["Institution"]); //} //catch //{ // InstId = -1; //} //try //{ // DepId = Int32.Parse(Request.Form["Department"]); //} //catch //{ // DepId = -1; //} //try //{ // YearId = Int32.Parse(Request.Form["Year"]); //} //catch //{ // YearId = -1; //} ManageConnectionDal mcdal = new ManageConnectionDal(); List <ManageConnection> manageConnections = (from x in mcdal.ManageConnections where x.managerId == cur.id select x).ToList <ManageConnection>(); foreach (ManageConnection mc in manageConnections) { if (InstId != -1) { if (mc.institution == InstId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } } if (DepId != -1) { if (mc.department == DepId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } else { DepartmentDal dp = new DepartmentDal(); List <Department> departments = (from x in dp.Departments where x.DepartmentId == DepId select x).ToList <Department>(); if (mc.institution == departments[0].InstitutionId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } } } if (YearId != -1) { if (mc.sYear == YearId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } else { SyearDal yearid = new SyearDal(); List <Syear> syears = (from x in yearid.Syears where x.SyearId == YearId select x).ToList <Syear>(); DepartmentDal dp = new DepartmentDal(); List <Department> departments = (from x in dp.Departments where x.DepartmentId == syears[0].DepartmentId select x).ToList <Department>(); if (mc.institution == departments[0].InstitutionId || mc.department == syears[0].DepartmentId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } } } } return(View("Failed", cur)); }
public ActionResult ViewThreadsActivity() { User cur = getUser(); //cur = (User)TempData["CurrentManager"]; int countComment = 0; ManageConnectionDal mcdal = new ManageConnectionDal(); List <ManageConnection> manageConnections = (from x in mcdal.ManageConnections where x.managerId == cur.id select x).ToList <ManageConnection>(); foreach (ManageConnection mc in manageConnections) { if (mc.institution != -1) { DepartmentDal dp = new DepartmentDal(); List <Department> departments = (from x in dp.Departments where x.InstitutionId == mc.institution select x).ToList <Department>(); foreach (Department dep in departments) { SyearDal yearid = new SyearDal(); List <Syear> syears = (from x in yearid.Syears where x.DepartmentId == dep.DepartmentId select x).ToList <Syear>(); foreach (Syear yearsC in syears) { ThreadDal threadid = new ThreadDal(); List <Thread> threads = (from x in threadid.Threads where x.SyearId == yearsC.SyearId select x).ToList <Thread>(); foreach (Thread th in threads) { CommentDal commentid = new CommentDal(); List <Comment> comments = (from x in commentid.Comments where x.threadId == th.ThreadId select x).ToList <Comment>(); countComment = countComment + comments.Count(); } } } } if (mc.department != -1) { SyearDal yearid = new SyearDal(); List <Syear> syears = (from x in yearid.Syears where x.DepartmentId == mc.department select x).ToList <Syear>(); foreach (Syear yearsC in syears) { ThreadDal threadid = new ThreadDal(); List <Thread> threads = (from x in threadid.Threads where x.SyearId == yearsC.SyearId select x).ToList <Thread>(); foreach (Thread th in threads) { CommentDal commentid = new CommentDal(); List <Comment> comments = (from x in commentid.Comments where x.threadId == th.ThreadId select x).ToList <Comment>(); countComment = countComment + comments.Count(); } } } if (mc.sYear != -1) { ThreadDal threadid = new ThreadDal(); List <Thread> threads = (from x in threadid.Threads where x.SyearId == mc.sYear select x).ToList <Thread>(); foreach (Thread th in threads) { CommentDal commentid = new CommentDal(); List <Comment> comments = (from x in commentid.Comments where x.threadId == th.ThreadId select x).ToList <Comment>(); countComment = countComment + comments.Count(); } } } using (commentCounterDal dal = new commentCounterDal()) { commentCounter newCounter = new commentCounter() { managerId = cur.id, messageCounter = countComment, date = DateTime.Today }; dal.commentCounters.Add(newCounter); dal.SaveChanges(); } commentCounterDal cmpCount = new commentCounterDal(); List <commentCounter> commentCounters = (from x in cmpCount.commentCounters where x.managerId == cur.id select x).ToList <commentCounter>(); ViewBag.counters = commentCounters; return(View("ThreadsActivity", cur)); }
public ActionResult BlockUser() { User cur = new User(); cur = (User)TempData["CurrentManager"]; string UserName = Request.Form["username"]; int InstId; int DepId; int YearId; DateTime date = DateTime.Parse(Request.Form["date"]); try { InstId = Int32.Parse(Request.Form["Institution"]); } catch { InstId = -1; } try { DepId = Int32.Parse(Request.Form["Department"]); } catch { DepId = -1; } try { YearId = Int32.Parse(Request.Form["Year"]); } catch { YearId = -1; } List <ManageConnection> manageConnections = new List <ManageConnection>(); try { ManageConnectionDal mcdal = new ManageConnectionDal(); manageConnections = (from x in mcdal.ManageConnections where x.managerId == cur.id select x).ToList <ManageConnection>(); } catch { } foreach (ManageConnection mc in manageConnections) { if (InstId != -1) { if (mc.institution == InstId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } } if (DepId != -1) { if (mc.department == DepId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } else { List <Department> departments = new List <Department>(); try { DepartmentDal dp = new DepartmentDal(); departments = (from x in dp.Departments where x.DepartmentId == DepId select x).ToList <Department>(); } catch { } if (mc.institution == departments[0].InstitutionId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } } } if (YearId != -1) { if (mc.sYear == YearId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } else { List <Syear> syears = new List <Syear>(); List <Department> departments = new List <Department>(); SyearDal yearid = new SyearDal(); DepartmentDal dp = new DepartmentDal(); try { syears = (from x in yearid.Syears where x.SyearId == YearId select x).ToList <Syear>(); departments = (from x in dp.Departments where x.DepartmentId == syears[0].DepartmentId select x).ToList <Department>(); } catch { } if (mc.institution == departments[0].InstitutionId || mc.department == syears[0].DepartmentId) { BlockFromDB(UserName, date, InstId, DepId, YearId); return(View("Block", cur)); } } } } return(View("Failed", cur)); }