// GET: CLient public ActionResult Index() { if (Session["empName"] != null) { string name = Session["empName"].ToString(); var _empID = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault(); var ss = _db.Cases.Where(d => d.employeeName == _empID.id.ToString()).FirstOrDefault(); var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == _empID.id).FirstOrDefault(); ViewBag.accessAll = _allowAll.AccessAll; var model = new ClientWithCases(); model.empX = _db.Employee.ToList(); if (_allowAll.AccessAll == true) { model.ClientXs = _db.Client.ToList(); return(View(model)); } else if (_allowAll.Clients == true) { model.ClientXs = _db.Client.Where(p => p.employeeName == _empID.id).ToList(); return(View(model)); } } return(RedirectToAction("HavntAccess", "Employees")); }
// GET: test/Details/5 public ActionResult Details(int?id, Courts _court) { if (Session["empName"] != null) { string name = Session["empName"].ToString(); var ss = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault(); var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == ss.id).FirstOrDefault(); int empid = ss.id; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Client client = _db.Client.Find(id); var model = new ClientWithCases(); var cases = _db.Cases.Where(s => s.id == id).ToList(); //var cse = cases.FirstOrDefault(); model.CaseX = _db.Cases.Where(s => s.clientID == id).ToList(); var _client = _db.Client.Where(s => s.ID == id); model.ClientX = _client.FirstOrDefault(); model.CourtX = _db.Court.ToList(); // model.ClientX = client.; if (client == null) { return(HttpNotFound()); } else if (client.employeeName == empid || _allowAll.AccessAll == true) { return(View(model)); } } return(RedirectToAction("HavntAccess", "Employees")); }