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);
}
