/// <summary> /// Inserts a new role for a user in the UserRoles table /// </summary> /// <param name="user">The User</param> /// <param name="roleId">The Role's id</param> /// <returns></returns> public void Insert(User user, int roleId) { using (var conn = db.GetOpenConnection()) { conn.Execute(@"INSERT INTO UserRole (UserID, RoleID) VALUES (@userId, @roleId)", new { userId = user.Id, roleId = roleId }); } }
/// <summary> /// Deletes a login from a user in the UserLogins table /// </summary> /// <param name="user">User to have login deleted</param> /// <param name="login">Login to be deleted from user</param> /// <returns></returns> public void Delete(User user, UserLogin login) { using (var conn = db.GetOpenConnection()) { conn.Execute(@"DELETE FROM UserLogin WHERE UserID = @userId AND LoginProvider = @loginProvider AND ProviderKey = @providerKey", new { userId = user.Id, loginProvider = login.LoginProvider, providerKey = login.ProviderKey }); } }
/// <summary> /// Inserts a new login in the UserLogins table /// </summary> /// <param name="user">User to have new login added</param> /// <param name="login">Login to be added</param> /// <returns></returns> public void Insert(User user, UserLogin login) { using (var conn = db.GetOpenConnection()) { conn.Execute(@"INSERT INTO UserLogin (LoginProvider, ProviderKey, UserID) VALUES (@loginProvider, @providerKey, @userId)", new { loginProvider = login.LoginProvider, providerKey = login.ProviderKey, userId = user.Id }); } }
public void Update(User user) { using (var conn = db.GetOpenConnection()) { if (user.UpdatedByUserID.HasValue && user.UpdatedByUserID == 0) user.UpdatedByUserID = null; var parameters = new DynamicParameters(user); string sql = @" UPDATE [User] SET UserName = @Email, Email = @Email, FirstName = @FirstName, LastName = @LastName, Gender = @Gender, DegreeID = @DegreeID, City = @City, CountryID = @CountryID, EmailConfirmed = @EmailConfirmed, PasswordHash = @PasswordHash, SecurityStamp = @SecurityStamp, PhoneNumber = @PhoneNumber, PictureUrl = @PictureUrl, PhoneNumberConfirmed = @PhoneNumberConfirmed, TwoFactorEnabled = @TwoFactorEnabled, LockoutEnabled = @LockoutEnabled, LockoutEndDateUtc = @LockoutEndDateUtc, AccessFailedCount = @AccessFailedCount, UpdatedDateUtc = GETUTCDATE(), UpdatedByUserID = @UpdatedByUserID WHERE UserID = @UserID"; conn.Execute(sql, parameters); } }
public int Insert(User user) { using (var conn = db.GetOpenConnection()) { var parameters = new DynamicParameters(user); string sql = @" INSERT INTO [User] (UserName, Email, FirstName, LastName, Gender, DegreeID, City, CountryID, EmailConfirmed, PasswordHash, SecurityStamp, PhoneNumber, PictureUrl, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEnabled, LockoutEndDateUtc, AccessFailedCount) VALUES (@Email, @Email, @FirstName, @LastName ,@Gender, @DegreeID, @City, @CountryID, @EmailConfirmed, @PasswordHash, @SecurityStamp, @PhoneNumber, @PictureUrl, @PhoneNumberConfirmed, @TwoFactorEnabled, @LockoutEnabled, @LockoutEndDateUtc, @AccessFailedCount); SELECT Cast(SCOPE_IDENTITY() AS INT)"; var id = conn.ExecuteScalar<int>(sql, parameters); user.UserID = id; return id; } }
public ArticleReviewer() { Reviewer = new User(); Template = new ReviewTemplate(); ReviewStatus = new ReviewStatus(); }
public void UpdateUser(User user) { throw new NotImplementedException(); }