public User GetUserByLogin(string login) { User user = new User(); if (!string.IsNullOrEmpty(login)) { _executerUserCmd executer = new _executerUserCmd(ExecuteUserSqlCmd); using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("GetUserByLogin", sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Login", login); user = executer(sqlConnection, cmd).FirstOrDefault(); if (user != null) { user.UserRoles = GetUserRolesByUserId(user.UserId); } } } } return(user); }
public List <User> GetUsers() { _executerUserCmd executer = new _executerUserCmd(ExecuteUserSqlCmd); List <User> users = new List <User>(); using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("GetUsers", sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; users = executer(sqlConnection, cmd); } return(users); } }
public User GetUserById(int userId) { User user = new User(); if (userId > 0) { _executerUserCmd executer = new _executerUserCmd(ExecuteUserSqlCmd); using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("GetUserById", sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", userId); user = executer(sqlConnection, cmd).FirstOrDefault(); } } } return(user); }