public G_User Login(string email, string passwd) { Commands cmd = new Commands("TSP_AuthUser", true); cmd.AddParameter("@Email", email); cmd.AddParameter("@Passwd", passwd); return(_connexion.ExecuteReader(cmd, dr => dr.ToUtilisateur()).SingleOrDefault()); }
public bool AddUserToRole(int UserId, int RoleId) { Commands command = new Commands("identity_AddUserToRole", true); command.AddParameter("@UserId", UserId); command.AddParameter("@RoleId", RoleId); return(_connection.ExecuteNonQuery(command) == 1); }
public IdentityResult Create(Roles role) { Commands command = new Commands("identity_InsertRole", true); command.AddParameter("@Name ", role.Name); command.AddParameter("@Description ", role.Description); command.AddParameter("@Created", role.Created); _connection.ExecuteNonQuery(command); return(IdentityResult.Success); }
public IdentityResult CreateUser(Utilisateurs user) { Commands command = new Commands("Identity_InsertUser", true); command.AddParameter("@Lastname", user.LastName); command.AddParameter("@FirstName", user.FirstName); command.AddParameter("@Email", user.Email); command.AddParameter("@Passwd", user.Passwd); command.AddParameter("@Genre", user.Genre); _connection.ExecuteNonQuery(command); return(IdentityResult.Success); }
public bool Register(G_User user) { Commands cmd = new Commands("TSP_register", true); cmd.AddParameter("@LastName", user.LastName); cmd.AddParameter("@FirstName", user.FirstName); cmd.AddParameter("@Email", user.Email); cmd.AddParameter("@Passwd", user.Passwd); cmd.AddParameter("@Genre", user.Genre); int rows = _connexion.ExecuteNonQuery(cmd); user.Passwd = null; return(rows == 1); }
public Utilisateurs FindById(string userId) { Commands command = new Commands("identity_FindById", true); command.AddParameter("@Id", Convert.ToInt32(userId)); return(_connection.ExecuteReader(command, sp => sp.ToUtilisateur()).SingleOrDefault()); }
public Utilisateurs FindByEmail(string normalizedEmail) { Commands command = new Commands("identity_FindByEmail", true); command.AddParameter("@Email", normalizedEmail); return(_connection.ExecuteReader(command, sp => sp.ToUtilisateur()).SingleOrDefault()); }
public Roles FindByName(string normalizedRoleName) { Commands command = new Commands("identity_FindRoleByName", true); command.AddParameter("@NormalizedRoleName", normalizedRoleName); return(_connection.ExecuteReader(command, sp => sp.ToRole()).SingleOrDefault()); }