public ActionResult InsertRoleMenu(int?id)
{
user_role userRole = Db.user_role.Find(id);
if (userRole != null)
{
ViewBag.user_role_name = userRole.user_role_name;
ViewBag.user_role_id = userRole.user_role_id;
}
ViewBag.MainMenuids = Db.tbl_Manu_Role_mapping.Where(x => x.Roleid == id).Select(a => a.MainMenuid).ToList();
ViewBag.SubMenuids = Db.tbl_Manu_Role_mapping.Where(x => x.Roleid == id).Select(a => a.SubMenuid).ToList();
ViewBag.SubMenuSecondids = Db.tbl_Manu_Role_mapping.Where(x => x.Roleid == id).Select(a => a.SubMenuSecondid).ToList();
MenuiVm menuiVm = new MenuiVm()
{
MainMenus = Db.tbl_MainMenu.OrderBy(x => x.sl).ToList(),
SubMenu = Db.tbl_SubMenu.OrderBy(x => x.sl).ToList(),
SubMenuSecond = Db.tbl_SubMenuSecond.OrderBy(x => x.sl).ToList()
};
return(View(menuiVm));
}
public AllLoggedUserInfo()
{
user = new user();
user_role = new user_role();
userdata = new userdata();
role = new role();
}
public ActionResult SignUp(user u)
{
var userControl = bdg.users.Any(x => x.USERNAME == u.USERNAME || x.USEREMAIL == u.USEREMAIL);
if (userControl)
{
ModelState.AddModelError("Error", "Email veya kullanıcı adı alınmış");
return(View());
}
else
{
u.WRITER = false;
u.APPROVED = true;
u.ACTIVE = true;
u.DATEOFREGISTRATION = DateTime.Now;
bdg.users.Add(u);
bdg.SaveChanges();
role member = bdg.roles.FirstOrDefault(x => x.ROLENAME == "Üye");
user_role ur = new user_role();
ur.ROLEID = member.ROLEID;
ur.USERID = u.USERID;
bdg.user_role.Add(ur);
bdg.SaveChanges();
return(RedirectToAction("Login"));
}
}
public async Task RegistAndInit(user_role role)
{
var initRole = Context.ActorOf <InitRole>();
if (!role.registed)
{
var registRes = await Context.ActorOf <Regist>().Ask <RegistResut>(new RegistParam()
{
username = role.username
});
if (registRes.code != 0)
{
logger.Error("注册失败：" + registRes.message);
return;
}
}
var res = await initRole.Ask <LoginResult>(role);
if (res.code != 0)
{
logger.Error("初始失败：" + res.message);
}
}
public ActionResult user_role(user_role data)
{
if (data.ID > 0)
{
var regist = db.user_role.Where(i => i.ID == data.ID).SingleOrDefault();
if (regist != null)
{
if (data.USER_ID != null)
{
regist.USER_ID = data.USER_ID;
}
if (data.USER_ROLE1 != null)
{
regist.USER_ROLE1 = data.USER_ROLE1;
}
db.SaveChanges();
}
}
else
{
var reg = db.user_role.Add(data);
db.SaveChanges();
}
return(RedirectToAction("user_role"));
}
/// <summary>
/// 根据用户id删除对应的用户及该用户对应的分组和角色
/// </summary>
/// <param name="id">用户id</param>
/// <returns></returns>
public bool deleteuserRG(int id)
{
userRoleEx ure = new userRoleEx();
List <role> curroleList = ure.getRoleList(id);
userGroupEx uge = new userGroupEx();
List <group> curgroupList = uge.getGroupList(id);
user u = getUser(id);
bool uflag = db.Delete <user>(u);
if (curroleList.Count == 0 && curgroupList.Count == 0)
{
return(uflag);
}
else
{
bool urflag = true;
bool ugflag = true;
foreach (var item in curroleList)
{
user_role ur = ure.getUserRole(id, item.id);
urflag = db.Delete <user_role>(ur);
}
foreach (var item in curgroupList)
{
user_group ug = uge.getUserGroup(id, item.id);
ugflag = db.Delete <user_group>(ug);
}
return(uflag & urflag & ugflag);
}
}
public LoginActor()
{
ReceiveAsync <LoginTask>(async(task) =>
{
device = task.device;
role = task.role;
data = task.data;
serverApi = task.serverApi == null ? ServerApiManager.GetByRoleId(role.id) : task.serverApi;
if (serverApi == null)
{
InitServerApi();
task.serverApi = serverApi;
}
if (data == null)
{
task.data = data = new role_data()
{
role_id = role.id
};
}
task.serverApi = serverApi;
Sender.Tell
(
await Context.ActorOf <MemberActor>().Ask <bool>(task) &&
await Context.ActorOf <ApiLoginActor>().Ask <bool>(task) &&
await Context.ActorOf <LoginToMemberCenterActor>().Ask <bool>(task)
);
});
}
public ActionResult DeleteConfirmed(int id)
{
user_role user_role = db.user_role.Find(id);
db.user_role.Remove(user_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult SaveEditRole(user_role model)
{
var user = db.user_role.Find(model.Id);
user.roleid = model.roleid;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "user_role_id,user_role_name,user_role_code,user_role_status,isOnlineLogin,isReportView,isCreate,isEdit,isDelete")] user_role user_role)
{
if (ModelState.IsValid)
{
db.Entry(user_role).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user_role));
}
private static async Task Battle(user_role role)
{
logger.Info(role.username);
var db = new Db();
var roleData = db.GetRoleDataByRoleId(role.id);
var device = db.GetDeviceById(role.device_id);
battleStart:
var result = await system.ActorOf <BattleSetup>().Ask <BattleSetupResult>(new BattleSetupParam()
{
questId = "1000000",
roleId = role.id,
});
if (result.code != 0)
{
if (result.code == -500)
{
Interlocked.Increment(ref loginError);
}
if (loginError > 10)
{
registError = true;
return;
}
logger.Error(role.username + "开始战斗失败：" + result.message);
return;
}
var sec = rnd.Next((int)TimeSpan.FromMinutes(1).TotalSeconds, (int)TimeSpan.FromMinutes(3).TotalSeconds);
var sleepTime = (TimeSpan.FromSeconds(sec));
logger.Info("战斗开始成功，等待" + sleepTime.Minutes + "分" + sleepTime.Seconds + "秒");
await Task.Delay(sleepTime);
var rresult = await system.ActorOf <BattleResult>().Ask <BattleResultResult>(new BattleResultParam()
{
roleId = role.id,
battleId = result.battleId
});
if (rresult.code != 0)
{
Interlocked.Increment(ref loginError);
if (loginError > 10)
{
registError = true;
return;
}
logger.Error(role.username + "开始结束失败：" + rresult.message);
return;
}
Interlocked.Exchange(ref loginError, 0);
logger.Info(role.username + "结束战斗成功");
goto battleStart;
}
public void InsertUser_role(user_role user_role)
{
if ((user_role.EntityState != EntityState.Detached))
{
this.ObjectContext.ObjectStateManager.ChangeObjectState(user_role, EntityState.Added);
}
else
{
this.ObjectContext.user_role.AddObject(user_role);
}
}
//
public async Task insertnewUserRole(user_role result)
{
using var cmd = Db.Connection.CreateCommand();
cmd.CommandText = @"insert into db_final.user_to_role (user_id,role_id) values(@id,@roleName);";
BindId6(cmd, result.UserId, result.RoleId);
cmd.CommandText = cmd.CommandText;
await cmd.ExecuteNonQueryAsync();
}
public ActionResult Create(user_role user_role)
{
if (ModelState.IsValid)
{
db.user_role.Add(user_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user_role));
}
public void DeleteUser_role(user_role user_role)
{
if ((user_role.EntityState != EntityState.Detached))
{
this.ObjectContext.ObjectStateManager.ChangeObjectState(user_role, EntityState.Deleted);
}
else
{
this.ObjectContext.user_role.Attach(user_role);
this.ObjectContext.user_role.DeleteObject(user_role);
}
}
public IActionResult UserRoleUpdate([FromBody] user_role model)
{
try
{
model.updated_on = DateTime.Now;
this._repository.Update(model);
return(Ok(new { Type = "S", Message = "User Role Updated Sucessfully" }));
}
catch (Exception e)
{
return(Ok(new { Type = "E", Message = e.Message }));
}
}
public IActionResult UserRoleInsert([FromBody] user_role model)
{
try
{
model.created_on = DateTime.Now;
long id = this._repository.Insert(model);
return(Ok(new { Type = "S", Message = "User Role Created Sucessfully", Id = id }));
}
catch (Exception e)
{
return(Ok(new { Type = "E", Message = e.Message }));
}
}
//common lib
public bool Insert(user_role entity)
{
try
{
db.user_role.Add(entity);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public AllLoggedUserInfo(user tem)
{
user = new user();
user_role = new user_role();
userdata = new userdata();
veebdbEntities data = new veebdbEntities();
user = data.users.Where(m => m.Id == tem.Id).FirstOrDefault();
user_role = data.user_role.Where(m => m.userid == user.Id).FirstOrDefault();
userdata = data.userdatas.Where(m => m.userid == user.Id).FirstOrDefault();
role = data.roles.Where(m => m.Id == user_role.roleid).FirstOrDefault();
}
public ActionResult SaveSignup(user user)
{
user.status = "active";
user.createdate = DateTime.Now;
user.updatedate = DateTime.Now;
user.type = 1;
user.discount = 0;
db.users.Add(user);
db.SaveChanges();
user_role ur = new user_role();
ur.userid = user.Id;
ur.roleid = 6;
ur.status = "active";
db.user_role.Add(ur);
userdata ud = new userdata();
ud.userid = user.Id;
db.userdatas.Add(ud);
db.SaveChanges();
var t = SendTemplateEmail(user.email, user.email, "", "Email register success", 1);
var tem = db.users.FirstOrDefault(m => m.username == user.username && m.password == user.password);
if (tem != null)
{
Session["LoggedAccount"] = null;
AllLoggedUserInfo userFullInfo = new AllLoggedUserInfo(tem);
Session["LoggedAccount"] = userFullInfo;
string decodedUrl = "";
if (!string.IsNullOrEmpty(Url.Action("AccountInfo", "Account", new { id = user.Id })))
{
decodedUrl = Server.UrlDecode(Url.Action("AccountInfo", "Account", new { id = user.Id }));
}
if (decodedUrl != "" && !decodedUrl.Contains("Login"))
{
return(Redirect(decodedUrl));
}
if (userFullInfo.role.RoleName == "super_admin")
{
return(RedirectToAction("Index", "Admin"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Home", new { message = "Acount do not exist." }));
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
user_role user_role = db.user_role.Find(id);
if (user_role == null)
{
return(HttpNotFound());
}
return(View(user_role));
}
public bool Update(user_role entity)
{
try
{
var info = db.user_role.Find(entity.id);
info.name = entity.name;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
///保存用户的角色
/// </summary>
/// <param name="userid">用户id</param>
/// <param name="permissionIds">角色授权</param>
public void SaveUserRoleMap(int userid, string permissionIds)
{
string roleIdLists = permissionIds;
string[] strids = roleIdLists.Split(',');//角色ID集合
bool flag = false;
int intflag = 0;
string msg = string.Empty;
try
{
//保存用户角色的权限关系
List <role> oldroles = IdalCommon.IuserRoleEx.getUserRole(userid);//用户的所有角色对象
user_role newu_r = new user_role();
string roleListStr = " ";
foreach (role r in oldroles)
{
if (!roleIdLists.Contains(r.id.ToString()))
{
IdalCommon.IuserRoleEx.deleteUerRole(userid, r.id);
}
}
for (int i = 0; i < strids.Length; i++)//循环选中的角色
{
if (int.Parse(strids[i]) != 0)
{
newu_r.userid = userid;
newu_r.roleid = int.Parse(strids[i]);
intflag = IdalCommon.IuserRoleEx.insert(newu_r);//在关联表中添加btn或者menu关系
if (-1 == intflag)
{
flag = true;
}
else
{
flag = false;
}
roleListStr += IdalCommon.IroleEx.getEntityById(int.Parse(strids[i])).rolename + ',';
Dictionary <string, object> UserList = new Dictionary <string, object>();
UserList["rolelist"] = roleListStr.Trim(',');
IdalCommon.IuserEx.update(userid, UserList);
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
}
public async Task <IActionResult> insertnewUserRole([FromBody] user_role body)
{
await Db.Connection.OpenAsync();
var query = new BlogPostQuery(Db);
var result = new user_role();
result.UserId = body.UserId;
result.RoleId = body.RoleId;
await query.insertnewUserRole(result);
return(new OkObjectResult(result));
}
public async Task <List <user_role> > ReadAllUserRole(DbDataReader reader)
{
var posts = new List <user_role>(); // create an array of blogpost
using (reader)
{
while (await reader.ReadAsync())
{
var post = new user_role()
{
UserId = reader.GetInt32(0),
RoleId = reader.GetInt32(1),
};
posts.Add(post);
}
}
return(posts);
}
public ActionResult Create(user_role role)
{
if (ModelState.IsValid)
{
var dao = new user_role_dao();
bool result = dao.Insert(role);
if (result)
{
SetAlert(StaticResources.Resources.Pub_InsertSuccess, "success");
return(RedirectToAction("Create", "UserRole"));
}
else
{
ModelState.AddModelError("", StaticResources.Resources.InsertUserRoleFailed);
}
}
return(View());
}
public ActionResult Edit(user_role group)
{
if (ModelState.IsValid)
{
var dao = new user_role_dao();
var result = dao.Update(group);
if (result)
{
SetAlert(StaticResources.Resources.Pub_UpdateSucess, "success");
return(RedirectToAction("Index", "UserRole"));
}
else
{
ModelState.AddModelError("", StaticResources.Resources.UpdateUserRoleFailed);
}
}
return(View());
}
private async Task <JsonResult <JsonModel> > Login(user_role role, device device)
{
var loginActor = AkkaSystem.LoginActor();
if (loginActor != null)
{
var result = await loginActor.Ask <LoginResult>(new LoginParam()
{
device = device,
role = role,
home = true
}, TimeSpan.FromMinutes(1));
if (result == null)
{
return(Json(-1, "登陆失败，内部执行出错"));
}
return(Json(result.code, result.message));
}
return(Json(-500, "loginActor is null"));
}
public void InsertthreeloginInfo(threeloginInfo threeloginInfo)
{
try
{
if (isLegalUsername(threeloginInfo.useName))
{
userEx ue = new userEx();
ue.setPassword(threeloginInfo.useName, threeloginInfo.uid);
user table = getUser(threeloginInfo.useName);
db.Insert <user>(table).ObjToInt();
user_role ur = new user_role();
ur.roleid = 32;
ur.userid = getUser(table.username).id;
ur.rolescode = 0;
db.Insert <user_role>(ur).ObjToInt();
}
}
catch (Exception ex)
{
}
}
public ActionResult wRole(int id)
{
user u = bdg.users.FirstOrDefault(x => x.USERID == id);
u.APPROVED = true;
user_role ur = new user_role();
ur = bdg.user_role.FirstOrDefault(x => x.USERID == id);
bdg.user_role.Remove(ur);
bdg.SaveChanges();
role writer = bdg.roles.FirstOrDefault(x => x.ROLENAME == "Yazar");
ur.ROLEID = writer.ROLEID;
ur.USERID = id;
bdg.user_role.Add(ur);
bdg.SaveChanges();
return(RedirectToAction("wApproved"));
}
public static user_role Createuser_role(long id_user, long id_role)
{
user_role user_role = new user_role();
user_role.id_user = id_user;
user_role.id_role = id_role;
return user_role;
}
public void AddTouser_role(user_role user_role)
{
base.AddObject("user_role", user_role);
}