public ActionResult Index() { string userId = User.Identity.GetUserId(); string deptId = _context.AspNetUsers.FirstOrDefault(x => x.Id == userId).DepartmentId; BriefDept dept = disbService.GetBriefDept(deptId); return(View(dept)); }
//Save Changes for Department Rep public void SaveNewDeptRep(BriefDept briefDept) { string dept = briefDept.deptCode; var q = context.Department.Where(x => x.DepartmentCode == dept).First(); Department d = q; d.RepId = briefDept.repId; context.SaveChanges(); }
public BriefDept GetBriefDept(string deptId) { BriefDept deptList = (from x in context.Department where x.DepartmentId == deptId select new BriefDept { DepartmentId = x.DepartmentId, DepartmentName = x.DepartmentName }).FirstOrDefault(); return(deptList); }
//Generate random number for collection point public BriefDept generateCollectionPassword(string dept) { int _min = 1000; int _max = 9999; Random _rdm = new Random(); int num = _rdm.Next(_min, _max); string randomNumber = num.ToString(); var q = context.Department.Where(x => x.DepartmentCode == dept).First(); int repId = q.RepId; Department d = new Department(); d = q; d.CollectionPassword = num.ToString(); context.SaveChanges(); BriefDept briefDept = new BriefDept(); briefDept.deptCode = dept; briefDept.collectionPassword = randomNumber; briefDept.repId = repId; return(briefDept); }
public void SaveBriefEmp(BriefDept briefDept) { b.SaveNewDeptRep(briefDept); }