public async Task <ActionResult <RoleTb> > PostRoleTb(RoleTb roleTb) { var nameCheck = _context.RoleTb .Where(b => b.RoleId == roleTb.RoleId) .FirstOrDefault(); if (nameCheck == null) { // save the item here //_context.RoleTb.Add(roleTb); //await _context.SaveChangesAsync(); // bool x = await _roleManager.RoleExistsAsync("Employer"); //if (!x) //{ var role = new RoleTb(); role.Name = roleTb.Name; role.RoleId = roleTb.RoleId; await _roleManager.CreateAsync(role); // } } else { return(Conflict("RoleId Already Exists")); } return(CreatedAtAction("GetRoleTb", new { id = roleTb.RoleId }, roleTb)); }
public ActionResult DeleteConfirmed(int id) { RoleTb roleTb = db.RoleTbs.Find(id); db.RoleTbs.Remove(roleTb); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Role")] RoleTb roleTb) { if (ModelState.IsValid) { db.Entry(roleTb).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(roleTb)); }
public ActionResult Create([Bind(Include = "Id,Role")] RoleTb roleTb) { if (ModelState.IsValid) { db.RoleTbs.Add(roleTb); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(roleTb)); }
public ResponseData <object> ChangeUserPower(int userId, [FromBody] UserPostData userPostData) { ResponseData <object> responseData; if (SessionHelper.IsExist(userPostData.Guid)) { string adminAccount = HttpContext.Current.Session[userPostData.Guid].ToString(); RoleTb admin = db.RoleTb.Where(u => u.isDel == false && u.account == adminAccount).FirstOrDefault(); //判断是否为管理员 if (admin != null && admin.powerNum == 99) { RoleTb user = db.RoleTb.Where(u => u.isDel == false && u.roleId == userId).FirstOrDefault(); // 判断要操作的用户是否存在 if (user != null) { user.powerNum = userPostData.PowerNum; try { db.Entry(user).State = System.Data.Entity.EntityState.Modified; if (db.SaveChanges() > 0) { responseData = ResponseHelper <object> .SendSuccessResponse(); } else { responseData = ResponseHelper <object> .SendErrorResponse("修改失败"); } } catch (Exception ex) { responseData = ResponseHelper <object> .SendErrorResponse(ex.Message); } } else { responseData = ResponseHelper <object> .SendErrorResponse("未找到该用户"); } } else { responseData = ResponseHelper <object> .SendErrorResponse("用户登陆失效或权限不足", Models.StatusCode.OPERATION_ERROR); } } else { responseData = ResponseHelper <object> .SendErrorResponse("未登录", Models.StatusCode.OPERATION_ERROR); } return(responseData); }
// GET: RoleTbs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RoleTb roleTb = db.RoleTbs.Find(id); if (roleTb == null) { return(HttpNotFound()); } return(View(roleTb)); }
public async Task <IActionResult> PutRoleTb(string id, RoleTb roleTb) { if (!_context.RoleTb.Any(e => e.Id == roleTb.Id)) { //_context.RoleTb.Add(roleTb); await _context.SaveChangesAsync(); } else { var pos = await _context.RoleTb.FirstOrDefaultAsync(x => x.Id == roleTb.Id); pos.Id = roleTb.Id; pos.Name = roleTb.Name; await _context.SaveChangesAsync(); } return(Ok(roleTb)); }
public ResponseData <object> UpdateUserMessage(int userId, [FromBody] UserPostData userPostData) { ResponseData <object> responseData; if (SessionHelper.IsExist(userPostData.Guid)) { RoleTb user = db.RoleTb.Where(u => u.isDel == false && u.roleId == userId).FirstOrDefault(); if (user != null) { user.nickName = userPostData.NickName ?? user.nickName; user.pwd = userPostData.Pwd ?? user.pwd; try { db.Entry(user).State = System.Data.Entity.EntityState.Modified; if (db.SaveChanges() > 0) { responseData = ResponseHelper <object> .SendSuccessResponse(); } else { responseData = ResponseHelper <object> .SendErrorResponse("修改失败"); } } catch (Exception ex) { responseData = ResponseHelper <object> .SendErrorResponse(ex.Message); } } else { responseData = ResponseHelper <object> .SendErrorResponse("未找到该用户"); } } else { responseData = ResponseHelper <object> .SendErrorResponse("未登录", Models.StatusCode.OPERATION_ERROR); } return(responseData); }
public ResponseData <object> UserLogin([FromBody] RoleTb entity) { ResponseData <object> responseData; RoleTb user = new RoleTb { account = entity.account, pwd = entity.pwd }; try { var loginUser = db.RoleTb .Where(u => u.isDel == false && u.account == user.account && u.pwd == user.pwd) .FirstOrDefault(); if (loginUser != null) { string guid = Guid.NewGuid().ToString(); var loginUserMsg = ResponseHelper <object> .SetLoginMsg(guid, loginUser.account, loginUser.roleId, loginUser.powerNum); HttpContext.Current.Session[guid] = loginUser.account; HttpContext.Current.Session.Timeout = 30; responseData = ResponseHelper <object> .SendSuccessResponse(loginUserMsg); } else { responseData = ResponseHelper <object> .SendErrorResponse("登陆失败,请检查账号或密码是否正确"); } } catch (Exception ex) { responseData = ResponseHelper <object> .SendErrorResponse("登陆失败: " + ex.Message); } return(responseData); }
public ResponseData <RoleTb> UserRegister([FromBody] RoleTb entity) { ResponseData <RoleTb> responseData; RoleTb user = new RoleTb { account = entity.account, avatarUrl = "avatar//4f56e38d-1734-4f27-8e95-d542dedddfc8.jpg", nickName = entity.nickName, pwd = entity.pwd }; try { db.RoleTb.Add(user); if (db.SaveChanges() > 0) { responseData = ResponseHelper <RoleTb> .SendSuccessResponse(); } else { responseData = ResponseHelper <RoleTb> .SendErrorResponse("添加失败"); } } catch (Exception ex) { if (db.RoleTb.Where(u => u.isDel == false && u.account == user.account) != null) { responseData = ResponseHelper <RoleTb> .SendErrorResponse("账号已存在", Models.StatusCode.OPERATION_ERROR); } else { responseData = ResponseHelper <RoleTb> .SendErrorResponse(ex.Message); } } return(responseData); }
public async void SeedRoles() { var roleStore = new RoleStore <IdentityRole>(_context); if (!_context.Roles.Any(r => r.Name == ConstantRole.Cordinator)) { var role = new RoleTb(); role.Name = ConstantRole.Cordinator.ToString().Trim(); role.RoleId = "CORD001"; await _roleManager.CreateAsync(role); } if (!_context.Roles.Any(r => r.Name == ConstantRole.Employer)) { var role = new RoleTb(); role.Name = ConstantRole.Employer.ToString().Trim(); role.RoleId = "EMP001"; await _roleManager.CreateAsync(role); } if (!_context.Roles.Any(r => r.Name == ConstantRole.Student)) { var role = new RoleTb(); role.Name = ConstantRole.Student.ToString().Trim(); role.RoleId = "STD01"; await _roleManager.CreateAsync(role); } if (!_context.Roles.Any(r => r.Name == ConstantRole.Admin)) { var role = new RoleTb(); role.Name = ConstantRole.Admin.ToString().Trim(); role.RoleId = "Admin"; await _roleManager.CreateAsync(role); } if (!_context.Roles.Any(r => r.Name == ConstantRole.SchSuper)) { var role = new RoleTb(); role.Name = "School Supervisor"; role.RoleId = ConstantRole.SchSuper.ToString().Trim(); await _roleManager.CreateAsync(role); } if (!_context.Roles.Any(r => r.Name == ConstantRole.AgencySuper)) { var role = new RoleTb(); role.Name = "Agency Supervisor"; role.RoleId = "Ags001"; await _roleManager.CreateAsync(role); } var getadmin = await _userManager.FindByEmailAsync("*****@*****.**"); if (getadmin == null) { var userd = new AppUserTab { Email = "*****@*****.**", UserName = "******", RealName = "Bssl Administrator" }; await _userManager.CreateAsync(userd, "Oj5!%hs17"); await _userManager.AddToRoleAsync(userd, SiwesData.ConstantRole.Admin); } // var adminroleid = await _roleManager.FindByNameAsync("Admin"); // var submenulist = _context.SubMenu.ToList(); // var saveadminmenu = new MenuAccess() ; //// saveadminmenu.RoleId = adminroleid.Id; // using (var saved = new MenuAccess()) // { // foreach (var dd in submenulist) // { // saved.RoleId = adminroleid.Id; // saved.Id = dd.Id; // } // _context.MenuAccess.Add(saved); // await _context.SaveChangesAsync(); // } // foreach(var ddd in submenulist) // { // MenuAccess savemenu = new MenuAccess( // { // savemenu.RoleId = adminroleid.Id, // savemenu.Id = ddd.Id, // }); // } // using (var ctx = new ApplicationDbContext() ) // { // foreach (var value in saveadminmenu) // { // value.Username = user; // value.Changed = DateTime.Now; // ctx.UOSChangeLog.Add(value); // } // ctx.SaveChanges(); // return true; // } //} // foreach (var dd in submenulist) // { // saveadminmenu.RoleId = adminroleid.Id; // saveadminmenu.SubMenuId = dd.Id; // _context.MenuAccess.Add(saveadminmenu); // await _context.SaveChangesAsync(); // } //using (var ctx = new MenuAccess) //{ // saveadminmenu(u => { u. = user; u.Changed = DateTime.Now; }); // var test = ctx.UOSChangeLog.AddRange(values); // ctx.SaveChanges(); // return true; //} //using (menuAccess = new MenuAccess()) //{ // foreach (var dd in saveadminmenu) // { // roleid = user; // value.Changed = DateTime.Now; // ctx.UOSChangeLog.Add(value); // } // ctx.SaveChanges(); // return true; //} //var newMonthlyAssessment = new MenuAccess //{ // RoleId = adminroleid.Id, // SubMenuId = submenulist, //}; }
public async Task <ResponseData <object> > UploadAvatar() { ResponseData <object> responseData; string userGuid = HttpContext.Current.Request.Form["guid"]; if (SessionHelper.IsExist(userGuid)) { string adminAccount = HttpContext.Current.Session[userGuid].ToString(); RoleTb user = db.RoleTb.Where(u => u.account == adminAccount).FirstOrDefault(); if (user != null) { string uploadFolderPath = HostingEnvironment.MapPath("~/avatars"); if (!Directory.Exists(uploadFolderPath)) { Directory.CreateDirectory(uploadFolderPath); } Guid imgGuid = Guid.NewGuid(); List <string> files = new List <string>(); var provider = new WithExtensionMultipartFormDataStreamProvider(uploadFolderPath, imgGuid); try { // Read the form data. await Request.Content.ReadAsMultipartAsync(provider); // This illustrates how to get the file names. foreach (var file in provider.FileData) { string fileName = Path.Combine("avatars", Path.GetFileName(file.LocalFileName)); files.Add(fileName); user.avatarUrl = fileName; db.Entry(user).State = System.Data.Entity.EntityState.Modified; } if (db.SaveChanges() > 0) { responseData = ResponseHelper <object> .SendSuccessResponse(files); } else { responseData = ResponseHelper <object> .SendErrorResponse("头像上传失败"); } } catch (Exception ex) { responseData = ResponseHelper <object> .SendErrorResponse(ex.Message); } } else { responseData = ResponseHelper <object> .SendErrorResponse("登陆失效", Models.StatusCode.OPERATION_ERROR); } } else { responseData = ResponseHelper <object> .SendErrorResponse("未登录", Models.StatusCode.OPERATION_ERROR); } return(responseData); }