public User GetUser(string name) { User item = null; SqlCommand cmd = new SqlCommand("dbo.uspGetUserByName", DbsConnections.SqlBCApp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DbsSqlParams.Direct("@Name", SqlDbType.VarChar, name)); if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { item = new User() { IdUsuario = reader.GetInt32(reader.GetOrdinal("IdUsuario")), Nombre = reader.GetString(reader.GetOrdinal("Nombre")), Apellido = reader.GetString(reader.GetOrdinal("Apellido")), Password = reader.GetString(reader.GetOrdinal("Password")) }; } reader.Close(); return(item); }
public static bool GetAuth(string Name, string NameP) { var command = new SqlCommand("uspAuth", DbsConnections.SqlBCApp) { CommandType = CommandType.StoredProcedure }; command.Parameters.Add(DbsSqlParams.Direct("@Name", SqlDbType.VarChar, Name)); command.Parameters.Add(DbsSqlParams.Direct("@NameP", SqlDbType.VarChar, NameP)); return(DbsSqlOperations.GetInt(command) == 1); }