public bool Delete(string userId) { bool result = false; UserProfile profile = UserProfile.GetByUserId(userId); if (profile != null) { int addressId = profile.AddressId; profile.Delete(); Address addr = Address.GetById(addressId); addr.Delete(); } UserRole roles = new UserRole(); roles.DeleteUserRoles(userId); result = deleteUser(userId); return result; }
public static List<UserRole> GetAllUserRoles() { List<UserRole> roles = new List<UserRole>(); string sql = @"select * from AspNetRoles"; try { using (SqlConnection conn = new SqlConnection(DataConnection.AppData)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UserRole role = new UserRole(); role.RoleId = reader["Id"].ToString(); role.RoleName = reader["Name"].ToString(); roles.Add(role); } } } } catch (Exception e) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrLogger.Log(_className, methodName, e.Message); roles.Clear(); } return roles; }
// Check if a User assigned to specific role or any public static bool IsInRole(string userId, string roleName = null) { bool result = false; string sql = @"select u.UserId, u.RoleId, r.Name as RoleName from AspNetUserRoles u left join AspNetRoles r on r.Id=u.RoleId where u.UserId=@UserId" + ( roleName == null ? "" : " and r.Name=@RoleName"); try { using (SqlConnection conn = new SqlConnection(DataConnection.AppData)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@UserId", userId); cmd.Parameters.AddWithValue("@RoleName", roleName); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { UserRole userRole = new UserRole(reader); result = userRole != null; } } } } catch (Exception e) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrLogger.Log(_className, methodName, e.Message); result = false; } return result; }
private bool CheckHasUserRole(int userId, UserRole role) { lock (loggedInUsersLockObject) { UserContextEntity user = loggedInUsers.FirstOrDefault(c => c.Id.Equals(userId)); if (user == null) return false; return (user.Role & role) != 0; } }
private UserContext AddUserToDatabase(string firstName, string lastName, string login, string password, UserRole role) { if (String.IsNullOrEmpty(firstName)) throw new ArgumentNullException("firstName is null"); if (String.IsNullOrEmpty(lastName)) throw new ArgumentNullException("lastName is null"); if (String.IsNullOrEmpty(login)) throw new ArgumentNullException("login is null"); if (String.IsNullOrEmpty(password)) throw new ArgumentNullException("password is null"); UserContextEntity newUser = null; using (var db = new DataAccessProvider()) { //sprawdzenie czy dany login już istnieje var userSameLogin = db.Users.FirstOrDefault(u => u.Role == role && u.Login == login); if (userSameLogin != null) throw new ArgumentException(String.Format("There already is an user with login = {0}.", login)); newUser = new UserContextEntity() { Login = login, FirstName = firstName, LastName = lastName, Role = role }; newUser = db.Users.Add(newUser); db.SaveChanges(); var userPassword = new PasswordEntity() { UserId = newUser.Id, Hash = HashClass.CreateSecondHash(password) }; db.Passwords.Add(userPassword); db.SaveChanges(); } return new UserContext(newUser); }
public ActionResult CreateUser(LoanViewModel lvm, FormCollection form) { GLobalClient cc = new GLobalClient(); try { if (lvm != null) { string value = lvm.AccountsModel.Email; string password = lvm.AccountsModel.pasword; string confirmpass = lvm.AccountsModel.confirmPassword; bool validatePass = ValidatePassword(password, confirmpass); var EncrypPassword = new CryptographyManager().ComputeHash(password, HashName.SHA256); password = EncrypPassword; lvm.AccountsModel.confirmPassword = password; lvm.AccountsModel.pasword = password; lvm.AccountsModel.Email = value; lvm.AccountsModel.Referal = Convert.ToString(form["Referal"]); if (validatePass == false) { TempData["Message"] = "Password And Confirm Password Must Match"; } else if (validatePass == true) { bool val = DataReaders.Validate(value); if (val == true) { TempData["Message"] = "User Already Exist"; // return RedirectToAction("Signup", "Home", new { area = "" }); ViewBag.channel = db.MarketingChannels; return(View("Signup")); } else if (val == false) { lvm.AccountsModel.Date = DateTime.Now; lvm.AccountsModel.DateTim = DateTime.Today; lvm.AccountsModel.isVissibles = 1; // This is For the Api // cc.CreateUser(lvm.AccountsModel); User users = new DataAccess.User(); users.confirmPassword = lvm.AccountsModel.confirmPassword; users.pasword = lvm.AccountsModel.pasword; users.Email = lvm.AccountsModel.Email; users.Date = lvm.AccountsModel.Date; users.DateTim = lvm.AccountsModel.DateTim; users.isVissibles = lvm.AccountsModel.isVissibles; users.firstname = lvm.AccountsModel.firstname; users.lastname = lvm.AccountsModel.lastname; users.Phone = lvm.AccountsModel.Phone; users.Referal = lvm.AccountsModel.Referal; //string lastid = "0"; //users.MyReferalCode = MyUtility.getReferralCode(lastid); users.ReferralLevel = MyUtility.getRefferalLevel(users.Referal); // users.MyReferalCode = int id = DataCreators.CreateUser(users); var channellist = Request["checkboxName"]; if (channellist != null) { string[] arr = channellist.Split(','); var chanList = removestring(arr); if (arr.Length > 0) { for (var i = 0; i < arr.Length; i++) { string arrc = Convert.ToString(arr[i]); insertMarketChannel(arrc, id); } } } if (id != 0) { string lastid = id.ToString(); users.MyReferalCode = MyUtility.getReferralCode(lastid); DataCreators.updatelastID(users); DataAccess.UserRole userroles = new DataAccess.UserRole(); userroles.UserId = id; userroles.RoleId = Convert.ToInt16(ConfigurationManager.AppSettings["DefaultUser"]); userroles.IsVissible = 1; userroles.dates = DateTime.Now; DataCreators.InsertUserRoles(userroles); TempData["Message"] = "User Created Succesfully"; //For LoggedIn User Session["id"] = lvm.AccountsModel.Email; Session["User"] = Session["id"]; var LoggedInuser = new LogginHelper(); user = LoggedInuser.LoggedInUser(); SendEmail(lvm); string Regpage = ConfigurationManager.AppSettings["DefaultRegister"]; return(Redirect(Regpage)); //return RedirectToAction("Index", "Dashboard"); // return RedirectToAction("Dashboard", "Dashboard"); } else { TempData["Message"] = "Registration Not Succesful Please Try Again!"; ViewBag.channel = db.MarketingChannels; } } } } else { TempData["Message"] = "Error Creating User"; ViewBag.channel = db.MarketingChannels; } return(RedirectToAction("Signup", "Home", new { area = "" })); } catch (Exception ex) { WebLog.Log(ex.Message.ToString()); return(null); } }