public HttpResponseMessage Post(string userName, [FromBody] TblUser value, int n)
{
string accountId = CompetitionDB.Users.FirstOrDefault(x => x.UserName == userName).Id;
int id = CompetitionDB.TblUsers.FirstOrDefault(x => x.UserId == accountId).Id;
TblUser user = new TblUser();
user.Name = value.Name;
user.LastName = value.LastName;
user.BirthYear = value.BirthYear;
user.Lytis = value.Lytis;
user.Active = true;
user.UserId = "0";
user.TrainerId = id;
user.ClubId = CompetitionDB.TblUsers.Find(id).ClubId;
user.Email = "";
user.TelNumber = "";
user.TeamId = 0;
CompetitionDB.TblUsers.Add(user);
CompetitionDB.SaveChanges();
int idUser = CompetitionDB.TblUsers.FirstOrDefault(x => x.Name == user.Name && x.LastName == user.LastName).Id;
TblUserRole role = new TblUserRole();
//Pridedama "NEPILNAMEČIO DALYVIO" rolė
role.RoleId = 6;
role.UserId = idUser;
CompetitionDB.TblUserRoles.Add(role);
return(ToJsonCreated(CompetitionDB.SaveChanges()));
}
public UserResponseBO Authenticate(UserBO userBO)
{
using (var db = new dbGSCasinoContext())
{
UserAuthRepository userAuthRepository = new UserAuthRepository();
TblUserAuth userAuth = userAuthRepository.Get(userBO, db);
UserInfoRepository userInfoRepository = new UserInfoRepository();
TblUserInfo userInfo = userInfoRepository.Get(userAuth, db);
UserWalletRepository userWalletRepository = new UserWalletRepository();
List <UserWalletBO> userWallet = userWalletRepository.GetBO(userAuth, db);
UserRoleRepository userRoleRepository = new UserRoleRepository();
TblUserRole userRole = userRoleRepository.Get(userAuth, db);
UserResponseBO userAuthResponse = new UserResponseBO();
userAuthResponse.UserInfo = userInfo;
userAuthResponse.UserWallet = userWallet;
userAuthResponse.UserAuth = userAuth;
userAuthResponse.UserRole = userRole;
return(userAuthResponse);
}
}
public TblUserRole Create(TblUserAuth userAuth, dbGSCasinoContext db)
{
TblUserRole userRole = new TblUserRole();
userRole.UserAuthId = userAuth.Id;
userRole.IsEnabled = true;
userRole.AccessRole = AccessRole.Client.ToString();
db.TblUserRole.Add(userRole);
db.SaveChanges();
return(userRole);
}
public override CommonMessageResponse Message_Received(CommonMessage messageObj)
{
string osuId = Decode(OsuId);
if (string.IsNullOrEmpty(osuId))
{
return(new CommonMessageResponse(LoliReply.ParamMissing, messageObj));
}
BllUserRole bllUserRole = new BllUserRole();
int userNum = OldSiteApi.GetUser(OsuId, out var userObj);
if (userNum == 0)
{
return(new CommonMessageResponse(LoliReply.IdNotFound, messageObj, true));
}
if (userNum > 1)
{
// ignored
}
var role = bllUserRole.GetUserRoleByQq(long.Parse(messageObj.UserId));
if (role.Count != 0)
{
if (role[0].CurrentUname == userObj.username)
{
return(new CommonMessageResponse("我早就认识你啦.", messageObj, true));
}
string msg = role[0].CurrentUname + "，我早就认识你啦. 有什么问题请找Mother Ship（扔锅）";
return(new CommonMessageResponse(msg, messageObj, true));
}
var newRole = new TblUserRole
{
UserId = long.Parse(userObj.user_id),
Role = "creep",
QQ = long.Parse(messageObj.UserId),
LegacyUname = "[]",
CurrentUname = userObj.username,
IsBanned = false,
RepeatCount = 0,
SpeakingCount = 0,
Mode = 0,
};
int c = bllUserRole.InsertUserRole(newRole);
return(c < 1
? new CommonMessageResponse("由于各种强大的原因，绑定失败..", messageObj)
: new CommonMessageResponse("明白了，" + userObj.username + "，多好的名字呢.", messageObj));
}
public static async Task <bool> AddUserToRoleAsync(TblUsers user, int roleType, string description = null)
{
using (ComputerAccessoriesContext _db = new ComputerAccessoriesContext())
{
try
{
var role = _db.TblRoles.Where(x => x.Id == roleType).FirstOrDefault();
if (role == null)
{
TblRoles newRole = new TblRoles
{
Name = description,
NormalizedName = "Default",
};
_db.TblRoles.Add(newRole);
await _db.SaveChangesAsync();
TblUserRole userRole = new TblUserRole()
{
RoleId = newRole.Id,
UserId = user.Id
};
_db.TblUserRole.Add(userRole);
await _db.SaveChangesAsync();
return(true);
}
else
{
TblUserRole userRole = new TblUserRole()
{
RoleId = roleType,
UserId = user.Id
};
_db.TblUserRole.Add(userRole);
await _db.SaveChangesAsync();
return(true);
}
}
catch (Exception e)
{
return(false);
throw;
}
}
}
public TblUserRole Get(TblUserAuth userAuth, dbGSCasinoContext db)
{
var _qObj = from a in db.TblUserRole
where a.UserAuthId == userAuth.Id
select new TblUserRole
{
AccessRole = a.AccessRole,
IsEnabled = a.IsEnabled,
CreatedOn = a.CreatedOn,
Id = a.Id
};
TblUserRole userRole = _qObj.FirstOrDefault();
return(userRole);
}
public object SaveMenu(MenuSubMenuParam ObjMenu)
{
TblRoleMaster objrole = new TblRoleMaster();
objrole.Role = ObjMenu.Role;
objrole.Status = 1;
objrole.CreatedBy = 1;
objrole.CreatedDate = DateTime.Now;
db.TblRoleMasters.Add(objrole);
db.SaveChanges();
TblMenu objSubmenu = new TblMenu();
objSubmenu.RoleId = objrole.RoleId;
string[] sbno = ObjMenu.selectedid.Split(',');
for (int i = 0; i < sbno.Length; i++)
{
if (sbno[i] != "0")
{
objSubmenu.ModuleId = int.Parse(sbno[i]);
objSubmenu.CreatedBy = 1;
objSubmenu.CreatedDate = DateTime.Now;
objSubmenu.Status = 1;
db.TblMenus.Add(objSubmenu);
db.SaveChanges();
}
}
TblUserRole objuserrole = new TblUserRole();
objuserrole.RoleId = objrole.RoleId;
objuserrole.AllowInsert = ObjMenu.AllowInsert;
objuserrole.AllowEdit = ObjMenu.AllowEdit;
objuserrole.AllowDelete = ObjMenu.AllowDelete;
objuserrole.AllowView = ObjMenu.AllowView;
objuserrole.CreatedBy = 1;
objuserrole.CreatedDate = DateTime.Now;
objuserrole.Status = 1;
db.TblUserRoles.Add(objuserrole);
db.SaveChanges();
return("");
}
public async Task <IActionResult> LoginAsync([FromBody] UserBO userBO)
{
try
{
ApiRequest apiRequest = new ApiRequest();
ResponseBO _res = await apiRequest.PostAsync("User/Authenticate", userBO);
UserResponseBO apiResponse = JsonConvert.DeserializeObject <UserResponseBO>(_res.ResponseResult);
if (apiResponse.HttpStatusCode == "200")
{
SessionController sessionController = new SessionController();
sessionController.CreateSession(apiResponse, _res.ResponseCookies, HttpContext.Session);
TblUserInfo tblUserInfo = apiResponse.UserInfo;
TblUserAuth tblUserAuth = apiResponse.UserAuth;
TblUserRole tblUserRole = apiResponse.UserRole;
//if (tblUserRole.AccessRole.Equals("Admin") || tblUserRole.AccessRole.Equals("SuperAdmin"))
//{
// apiResponse.RedirectUrl = "/Admin/";
//}
//else
//{
// apiResponse.RedirectUrl = "/Dashboard/";
//}
apiResponse.RedirectUrl = "/Dashboard/";
return(Ok(apiResponse));
}
else
{
apiResponse.RedirectUrl = "/User/Login/Failed";
return(BadRequest(apiResponse));
}
}
catch (System.Exception e)
{
UserResponseBO apiResponse = new UserResponseBO();
apiResponse.RedirectUrl = "/User/Login/Failed";
apiResponse.Message = e.Message;
return(BadRequest(apiResponse));
//return Redirect("~/User/Login/Failed");
}
}
public HttpResponseMessage Post(string userName, [FromBody] TblUser user)
{
string accountId = CompetitionDB.Users.FirstOrDefault(x => x.UserName == userName).Id;
user.UserId = accountId;
user.Active = true;
CompetitionDB.TblUsers.Add(user);
CompetitionDB.SaveChanges();
int id = CompetitionDB.TblUsers.FirstOrDefault(x => x.UserId == accountId).Id;
TblUserRole role = new TblUserRole();
role.RoleId = 1;
role.UserId = id;
CompetitionDB.TblUserRoles.Add(role);
return(ToJsonCreated(CompetitionDB.SaveChanges()));
}
public int InsertUserRole(TblUserRole role)
{
DbHelper dbCabbage = new DbHelper("cabbage");
return(dbCabbage.ExecuteNonQuery(@"INSERT INTO userrole
(user_id,role,qq,legacy_uname,current_uname,is_banned,repeat_count,speaking_count,mode)
VALUES(@user_id,@role,@qq,@legacy_uname,@current_uname,@is_banned,@repeat_count,@speaking_count,@mode)",
new MySqlParameter("@user_id", role.UserId),
new MySqlParameter("@role", role.Role),
new MySqlParameter("@qq", role.QQ),
new MySqlParameter("@legacy_uname", role.LegacyUname),
new MySqlParameter("@current_uname", role.CurrentUname),
new MySqlParameter("@is_banned", role.IsBanned),
new MySqlParameter("@repeat_count", role.RepeatCount),
new MySqlParameter("@speaking_count", role.SpeakingCount),
new MySqlParameter("@mode", role.Mode)));
}
public HttpResponseMessage Post([FromBody] TblUserRole value)
{
CompetitionDB.TblUserRoles.Add(value);
return(ToJsonCreated(CompetitionDB.SaveChanges()));
}
public RoleModel(TblUserRole row)
{
Id = row.Id;
RoleId = row.RoleId;
}
